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 |
how we can call macros with in data step?
Which statement does not perform automatic conversions in comparisons?
How do you download a flat file from Mainframe to your local PC using SAS?
What areas of SAS are you most interested in?
i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.
How to read an input file in sas?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
name some data transformation used in sas di? : Sas-di
What is factor analysis?
What other SAS features do you use for error trapping and data validation?