Date:         Fri, 13 Apr 2012 14:16:42 -0500
Reply-To:     Yu Zhang <zhangyu05@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Yu Zhang <zhangyu05@GMAIL.COM>
Subject:      Re: Scientific notation E format in PROC FREQ (weighted)
Comments: To: "Yanny L." <yyyan_1@hotmail.com>
In-Reply-To:  <201204131818.q3DI6LM3014898@waikiki.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

data have;
input agect obct Frequency;
cards;
   1        0          88875930
   1        1           1.496E8
   1        2          27231521
   2        0           3347468
   2        1          21544089
  ;
  run;

  ods path work.tmplst(update) sashelp.tmplmst(read);
proc template ;
edit  Base.Freq.OneWayList;
   define Frequency;
  format=best32.;
   end;

end;
    run;

proc freq data=have;
table agect*obct/list;
weight Frequency;
run;


On Fri, Apr 13, 2012 at 1:18 PM, Yanny L. <yyyan_1@hotmail.com> wrote:

> Hi All,
>
>      I have PROC FREQ output like below, do you know how to show the
> Frequency column NOT in E format.  Thank you for any help on this!
>
>
>                                                 Cumulative    Cumulative
>  AGECAT    OBTCAT      Frequency     Percent     Frequency      Percent
> ---------------------------------------------------------------------------
>     1        0          88875930       29.15       88875930        29.15
>    1        1           1.496E8       49.07       2.3848E8        78.23
>    1        2          27231521        8.93       2.6571E8        87.16
>    2        0           3347468        1.10       2.6906E8        88.26
>     2        1          21544089        7.07       3.0484E8       100.00
>
> Yanny
>