topic Re: last line in the data set is blank after reading in SAS in SAS Programming

last line in the data set is blank after reading in SAS

fengyuwuzu — Thu, 21 Jan 2016 19:13:19 GMT

either by proc import or data step with infile to read in .csv files, I notice that the last line in the data sets is blank.

Actually the last line in the .csv file has no values at all. Somehow when SAS read the data, it stops at the line below the last line in CSV.

How to solve this issue? Thanks.

Re: last line in the data set is blank after reading in SAS

LinusH — Thu, 21 Jan 2016 20:27:08 GMT

Are you sure that there are no LF/CR at your last lkne with values?

Re: last line in the data set is blank after reading in SAS

PGStats — Fri, 22 Jan 2016 03:52:43 GMT

With data step import, you could add the statement

if not missing(cats(of _all_));

to remove any line (observation) that is totally empty (missing).

Re: last line in the data set is blank after reading in SAS

Babloo — Fri, 22 Jan 2016 07:06:26 GMT

Could you please what 'cats(of _all_)' will do in following if clause?

if not missing(cats(of _all_));

Re: last line in the data set is blank after reading in SAS

Kurt_Bremser — Fri, 22 Jan 2016 08:04:36 GMT

fengyuwuzu wrote:

either by proc import or data step with infile to read in .csv files, I notice that the last line in the data sets is blank.

Actually the last line in the .csv file has no values at all.

That is as expected. An empty line in a .csv file will cause the input statement to read nothing, so the variables stay "missing" for this iteration of the data step.

Re: last line in the data set is blank after reading in SAS

Kurt_Bremser — Fri, 22 Jan 2016 08:02:48 GMT

if not missing(cats(of _all_));

That only works if all variables are character, as numeric variables will render a dot in the cats(of _all), causing the string to be non-missing.

In order for this to work,

options missing = ' ';

needs to be set.