Answer Posted / chandra sekar
_N_ gives the record number. You can access any record in
the dataset using _N_ if you know the record number. It is
set as 1 for the first record and incremented for every
subsequent record. It is an automatic variable and is not
visible when you open a dataset. This can also be used to
subset a data. For ex, if you want to access the first 100
records then you can say "if _N_ <= 100".
| Is This Answer Correct ? | 63 Yes | 2 No |
Post New Answer View All Answers
What Proc glm does?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What is PROC in SAS?
Explain how you can debug and test your SAS program?
which features do you use to check the data validations and errors? : Sas-administrator
What is the difference between the proc sql and data step?
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.
how sas deals with business intelligence? : Sas-bi
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What does the RUN statement do?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
where are dashboard components are created and maintained? : Sas-bi
How to include or exclude specific variables in a data set?