BookmarkSubscribeRSS Feed
fengyuwuzu
Pyrite | Level 9

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.

5 REPLIES 5
LinusH
Tourmaline | Level 20
Are you sure that there are no LF/CR at your last lkne with values?
Data never sleeps
PGStats
Opal | Level 21

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

PG
Babloo
Rhodochrosite | Level 12

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

 

if not missing(cats(of _all_));

 

Kurt_Bremser
Super User
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
Super User

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2200 views
  • 1 like
  • 5 in conversation