BookmarkSubscribeRSS Feed
Ronein
Onyx | Level 15

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;
2 REPLIES 2
LinusH
Tourmaline | Level 20

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.

Data never sleeps
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1010 views
  • 0 likes
  • 3 in conversation