topic Re: Calculating Std Dev for row percentages using Surveyfreq in Statistical Procedures

Calculating Std Dev for row percentages using Surveyfreq

Ddormer — Thu, 04 Jan 2018 15:49:12 GMT

I am using Surveyfreq for one-way and two-way tables. I'm interested in the row percentages and particularly the standard deviation of those row percentages. I have two issues/questions:

1) The documentation says the default columns are:

Frequency
Weighted frequency
Standard deviation of weighted frequency
Percent
Standard error of percent.

(plus the additional columns for the Row option).

However, instead of "Standard deviation of weighted frequency," I see "standard error of weighted frequency." Why does my table show Std Err Wgt Freq instead of Std Dev Wgt Freq? How do I get to the standard deviation?

2) What option do I need to get to the standard deviation of the weighted row percentages?

Here are the relevant section of code and a sample of a table.


Proc surveyfreq data=SCM_SORT;
	weight _LLCPWT; 
	Tables _STATE*GHSTATUS/row chisq(secondorder);
	ODS Output CrossTabs=Freqout1;
	Format GHSTATUS status.;
run;

Thanks in advance for your assistance.

Re: Calculating Std Dev for row percentages using Surveyfreq

ballardw — Thu, 04 Jan 2018 16:20:01 GMT

Note that the documentation says:

If you request a frequency or crosstabulation table without specifying options, PROC SURVEYFREQ produces the following for each table level or cell:

Since you include the options ROW and Chisq you are specifying options. Try adding the CL option and see if that helps.

Sometimes you may need to run multiple procecure calls with different table options to get what you want.

Re: Calculating Std Dev for row percentages using Surveyfreq

Ddormer — Thu, 04 Jan 2018 17:34:36 GMT

Yup, adding CL solved it. Lesson learned.

Thank you @ballardw.