Interested to Buy Any Domain ? << Click Here >> for more details...
how do i get last 10obs from a dataset when we don't know
about the number of obsevations in that dataset?
- 7 Answers
- 13547 Views
- TCS, I also Faced
- E-Mail Answers
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 is SAS? What are the functions does it performs?
Are you familiar with special input delimiters How are they used?
which domain is better in sas? clinical trails or banking
I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak
what is the use of LRECL option.
what is treatment emergent events and treatment emregent adverse event
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
What is PROC in SAS?
i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?
How to read multiple excel sheets from a single excel file at once????
7 Answers HCL, Verinon Technology Solutions,
Explain the purpose of retain statement.
if x=round(26.3,10)-1 then x= how much and how explain?
Teradata 
