Help using Base SAS procedures

Dropping Incomplete Columns

Not applicable
Posts: 0

Dropping Incomplete Columns

I would like to drop columns that have missing entries.

My dataset has hundreds of columns and I would like to create a new dataset that only contains those columns that are complete (no missing entries).

data new;
set old;
[drop columns within variable range apple--orange that are incomplete]
[keep columns within variable range apple--orange that have no missing entries]

Any suggestions?
Super Contributor
Super Contributor
Posts: 3,176

Re: Dropping Incomplete Columns

Posted in reply to deleted_user
There are several sample code examples at the SAS support website when using either website's SEARCH facility or with using the example Google advanced search argument listed below:

drop variables all missing values

Scott Barry
SBBWorks, Inc.
Not applicable
Posts: 0

Re: Dropping Incomplete Columns

Thanks for the suggestion Scott. I've been searching the SAS OnlineDoc which isn't as fruitful. The example codes are a big help.
Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation