topic Re: Can Proc Genmod include sampling weights for a complex-sampling design survey? in Statistical Procedures

Can Proc Genmod include sampling weights for a complex-sampling design survey?

hongjie76 — Sun, 25 Feb 2024 22:42:28 GMT

I am using national survey data that include survey weights in the dataset. I'd like to use Proc Genmod to estimate the prevalence ratios (not the odds ratios estimated from PROC SURVEYLOGISTIC), but I am not sure if proc genmod can account for the complex sampling design structure. Thank you in advance.

Re: Can Proc Genmod include sampling weights for a complex-sampling design survey?

StatDave — Sun, 25 Feb 2024 23:36:32 GMT

No, GENMOD does not have the variance estimators necessary for proper analysis of survey data. But you don't need GENMOD for this. You can use PROC SURVEYLOGISTIC and then follow by using the NLMeans macro with OPTIONS=RATIO in the same was as shown in this note with PROC LOGISTIC.

Re: Can Proc Genmod include sampling weights for a complex-sampling design survey?

hongjie76 — Mon, 26 Feb 2024 23:25:43 GMT

Thank you for your response. I tried to use this SAS syntax but got a warning message. Could you please check if 'ods output coef=coeffs;' and 'store out=ques;' are correct? Thank you again!

proc surveylogistic data=c8_ncsr;
	strata sestrat;
	cluster seclustr;
	weight ncsrwtlg;
	class ag4cat (ref=first) sex (ref=last) ed4cat (ref=first) mar3cat (ref=first) 
		/ param=ref;
	model mde (event='Yes')=ag4cat sex ald ed4cat mar3cat;
	format ag4cat af. sex sf. ed4cat edf. mar3cat mf. mde yn.;
    ods output coef=coeffs;
    store out=ques;
run;

WARNING: Output 'coef' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify

that the appropriate procedure options are used to produce the requested output object. For example, verify that the

NOPRINT option is not used.

Re: Can Proc Genmod include sampling weights for a complex-sampling design survey?

StatDave — Mon, 26 Feb 2024 23:52:28 GMT

Read the example in the note I referred to more carefully. Notice that it includes an LSMEANS statement and uses (as required by LSMEANS) the PARAM=GLM option in the CLASS statement. You should probably also read the documentation of the NLMeans macro to understand what it requires.

Re: Can Proc Genmod include sampling weights for a complex-sampling design survey?

hongjie76 — Tue, 27 Feb 2024 01:47:25 GMT

Thanks. Hongjie