Date:         Wed, 5 Jun 2002 10:37:36 -0400
Reply-To:     Nathaniel_Wooding@DOM.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nathaniel Wooding <Nathaniel_Wooding@DOM.COM>
Subject:      Re: Reformat stat proc output?
Comments: To: Mike Fay <rmf4@CDC.GOV>
Content-type: text/plain; charset=us-ascii

Mike

try using the MAXDEC = option on the proc means statement.

|-------------------------------------+-----------|
|                                     |           |
|  Specify the number of decimal      |  MAXDEC=  |
|  places for the statistics          |           |
|                                     |           |
|-------------------------------------+-----------|




If you should have a case where you have a variety of output variables with
differing decimal needs, you could use an output statement to write the
output to a file and then round the variables as you wished. Then, you
simply print the file.

Nat Wooding



                    Mike Fay
                    <rmf4@CDC.GOV>       To:     SAS-L@LISTSERV.UGA.EDU
                    Sent by:             cc:
                    "SAS(r)              Subject:     Reformat stat proc output?
                    Discussion"
                    <SAS-L@LISTSER
                    V.UGA.EDU>


                    06/05/02 10:31
                    AM
                    Please respond
                    to Mike Fay






Hi folks,

I'm a newbie using some simple Proc Means output, e.g.:

proc means data=hazdat.j_assess n min max mean median p1 p5 p10 p25 p50 p75
p90 p95 p99;
   var c0_CnE;
   by dDocType;
run;

The data being displayed is all integer data (counts of up to approx
2,000). Unfortunately, the Percentile statistics I ask for are all showing
up with not one, not two, but with SEVEN decimal points (49.0000000), when
nary a one has a fractional value.

How do I change the format of the output? I tried putting format statements
directly after the percentile e.g.

proc means median p1 6.1 ;

But of course, the number confuses it. Maybe a FORMAT statement should go
within the procedure? Trying to type "format procedure output" into Help
only gives me about 4,000 useless topics  :)

Does someone know how to format output that is intrincic to a procedure
(i.e., not a variable I made beforehand and could have formatted then)?

Thanks!

   Mike