Weighted Average in Summary Tables

[WorkUser]

Hi,

Is there a way to calculate a weighted average in SAS EG by utilizing the “Summary Tables” in Tasks. I only know how to use the Query Builder. 

Thanks

[Reeza · Accepted solution]

Yes, see page 2 screenshot here which shows the Weight/Frequency columns. If you have statistical weights, use the weight column. If your weights are integers then you can use the FREQ column.

https://susanslaughter.files.wordpress.com/2013/03/tass-2013-summarytables.pdf

FYI- the summarize task uses PROC TABULATE as the back bone. 

---

@WorkUser wrote:

Hi,

Is there a way to calculate a weighted average in SAS EG by utilizing the “Summary Tables” in Tasks. I only know how to use the Query Builder. 

Thanks

---

[WorkUser]

Thank you for your help.