Date:         Fri, 13 Apr 2012 13:29:09 -0700
Reply-To:     Mark Miller <mdhmiller@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mark Miller <mdhmiller@GMAIL.COM>
Subject:      Re: Scientific notation E format in PROC FREQ (weighted)
Comments: To: Yanyun Liu <yyyan_1@hotmail.com>
In-Reply-To:  <COL110-W1A3E98F93AEF6510E2470D73B0@phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1

Yanyun

You need to use ODS and PROC Template
The following program is what I used to create a
permanent template for formatting large frequencies.
Choose you own libname reference.
If you choose to make a permanent template,
then the Libname  and ODS path statements are
all you need to get appropriate formatting from Proc Freq.

*----------;
libname reflib 'K:\reflib';
ODS   PATH  reflib.templat(update)sashlp.tmplmst(read)
sasuser.templat(update) ;

Proc Template;
   PATH  sashlp.tmplmst(read) reflib.templat(update)
 sasuser.templat(update) ;
              EDIT  Base.Freq.Frequency;    format = comma14. ;    END;
              EDIT  Base.Freq.Percent;      format = 10.4;       END;

        EDIT Base.Freq.CrossTabFreqs;
             Edit Frequency;       format = comma14. ;  END;
             Edit Percent;           format = 10.4 ;      END;
             Edit RowPercent;      format = 10.4 ;      END;
             Edit ColPercent;      format = 10.4 ;      END;
             Edit TotalPercent;    format = 10.4 ;      END;
             Edit CumColPercent;   format = 10.4 ;      END;

             Edit  Expected;       format = Best14. ;   END;
             Edit  Deviation;       format = Best14. ;   END;
      END;
RUN;

----------
Mark Miller


On Fri, Apr 13, 2012 at 11:13 AM, Yanyun Liu <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.  THANKS.
>
>
>                                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           2.906E8         95.33
>                                    2                  2
>  14242416        4.67         3.0484E8       100.00
>
> Yanny