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 |
what does .. meant in sas macros
What is the function of output statement in a SAS Program?
How could you generate test data with no input data?
Why and when do you use proc sql?
how does sas handle missing values in sort order? : Sas programming
what type of graphs we will create(for 2+years candidates)?
What Proc glm does?
how to handle in stream data containing semicolon in it?
What are the ways in which macro variables can be created in sas programming?
how do you read binary data in sas?
Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190
Which command is used to perform sorting in sas program?