Board index sas

proc report - calculating %'s across

proc report - calculating %'s across

Post by Robin Jeff » Thu, 06 May 2010 03:16:45


I have this:

proc report data=full nowindows headskip;
column schoolid a1 i15 wave;
define schoolid/group "School";
define a1/group "Gender";
define i15 /group "Ever Pregnant";
define wave/across "Wave" ;
run;

Which gives me the frequencies of pregnancy (yes/no) across wave by
gender & school.
Now, how can I add a row that gives me the column percents? See below.
Sorry if the spacing is off.

Wave
School Gender Ever Pregnant 1 2 3 4 5
100 Females No 160 199 135 161 156
Yes 8 11 14 11 12
% Yes 5% 5% 9%
6% 7%


Thanks,
-Robin
 
 
 
Top

1. Do you prefer Proc Report or Proc Tabulate?Ans,If proc report,Would you Please explain?

2. Proc Transpose, Proc Tabulate, Proc Report?

3. Proc Tabulate or Proc Freq or Proc Report

4. Do you prefer Proc Report or Proc Tabulate?Ans,If proc

5. Bug in ODS using PROC REPORT and ACROSS

6. Proc Report Month Name Across the Top

7. Proc Report:Any good books on Proc Report?

8. dynamic column headings with PROC REPORT ACROSS variables?

9. EG 4.2 Proc Report task Compared to Proc Report Plz Comment

10. Do I need to use proc summary before proc report for this report?

11. Applying formats across rows in PROC REPORT

12. Proc report question - how to calculate average for each period

13. calculating percentages in proc report

14. Calculating a pagebreak variable for use in proc report

15. Calculate Percent using proc report

All times are UTC
Board index