| 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"
| 
