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;
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).
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).
Thanks Kurt. Yup Obs was the villian 🙂
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.