| 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 |
|---|
|
| 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
| 
