Date: Tue, 22 Sep 2009 14:27:23 -0500
Reply-To: Joe Matise <snoopy369@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Joe Matise <snoopy369@GMAIL.COM>
Subject: Re: Handling non sysmiss missing values
Content-Type: text/plain; charset=ISO-8859-1
With a PROC FORMAT, if you create formatted values to have the same format
as missing values, it will consider them to be missing by PROC FREQ. That
doesn't seem to be the case with PROC MEANS, not sure why.
proc format lib=work;
format x xformat.;
proc freq data=test;
produces the desired result [no -999], but
proc means data=test;
does not. You could use the format to change the value [create a new
variable], but I suspect there's a solution in this direction, just not one
that I can think of at the moment.
On Tue, Sep 22, 2009 at 1:44 PM, Igor Holas <email@example.com> wrote:
> I am preparing data for Mplus and as such replacing my sysmiss values (.)
> with a specific number value (-999)
> How do I specify proc means (and other procs) to handle these specific
> values as missing?
> I searched for this but found nothing.
> I tried:
> means data=XXX mean range min max var skew kurt ;
> var _all_;
> MISSING -999;
> that did not work.
> Igor Holas
> Graduate Student
> Human Development & Family Sciences
> and Population Research Center
> Seay 2.442
> University of Texas at Austin
> 1 University Station - A2702
> Austin, TX 78712
> c: 440.281.3623
> o: 512.232.1964
> f: 512.475.8662