topic Re: PROC REPORT and WEIGHT and PCTN in ODS and Base Reporting

PROC REPORT and WEIGHT and PCTN

deleted_user — Thu, 10 Jul 2008 00:26:06 GMT

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

Re: PROC REPORT and WEIGHT and PCTN

Cynthia_sas — Thu, 10 Jul 2008 15:37:18 GMT

Hi:
Every time I have used the WEIGHT statement with PROC REPORT, I have tested the REPORT results against PROC MEANS -- so I can use the same VARDEF= value for both procedures.

It seems to me that this is a question for Tech Support -- because either the weight statement works differently for PROC REPORT than PROC FREQ or it can't be used with PCTN stat in PROC REPORT or ???

Tech Support is your best resource for this question.

cynthia

Re: PROC REPORT and WEIGHT and PCTN

deleted_user — Thu, 10 Jul 2008 16:31:03 GMT

Thanks for the advice, Cynthia. I'll contact Tech Support. Have a wonderful day.