Calculating Std Dev for row percentages using Surveyfreq

[Ddormer]

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.

[ballardw · Accepted solution]

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.

[Ddormer]

Yup, adding CL solved it.  Lesson learned.

Thank you @ballardw.