topic Re: Import first 5 obs in SAS Programming

Import first 5 obs

Ronein — Wed, 07 Dec 2022 06:59:08 GMT

Hello

Let's say that I export cars data set into txt file with comma delimiter.

Let's say that I want to import this txt file into sas data set.

I want to import only observations 6 to 10

What is the way to do it?

I get an error

WARNING 70-63: The option FIRSTOBS is not valid in this context. Option ignored.

proc export data=sashelp.cars outfile="/path/cars.txt" dbms=dlm replace;
delimiter=','; 
run;


proc import datafile ="/path/cars.txt"
out=cars_tbl(firstobs=6 obs=10) 
dbms=dlm
replace;
delimiter = ',';
run;

Re: Import first 5 obs

LinusH — Wed, 07 Dec 2022 07:33:42 GMT

I think you need to import using a data step to do this.

And there use tha automatic variable _n_ to control you import logic.

Re: Import first 5 obs

Kurt_Bremser — Wed, 07 Dec 2022 08:32:27 GMT

Read it with a DATA step, and use the FIRSTOBS= and OBS= options of the INFILE statement.