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
- 10102 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 |
explain the use of % includes a statement in sas? : Sas-administrator
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What is connection profile? : sas-grid-administration
what are the scrubbing procedures in sas? : Sas programming
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation
what do you mean by data staging area? : Sas-di
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore
what has been your most common programming mistake? : Sas programming
The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
Teradata 
