Help using Base SAS procedures

Dropping Incomplete Columns

Reply
N/A
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]
or
[keep columns within variable range apple--orange that have no missing entries]
run;

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

Re: Dropping Incomplete Columns

There are several sample code examples at the SAS support website http://support.sas.com/ when using either website's SEARCH facility or with using the example Google advanced search argument listed below:

drop variables all missing values site:sas.com


Scott Barry
SBBWorks, Inc.
N/A
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
  • 103 views
  • 0 likes
  • 2 in conversation