import 10 obs using PROC IMPORT

GreggB — Mon, 03 Oct 2011 19:50:12 GMT

I want to add an option/statement to this step so that only the first 10 obs are imported.

proc import data=map_export datafile="G:\Departments\Research\MAP\1112\Oconee - &admin. - Clean.txt" dbms=dlm replace;

delimiter='09'x;

run;

import 10 obs using PROC IMPORT

FriedEgg — Wed, 20 Jul 2022 15:39:37 GMT

There is no procedure specific option to directly limit the quantity the IMPORT procedure will read in, to my knowledge. You can use the OBS= system option to limit the number of records that SAS will process. Setting OBS=10 will limit the processing to the first 10, then set it back to OBS=MAX so subsequent operations consider the full data.

options obs=10; proc import datafile="G:\Departments\Research\MAP\1112\Oconee - &admin. - Clean.txt" out=map_export dbms=dlm replace; delimiter='09'x; run; options obs=max;

Since this is a text file, you should also consider using the DATA step with an INFILE statement to read the data. It requires more knowledge of the data fields as you read them, but that approach provides much more control over how much data is read in. See this topic for more guidance and troubleshooting.

(Editor's note: modified this reply for clarification and more detail on this popular topic.)

topic import 10 obs using PROC IMPORT in SAS Procedures

import 10 obs using PROC IMPORT

import 10 obs using PROC IMPORT