topic Re: SD in PROC SURVEYMEANS in SAS Programming

SD in PROC SURVEYMEANS

Emma_at_SAS — Wed, 31 Mar 2021 04:16:27 GMT

Hello, I want to get MEAN and SD from PROC SURVEYMEANS (my original data is a survey with weights). In PROC MEANS, STD calculates standard deviation; but in PROC SURVEYMEANS, STD calculates the standard deviation of SUM. Also, in the following example, MEAN does not calculate the mean.

How do I calculate the MEAN and STD for a variable in PROC SURVEYMEANS?

Thanks

PROC MEANS DATA=SASHELP.CLASS NONOBS MAXDEC=2 SUM MEAN STD ; 
VAR AGE HEIGHT; 
RUN; 
 
PROC SURVEYMEANS DATA=SASHELP.CLASS n mean STD df CLM ; 
VAR AGE HEIGHT; 
RUN;

Re: SD in PROC SURVEYMEANS

pkm_edu — Wed, 31 Mar 2021 05:04:25 GMT

PROC SURVEYMEANS DATA=SASHELP.CLASS nobs mean SUM df CLM ;
VAR AGE HEIGHT;
RUN;

I have changed n to nobs and STD to SUM. The code has worked for me.

“If you specify the statistic-keywords of your interest including SUM (i.e., estimated population total when the appropriate sampling weights are used) in that statement, the procedure computes STD by default.” (SAS Documentation).

Re: SD in PROC SURVEYMEANS

Emma_at_SAS — Wed, 31 Mar 2021 15:20:07 GMT

Thank you, pkm_edu. Yes, you are right. NOBS is the appropriate keyword to ask for the number of observations. That solves the error for mean.

It sounds I need to use this approach to estimate SD approach https://support.sas.com/kb/45/701.html#:~:text=Use%20PROC%20SURVEYMEANS%20to%20estimate%20the%20weighted%20total%20of%20the,the%20finite%20population%20standard%20deviation.

Thanks