how do i get last 10obs from a dataset when we don't know
about the number of obsevations in that dataset?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shiva
data a;
do i=1 to 100;
output;
end;
run;
data data1;
set a nobs=tot;
if _n_ gt( tot-10) then output data1;
run;
Is This Answer Correct ? | 20 Yes | 4 No |
Answer / harshal r
data air;
set sashelp.air nobs=tot;
if _n_ gt( tot-10) then output;
run;
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / pratik
Suppose we have dataset like sasuser.admit.
we dontknow how many obs are there in this dataset.
then we can use
Proc contents data=sasuser.admit n;
run;
it will come the total no of obs in this dataset.
after doing this you will get 21 obs are there.
data dsn1;
set sasuser.admit(firstobs=12 obs=21);
run;
proc print data=dsn1;
run;
then you will get last 10 obs.
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sumit
data new;
set old;
n = _N_;
run;
Proc sort data = new;
by descending n;
run;
Option OBS= 10;
Proc sort data = new (drop = n);
by descending n;
run;
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / its me
Shiva, ur answer is also correct . and here goes another
one dear..
data W;
set X;
if _n_ > 95 then output;
run;
As the total no. of obs are 100, the last five observations
will be be in ur output dataset..
Cheers!!!
Is This Answer Correct ? | 1 Yes | 14 No |
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
What are the five ways to do a table lookup in sas? : sas-grid-administration
SAS System ?
how will you location sas platform applications available from web browser? : Sas-bi
In the flow of DATA step processing, what is the first action in a typical DATA Step?
What is the difference between informat and format statement?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
what is the diff b/w verification validation in sas
how do u identify a macro variable
How to write duplicate records into a separate dataset using sort?
Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having <some condition>. Is the above program run correctly, if not why ?