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?
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 could you generate test data with no input data?
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
: and & modifiers.
What is the difference between SAS functions and procedures?
How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?
what is cummaltive frequency,and varience in proc unviarte
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What is the role of administrative users? : sas-grid-administration
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
How we can create SAS USER DEFINED CODE?
what other sas products have you used and consider yourself proficient in using? : Sas programming
What are the difference between ceil and floor functions in sas?