how do i get last 10obs from a dataset when we don't know
about the number of obsevations in that dataset?
Answer Posted / raghu
proc sql;
select count(*) into : cnt from ds;
quit;
data ds1;
set ds(firstobs=%eval(&cnt-9) obs=&cnt);
run;
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
how to do user inputs and command line arguments in sas?
How you can read the variables that you need?
What is the function of output statement in a SAS Program?
Are you sensitive to code walk-throughs peer review or QC review?
how will you locate the sas platform applications? : Sas-bi
Difference between nodup and nodupkey options?
Explain the purpose of retain statement.
how are numeric and character missing values represented internally? : Sas programming
Approximately what date is represented by the SAS date value of 730?
what is intially documentation in sas?
What would be the value of month at the end of data step execution and how many observations would be there?
Explain data step in SAS
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?
do you prefer proc report or proc tabulate? Why? : Sas programming
what is snowflake schema? : Sas-di