How to read last few records into a dataset

[vThanu]

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..

[Ksharp · Accepted solution]

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

[Kurt_Bremser]

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;