Date: Wed, 26 May 2004 18:29:14 GMT
Reply-To: David Wright <David_wright@SPRA.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David Wright <David_wright@SPRA.COM>
Organization: Your Company
Subject: Re: small variables in proc means
Thanks. That is indeed the solution.
However, I am not sure what the safest format to use is.
If I use something like 30.25 I still can't match the macrovariable
to equal the dataset value (which I use later on).
Perhaps I have created a value which is beyond SAS limits, I don't know. I
don't know how to even look at the value, since I have to choose a format and
not sure the best to use.
Howard_Schreier@ITA.DOC.GOV (Howard Schreier) wrote in
<200405260322.i4Q3Maf05063@listserv.cc.uga.edu>:
>Because there is no code and no sample data in the problem statement, I can
>only speculate.
>
>The PROC MEANS result is numeric. The macrovariable is a character string.
>If the necessary conversion is done with the default BEST12. format, you
>may encounter rounding (not truncation). Try converting with the PUT
>function, specifying an appropriate format (like 20.14 or E12.).
>
>On Tue, 25 May 2004 17:49:17 GMT, David Wright <David_wright@SPRA.COM>
>wrote:
>
>>I am trying to find the smallest value of a variable and then output in a
>>macro variable. I do proc means, put the min value in output statement,
>then
>>use a datastep to output the value into a macro variable. But, for some
>>reason, the value is truncated after it gets out of proc means.
>
|