topic Re: double weighted mean in SAS Data Management

double weighted mean

ab97_cd — Wed, 27 Nov 2019 15:41:03 GMT

Hi,

How can I add second proc univariate to this:

proc univariate data=set_out;
by date;
weight w1;
VAR price;
run;

I want to obtain wieghted mean by group variable, using w2 as wieght.

Re: double weighted mean

PaigeMiller — Wed, 27 Nov 2019 15:56:04 GMT

@ab97_cd wrote:

Hi,

How can I add second proc univariate to this:
proc univariate data=set_out;
by date;
weight w1;
VAR price;
run;
I want to obtain wieghted mean by group variable, using w2 as wieght.

I'm sorry this just isn't clear to me. You can certainly add a second PROC UNIVARIATE to your code, so I'm not sure what your question really is.

If all you want is weighted means, use PROC SUMMARY and not PROC UNIVARIATE.

Re: double weighted mean

ab97_cd — Wed, 27 Nov 2019 16:02:46 GMT

Hi,
Within first weighted mean grouping by date, I want to compute again weighted mean using "group" with by option.

Re: double weighted mean

Tom — Wed, 27 Nov 2019 16:36:59 GMT

If you have a complex weighting (sampling) design then you probably will need to use PROCSURVEYMEANS instead of UNIVARIATE or MEANS.

https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_surveymeans_toc.htm&docsetVersion=15.1&locale=en