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

[fengyuwuzu]

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.

[LinusH]

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

[PGStats]

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).

[Babloo]

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

if not missing(cats(of _all_));

[Kurt_Bremser]

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.

[Kurt_Bremser]

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.