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
Comments: To: Igor Holas <iholas@mail.utexas.edu>
In-Reply-To:  <5e0fffb0909221144pd168b70j27daa12f2b4bfb2e@mail.gmail.com>
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.

IE:
proc format lib=work;
value xformat
-999,.=.
other=[best12.]
;
quit;

data test;
input x;
format x xformat.;
datalines;
-999
9
259
.
21358
;;;;
run;

proc freq data=test;
tables x;
run;

produces the desired result [no -999], but
proc means data=test;
var x;
run;

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.

-Joe

On Tue, Sep 22, 2009 at 1:44 PM, Igor Holas <iholas@mail.utexas.edu> 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:
>
> proc
>  means data=XXX  mean range min max var skew kurt ;
>  var _all_;
>  MISSING -999;
> run;
>
> that did not work.
>
> Thanks
>
>
> 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
>