get last 10 obs

[GeorgeSAS]

Hello everyone,

I have a large dataset I don't know how many rows it has. I want its last 10 obs. Can I to do it in one data step?

Data want;

set bigdata(firstobs=max-9);

run;

Thanks!

[Tom · Accepted solution]

data want;
  do p=max(1,nobs-9) to nobs;
    set bigdata nobs=nobs point=p;
    output;
  end;
  stop;
run;

[Ksharp]

data want;
 set sashelp.class nobs=nobs;
 if _n_>nobs-10;
run;

[GeorgeSAS]

Thanks, this work on small data but it will take long time on big data

[srikanth421]

Better solution is to figure out the total number of observations in your data using proc contents.  Then in proc print use firstobs=number of obs - 10 instead of obs=10.