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
- 10145 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 to display duplicate observations in data?
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
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;
What is difference between (a-z) and (a--z)
How can you put a "trace" in your program?
What is connection profile? : sas-grid-administration
We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
Mention how to limit decimal places for the variable using proc means?
How do you read in the variables that you need?
name several ways to achieve efficiency in your program? : Sas programming
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Teradata 
