How to calculate the prevalence of an outcome by SAS for ever married women surveys? [message #21781] |
Fri, 18 December 2020 09:51 |
Han
Messages: 4 Registered: December 2020
|
Member |
|
|
I am doing an analysis that looks at smoking prevalence of women from ever married women surveys.
For a "all-women" survey, we can calculate the overall smoking prevalence of women using PROC SURVEYFREQ to in SAS:
weight --> (V005 Women's individual sample weight (6 decimals) / 1,000,000)
cluster --> V021 Primary sampling unit
strata --> V023 Stratification used in sample design
y --> V463a Smokes cigarettes
proc surveyfreq data=a;
strata strata;
cluster cluster;
weight weight;
tables y;
run;
However, if I would like to calculate the overall smoking prevalence of women from an ever married women survey, then what should I do? How should I use the awfactt variable?
Thank you!
|
|
|
|
|
Re: How to calculate the prevalence of an outcome by SAS for ever married women surveys? [message #21852 is a reply to message #21848] |
Wed, 30 December 2020 19:27 |
Bridgette-DHS
Messages: 3172 Registered: February 2013
|
Senior Member |
|
|
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:
For an outcome like smoking, I would just replace v005 with v005*awfactt/100. If you want the breakdown by urban/rural, you use awfactu. By region, awfactr. By education, awfacte. By wealth quintile, awfactw.
This recommendation is based on assuming that, within single years of age, smoking is not related to whether a woman is ever-married or never-married. That may not be a safe assumption. If there IS a relationship, however, you have no way to assess it.
We at DHS much prefer all-women surveys to EMW surveys. The usual justification for the EMW limitation is an assumption that never-married women have had no children, have never used contraception, have no need for contraception, etc. For such outcomes, we follow that assumption (knowing it not completely correct) to expand estimates of fertility, etc., from ever-married women to all women.
An alternative to all-women factors is to merge the women in the IR file with the women in the PR file who are eligible for the individual interview on every criterion OTHER THAN their marital status. For the additional women in the PR file who are brought in with this merge you can impute v201=0 (no children ever born), etc. You can even impute a birth history with no births in it to include them in estimates of fertility rates. But even if you do this, you are limited to covariates that are collected in the household survey.
|
|
|