The SAS Output Delivery System and reporting techniques

PROC REPORT and WEIGHT and PCTN

Reply
N/A
Posts: 0

PROC REPORT and WEIGHT and PCTN

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
SAS Super FREQ
Posts: 8,745

Re: PROC REPORT and WEIGHT and PCTN

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
N/A
Posts: 0

Re: PROC REPORT and WEIGHT and PCTN

Thanks for the advice, Cynthia. I'll contact Tech Support. Have a wonderful day.
Ask a Question
Discussion stats
  • 2 replies
  • 129 views
  • 0 likes
  • 2 in conversation