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
- 9440 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 |
How would you determine how far down on a page you have printed in order to print out footnotes?
What r all the reporting procedures...?
how does sas handle missing values in functions? : Sas programming
what is the main difference between rename and label? (don't say that they both perform the same function).
how to remove the duplicates by proc sql?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
how do you test for missing values? : Sas programming
i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
What is proc sort?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
Can you suggest us materials for sdtm mapping?
Teradata 
