Date:         Sun, 13 Aug 2006 23:07:00 +0000
Reply-To:     SAS_L@LISTSERV.EDU.AU
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Laughing Beggar <laughing_beggar@HOTMAIL.COM>
Subject:      PROC FREQ output to Excel
Content-Type: text/plain; format=flowed

OK, I can output my frequencies to an Excel file thus:
proc freq;
tables age10/out=work.s10m;
run;
PROC EXPORT DATA= WORK.s10m
            OUTFILE= "C:\temp\nicole\outputs\phsurv_outputs\s10.xls"
            DBMS=EXCEL REPLACE;
     SHEET="s10_all_m";
RUN;
BUT - how do I output the result of this (note BY line):
proc freq;
tables age10/out=work.s10m;
BY HSI:
run;
so that I get the frequency and percentage columns next to each other for
each level of HSI on the same worksheet?
Like this:
                      HSI(Level1)   HSI(Level2)    HSI(Level3)   ..........
                      Freq    %      Freq    %       Freq   %
Age10 (Level1)
Age10 (Level2)
.
.
.

Cheers
L_B




"The beggar laughs in the face of the thief"