Date:         Thu, 29 Mar 2001 15:41:24 -0500
Reply-To:     "Ravi, Prasad" <Prasad.Ravi@PFIZER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Ravi, Prasad" <Prasad.Ravi@PFIZER.COM>
Subject:      Re: Proc Report Question
Content-Type: text/plain; charset="iso-8859-1"

   Why not?


DATA ONE;
val1=1234.6677889;
RUN;

proc freq data=one;
run;

proc print data=one;
format val1 17.9;
run;

                                Cumulative  Cumulative
            VAL1   Frequency   Percent   Frequency    Percent
     _______________________________________________
          1234.6677889          1     100.0           1      100.0


 OBS                 VAL1

  1             1234.667788900


-----Original Message-----
From: Schechter, Robert S [mailto:robert.schechter@ASTRAZENECA.COM]
Sent: Thursday, March 29, 2001 3:21 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Proc Report Question


I don't think PROC FREQ or any other proc will help here. Once you've read
it into a numeric variable it's stored as an internal integer and you've
lost the way they had appeared in the input data set. Can you store the
variable as a character (also) for purposes of "printing it as it was?"
Another caveat, when a variable can be measured at various precisions, how
precise can your results be?
HTH,
Bob Schechter

-----Original Message-----
From: Ravi, Prasad [mailto:Prasad.Ravi@PFIZER.COM]
Sent: Thursday, March 29, 2001 2:45 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Proc Report Question


   If you want to include all the decimal positions, find out the max # of
decimal
positions(by PROC FREQ or PROC PRINT) of your data then specify that in the
FORMAT=    statement.




-----Original Message-----
From: Sharon Well [mailto:peach71_us@YAHOO.C]OM
Sent: Thursday, March 29, 2001 2:12 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Report Question


Hi

    I am running a proc report on lab values, with
different levels of precision such as 10.2, 10, 10.02
etc.  I defined the variable as below.

Define lval/format=5.2 width=10 ' Lab Value';

Now the problem is it formats all the values to 2
decimals, which I know is what I specified in my
format statement. If I don't specify any formats then
it rounds it off to three decimal places.

My question is what format should I give, such that
all the values would be reported just as how they
appear in the input data set.

Would appreciate if someone could help me.

Thanks.

Sharon



__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text