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.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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