topic Re: Weighted Average in Summary Tables in SAS Enterprise Guide

Weighted Average in Summary Tables

WorkUser — Mon, 12 Jul 2021 19:49:30 GMT

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

Re: Weighted Average in Summary Tables

Reeza — Mon, 12 Jul 2021 19:55:54 GMT

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

Re: Weighted Average in Summary Tables

WorkUser — Tue, 13 Jul 2021 11:51:46 GMT

Thank you for your help.