topic get last 10 obs in SAS Programming

get last 10 obs

GeorgeSAS — Wed, 09 Oct 2019 15:07:30 GMT

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!

Re: get last 10 obs

Tom — Wed, 09 Oct 2019 15:30:20 GMT

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

Re: get last 10 obs

Ksharp — Thu, 10 Oct 2019 12:01:11 GMT

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

Re: get last 10 obs

GeorgeSAS — Thu, 10 Oct 2019 13:07:50 GMT

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

Re: get last 10 obs

srikanth421 — Mon, 14 Sep 2020 15:07:42 GMT

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.