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;
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.
Read it with a DATA step, and use the FIRSTOBS= and OBS= options of the INFILE statement.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.