I'm new to using the REPORT procedure and am looking for help showing weighted data. I'm creating a cross-tab and have been able to see the sums weighted, but I can't see the percentages weighted.
Any suggestions?
Here is my syntax and the resulting output:
PROC REPORT DATA=trash.BOLiesTR1 NOWD;
COLUMN post (userfin fage301), PCTN;
DEFINE post / GROUP;
WEIGHT weights;
RUN;
post userfin fage302
1 0.38 0.36
2 0.30 0.24
3 0.18 0.19
4 0.08 0.14
5 0.05 0.07
And here it is without the weights (same results):
PROC REPORT DATA=trash.BOLiesTR1 NOWD;
COLUMN post (userfin fage301), PCTN;
DEFINE post / GROUP;
RUN;
post userfin fage302
1 0.38 0.36
2 0.30 0.24
3 0.18 0.19
4 0.08 0.14
5 0.05 0.07
But this is what I get from a PROC FREQ statement:
PROC FREQ DATA=trash.BOLiesTR1;
TABLES post*(userfin fage302)/norow nocol nofreq;
WEIGHT weights;
RUN;
post userfin fage302
1 0.39 0.38
2 0.30 0.23
3 0.18 0.18
4 0.08 0.13
5 0.05 0.07