Difference between records count and observation count when reading in data from csv file

[nballred1]

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

[nballred1]

I forgot to include my SAS input code.

[novinosrin · Accepted solution]

try adding truncover option in your infile statement

[nballred1]

This fixed the issue, I appreciate the help.

[nballred1]

I was having the same issue when using datalines. Do you know how I would be able to correct this issue if I was using datalines instead of infile to import my data.

[novinosrin]

infile datalines your options go here;

[PGStats]

Add option DSD to your infile statement.

[Kurt_Bremser]

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.

[nballred1]

This fixed the issue, I appreciate the help.