Date:         Thu, 6 Feb 2003 22:04:52 -0500
Reply-To:     lpogoda <lpogodajr292185@COMCAST.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         lpogoda <lpogodajr292185@COMCAST.NET>
Subject:      Re: proc format: Real numbers and missing values

Yeah OK, but the question is, why code missing numeric values as -9999 in
the first place?

Roland wrote in message ...
>proc format ;
>    value m -9999=' ' other=[best12.]; run;
>
>
>"Aldi Kraja" <aldi@wubios.wustl.edu> wrote in message
>news:3E42F8DE.5020305@wubios.wustl.edu...
>> Hi,
>> I am trying to work on some numeric variables. I am coding missing as
>> -9999.0000 and I want in the final output the missing values to be
>> blank. Using the following program the last line of values becomes with
>> rounded integer in the output (1.555 becomes a 2 etc, which is not
>> correct). Is there a way that I can keep the decimals as needed and also
>> apply the m. format?
>> TIA,
>> Aldi
>>
>> Program:
>> ========
>> proc format ;
>>     value m -9999=' '; run;
>> data x;
>>      input a b c;
>> cards;
>> 1 2 3
>> 2 3 4
>> 1 -9999.0000 3
>> 1.555 3.222 5.111
>> ;
>> data _null_; set x;
>>      format a b c m.;
>> put a b c; run;
>> Output:
>> =======
>>
>> 1 2 3
>> 2 3 4
>> 1   3
>> 2 3 5
>>
>
>