Hi,
Thank you for your reply. I am actually interested in the volume not proportion. Basically I am working on a survey and the weight represent the number of total population. The estimation of real number of participants in the survey is as below (It's an estimation not exact). But need to select people base on the number of total population etc...not sure if I make sense...
I don't know yet the number of participants in each group, the weight volume below is my target and once I have the target I will be able to count the number of participants.
Age
Number of participants
Weight
Under 50
2
3,093
50 To 60
7
9,537
60 To 65
1
1,418
65 To 70
3
4,361
70 To 75
6
7,217
75 To 80
0
0
7.> 80
5
6,080
24
31,707
What I mean is how to use the weight instead of N...like in proc tabulate below, for each age group, I will get the sum of weight (Total population) instead of (count of people in a survey). Thank you
proc tabulate
data = test missing; class age ;
var weight;
table (age ALL) , weight;
run;
... View more