Date:         Thu, 30 Oct 2003 18:46:31 +0000
Reply-To:     sashole@bellsouth.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paul Dorfman <paul_dorfman@HOTMAIL.COM>
Subject:      Re: Finding out which variables in a dataset have at least one
              non-mi ssing value
Comments: To: AndrewHa@SF.NSW.GOV.AU
Content-Type: text/plain; format=flowed

Andrew,

It has been asked and answered repeatedly in the past. Fro example, look for

http://www.listserv@listserv.uga.edu/cgi-bin/wa?A2=ind0307D&L=sas-l&P=R13173

In a nutshell, if the variables are numeric only, you can use
MEANS/SUMMARY/SQL, as your have just been already adviced. Otherwise it is
just a bit more involved. The above reference addresses both cases.

Kind regards,
=================
Paul M. Dorfman
Jacksonville, FL
=================


>From: Andrew Haywood <AndrewHa@SF.NSW.GOV.AU>
>Reply-To: Andrew Haywood <AndrewHa@SF.NSW.GOV.AU>
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Finding out which variables in a dataset have at least one non-mi
>             ssing value
>Date: Thu, 30 Oct 2003 16:26:18 +1100
>
>I would like to know an easy way of finding out which variables in a datset
>contain at least 1 non-missing value. Variables are both numeric and
>charcters. I do not want to explicitely write out all the variables in the
>proc/data statement,is there an easy way to do this?
>
>I started using proc contents to get a list of the variables and then pass
>them to a macro array, to then count up, but this was getting beyond my
>expertise. Any help or suggestion would be greatly appreciated
>
>cheers
>
>Andrew Haywood
>Statistics and Data Services Officer
>Research & Development Division
>State Forests of NSW
>
>Tel     (02) 9872 0176
>Fax     (02) 9871 6941

_________________________________________________________________
Send instant messages to anyone on your contact list with  MSN Messenger
6.0.  Try it now FREE!  http://msnmessenger-download.com