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
- 9472 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the role of administrative users? : sas-grid-administration
How many ways to overcome a missing values???
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
Differentiate between proc means and proc summary.
how sas deals with business intelligence? : Sas-bi
What is SAS? What are the functions does it performs?
Which command is used to perform sorting in sas program?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
How does proc sql work?
What is slibref?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
What areas of SAS are you most interested in?
what is business intelligence? : Sas-bi
What are the limitations for memory allocation for SAS variables
Explain how you can debug and test your SAS program?
