Interested to Buy Any Domain ? << Click Here >> for more details...
1.What is the difference between _NULL_ , _ALL_, and _N_?
2.What are the uses of _NULL_ using in Data Steps? Can we
_NULL_ in Proc Steps also?
3.How do call the macro variable in Data Steps?
4.How to construct Pivot tables in Excel Using SAS?
- 3 Answers
- 10289 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandrakanth
_null_ will act like any other data step but it would not create any data set.
_all_ will select all the variables in a particular data set.
_n_ is the automatic variable generated by SAS which counts the number of loops SAS moved to the top of data set
(but some people say it is total number of observations which is not always true)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / aravind9882
_null_ is used in datstep not to create a dataset.
_all_ means all..foe instance all variables like char and
numeric...if u use in ods statement like ods _all_ close
closes the all d destinations u have opened instead of
writing each...
u can cal a macro bariable using '&' lke call symget...
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / pnprasad
1. _NULL_ is not create Out put DataSet, it opens the file
to write the dataset. _ALL_ for display contents in the
library & used in cose the files in ODS and _N_ for search
for Null characters.
| Is This Answer Correct ? | 0 Yes | 19 No |
What do the SAS log messages "numeric values have been converted to character" mean?
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
what do the pad and dim functions do? : Sas programming
how do you pull data from equifax?tell me the process?
0 Answers Synchrony Financial,
I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?
what are the sites did u refer for enquiries and doubts for SAS
Do you need to know if there are any missing values?
What is the difference between nodupkey and nodup options?
why a stop statement is needed for the point= option on a set statement?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
what is data access? : Sas-di
Teradata 
