Answer Posted / amaran
Can i used _n_ in proc sql; Or its only for Datasteo
_n_ is a Autometic variable created in a datastep. It is a
part of PDV. It is used to store the iteration count of the
Input statement.
Proc SQL doesnot create a PDV. so _n_ variable cannot be
used there.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the difficulties u faced while doing vital signs table or dataset?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
do you need to know if there are any missing values? : Sas programming
how will you locate the sas platform applications? : Sas-bi
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
Have you used macros? For what purpose you have used? : sas-macro
what is transformation in sas data integration? : Sas-di
how are numeric and character missing values represented internally? : Sas programming
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
What is proc sort?
Tell me more about the parameters in macro? : sas-macro
what is star schema? : Sas-di
What do the mod and int function do? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?