LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2012, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page