topic How to read last few records into a dataset in SAS Programming

How to read last few records into a dataset

vThanu — Sat, 23 Feb 2019 12:40:10 GMT

I want to import a file and in that file I want to read only last 10 records (not sure how many observation/records we have in that file)?

thanks in advance..

Re: How to read last few records into a dataset

Ksharp — Sat, 23 Feb 2019 12:59:52 GMT

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

Re: How to read last few records into a dataset

Kurt_Bremser — Sat, 23 Feb 2019 13:06:13 GMT

After import, SAS knows the record number:

data want;
set imported nobs=all_obs;
if _n_ > all_obs - 10;
run;

If you absolutely want to do it in the import data step, you can use an external command:

filename oscmd pipe "wc -l &filename.";

data _null_;
infile oscmd;
input lines;
call symputx('lines',lines);
run;

data want;
infile "&filename." /* other options */;
input
........
;
if _n_ > &lines. - 10;
run;