topic Infile command record count issue in SAS Programming

Infile command record count issue

GunnerEP — Thu, 20 Apr 2017 10:52:16 GMT

records.dat have 5000 records, but my main_set dataset have only 4999 records.
Not able to figure out what is wrong with this. any pointers would be of great help!

Data main_set;
infile "records.dat" dlm='|' dsd truncover;
input id : $10.
name : $25.
;
run;

Re: Infile command record count issue

Jagadishkatam — Thu, 20 Apr 2017 10:59:16 GMT

could you try using the firstobs=1, also are you getting the first row with variable names into the dataset.

Data main_set;
infile "records.dat" dlm='|' dsd truncover firstobs=1;
input id : $10.
name : $25.
;
run;

Re: Infile command record count issue

Kurt_Bremser — Thu, 20 Apr 2017 11:24:34 GMT

In which way have you determined that records.dat actually contains 5000 lines?

If on UNIX, do a

wc -l records.dat

to verify this.

And check that you don't have a stray obs= system option set to 4999 (been there, done that).

Re: Infile command record count issue

GunnerEP — Thu, 20 Apr 2017 11:38:27 GMT

Thanks Kurt. Yup Obs was the villian 🙂