Hello SAS community,
I have a fairly basic issue that I am hoping someone can help me with. I was trying to import some data into SAS from a csv file but it appears that SAS is omitting some of the observations when the file is read in. As you can see from the log out put I have included SAS recognizes that there are 197 records, or 197 rows of information in the excel document; however, it only includes 104 observations in the data set. There are missing observations for some of the variables, as you can see in the screenshot I have included from the excel file, which might be causing the issue. Any advise on how I can include all 197 observations in the working data set in SAS would be appreciated.
Thanks,
Nate
try adding truncover option in your infile statement
I forgot to include my SAS input code.
try adding truncover option in your infile statement
infile datalines your options go here;
Add option DSD to your infile statement.
The "SAS went to a new line" message is your clue. Usually caused by missing values at the end of lines.
Try a truncover option, as already suggested.
This fixed the issue, I appreciate the help.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.