Date:         Fri, 28 Jul 2006 09:54:14 -0700
Reply-To:     TSA <tamen@TAMU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         TSA <tamen@TAMU.EDU>
Organization: http://groups.google.com
Subject:      Re: Identifying Missing Values
Comments: To: sas-l@uga.edu
In-Reply-To:  <1154058310.805853.283180@h48g2000cwc.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Thanks for your suggestion.  The proc freq shows only 44 missing values
as well.  Could missing values for other variables be causing other
observation to excluded from the analysis?


Eash wrote:
> Do a PROC FREQ on the column with a /missing option - will give you the
> missing value frequencies.
>
> for eg:
>
> data test;
> infile cards truncover;
> input a ;
> cards;
> 1
> 2
> .
> .
>
> 1
> 2
> ;
> run;
>
> proc freq data=test;
> tables a/missing;
> run;
>
> Output:
>
>      a    Frequency     Percent
> ----------------------------------------------
>        .           3       42.86
>        1           2       28.57
>        2           2       28.57
>
> Note :
>
> when you read numeric variables, the Blanks as well as .'s will be
> considered as Missing values, as shown in the example..that may be a
> reason for you count mismatch on the missing values.
>
> Thanks
> EasH
>
> TSA wrote:
>
> > After running my program, I received the messages that  "74
> > observations are not included because of missing values" in the log
> > file.
> >
> > Based on the file that I imported, there should only be 43 missing
> > values (denoted with a ".").
> >
> > Is there anyway to get SAS to show me what values are being considered
> > "missing"?
> >
> > Thanks!  I look forward to your responses.
> >
> > Tonya