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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to read the variables in sas? : Sas-administrator

547


what are the categories that sas informats are used to the place the data? : Sas-administrator

607


Intern stastical programmer written test

276


what is treatment emergent events and treatment emregent adverse event

1932


what is sas olap server? : Sas-di

681






How long can a macro variable be? A token? : sas-macro

710


If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

588


How do you delete duplicate observations in sas?

563


what is the function of catx syntax? : Sas-administrator

636


Can you suggest us materials for sdtm mapping?

4028


What is the purpose of trailing @ and @@? How do you use them?

604


how does sas handle missing values in functions? : Sas programming

591


What are common programming errors committed in sas

663


Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

1764


What is the use of PROC gplot?

629