topic Re: wt freq using PROC SUMMARY in SAS Programming

wt freq using PROC SUMMARY

Sanjay_M — Thu, 12 Dec 2019 20:44:13 GMT

Please help me with a PROC SUMMARY (only) statement to get the volume by category, weighted volume by category, mean of score by category.

Reason I want to use PROC SUMMARY is because I have other code using the same and PROC SUMMARY produces other metrics.

data test;

length category score wt 8;

input category score wt;

infile datalines dlm=",";

datalines;

1,67,2

1,50,5

1,55,6

2,56,6

2,68,5

3,70,5

4,73,8

run;

PaigeMiller — Thu, 12 Dec 2019 20:47:26 GMT

A couple of questions:

which variable is "volume"?
when you say you want to get the volume by category, is this a sum or a mean or something else?
when you want weighted volume, what variable does the weighting (and do you want the sum or the mean or something else)?

Sanjay_M — Thu, 12 Dec 2019 21:16:00 GMT

which variable is "volume"? Category is segment, so I want volume and weighted volume by category
when you say you want to get the volume by category, is this a sum or a mean or something else? Count by category
when you want weighted volume, what variable does the weighting (and do you want the sum or the mean or something else)? Column is weight

Sanjay_M — Fri, 13 Dec 2019 08:13:14 GMT

Can the admin please move this post to the Statistical group

PaigeMiller — Fri, 13 Dec 2019 12:02:53 GMT

proc summary data=have;
    class category;
    var wt score;
    output out=stats mean(score)=score_mean sum(wt)=wt_volume;
run;

The variable _FREQ_ is the unweighted volume.