The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Domestic Violence » Compare two surveys (Methodology to compare two surveys)
Compare two surveys [message #24742] Mon, 04 July 2022 01:53 Go to next message
kmdshoyaib is currently offline  kmdshoyaib
Messages: 6
Registered: May 2022
Member
Hi all, I am planning to compare two Individual datasets from 2015 survey and 2019 survey. My dependent variable would be from Domestic Violence module and independent variables would be other factors such as occupation literacy etc.

I would like to know how to compare the variables affecting the domestic module.

Should i do the regression analysis on each dataset and then compare the odds ratio from one dataset to another dataset or is there any other way.

Any leads are highly appreciated.
Re: Compare two surveys [message #24771 is a reply to message #24742] Thu, 07 July 2022 12:34 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 162
Registered: April 2022
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

You can pool the IR files from the two surveys into a single file. In Stata, this is done with the "append" command. Define a variable "survey" that is 0 for the cases in the 2015 survey and 1 for the cases in the 2019 survey. Then you can do the same kind of regression that you would do for a single survey, but in the pooled file you include "survey" as a covariate or predictor. If the coefficient for "survey" is statistically significant, then the relationship of the outcome to the other covariates has changed. This is a simple description of a strategy we often use at DHS.
Re: Compare two surveys [message #24889 is a reply to message #24771] Thu, 28 July 2022 22:01 Go to previous messageGo to next message
kmdshoyaib is currently offline  kmdshoyaib
Messages: 6
Registered: May 2022
Member
Thank you for the reply. When comparing two different surveys, should i use complex analysis plan file for survey 1 or complex analysis plan file for survey 2 ?
Re: Compare two surveys [message #24890 is a reply to message #24771] Thu, 28 July 2022 22:03 Go to previous messageGo to next message
kmdshoyaib is currently offline  kmdshoyaib
Messages: 6
Registered: May 2022
Member
Thank you for the response. When comparing, should I use the analysis plan file of survey 1 or analysis plan file of survey 2 ?
Re: Compare two surveys [message #24912 is a reply to message #24889] Mon, 01 August 2022 12:34 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 162
Registered: April 2022
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

You need to construct new variables for the clusters and strata, like this:

egen cluster_ID=group(survey v001)
egen stratum_ID=group(survey v023)

and use these new variables in svyset. Note that even if v023 is defined the same way in both surveys, you still need to distinguish between the two surveys. You do not need to alter the weights. Good luck.
Previous Topic: Discrepancies in results
Goto Forum:
  


Current Time: Sat Aug 13 12:21:22 Coordinated Universal Time 2022