Infile command record count issue

[GunnerEP]

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;

[Jagadishkatam]

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;

[Kurt_Bremser · Accepted solution]

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).

[GunnerEP]

Thanks Kurt. Yup Obs was the villian 🙂