topic Dropping Incomplete Columns in SAS Procedures

Dropping Incomplete Columns

deleted_user — Wed, 14 Jan 2009 18:41:25 GMT

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?

Re: Dropping Incomplete Columns

sbb — Wed, 14 Jan 2009 19:48:37 GMT

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.

Re: Dropping Incomplete Columns

deleted_user — Wed, 14 Jan 2009 22:54:48 GMT

Thanks for the suggestion Scott. I've been searching the SAS OnlineDoc which isn't as fruitful. The example codes are a big help.