Dropping Incomplete Columns

[deleted_user]

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?

[sbb]

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.

[deleted_user]

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