Date:         Sun, 2 Jul 2006 12:27:54 -0700
Reply-To:     RolandRB <rolandberry@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         RolandRB <rolandberry@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Macro to "clean" SAS data set of variables that have all
              missing
Comments: To: sas-l@uga.edu
In-Reply-To:  <6.0.1.1.2.20060702105653.054e72a0@newdonner.dartmouth.edu>
Content-Type: text/plain; charset="iso-8859-1"

"Kevin F. Spratt" wrote:
> I'm wondering if there is not a macro out there that evaluates a sas data set
> and removes all variables that have all missing values?

Of course there is. But you are talking about two tasks. You need a
macro to identify the all missing-variables and write them to a list
then it is up to you what you do with that list (such as use it in a
drop statement).

http://www.datasavantconsulting.com/roland/missvars.sas