topic Re: Difference between records count and observation count when reading in data from csv file in New SAS User

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

nballred1 — Sat, 23 Feb 2019 22:17:18 GMT

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

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

nballred1 — Sat, 23 Feb 2019 22:20:38 GMT

I forgot to include my SAS input code.

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

novinosrin — Sat, 23 Feb 2019 22:26:59 GMT

try adding truncover option in your infile statement

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

PGStats — Sat, 23 Feb 2019 22:37:21 GMT

Add option DSD to your infile statement.

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

Kurt_Bremser — Sat, 23 Feb 2019 22:52:53 GMT

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.

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

nballred1 — Sun, 24 Feb 2019 23:02:25 GMT

This fixed the issue, I appreciate the help.

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

nballred1 — Sun, 24 Feb 2019 23:03:07 GMT

This fixed the issue, I appreciate the help.

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

nballred1 — Sun, 24 Feb 2019 23:06:28 GMT

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.

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

novinosrin — Sun, 24 Feb 2019 23:12:49 GMT

infile datalines your options go here;