Home » Data » Merging data files » Mergining PR onto a Combined IR, MR Dataset in SPSS
Mergining PR onto a Combined IR, MR Dataset in SPSS [message #3721] |
Sun, 01 February 2015 22:05 ![Go to next message Go to previous message](/theme/default/images/down.png) |
cudis
Messages: 3 Registered: January 2015
|
Member |
|
|
We are interested in conducting an analysis of determinants of employment and hence would like to create a combined IR and MR file of all interviewed individuals, with relevant household member data on background and household characteristics from the PR file merged onto the individual records, in SPSS.
We have found an analogous procedure outlined in a previous topic (quoted below).
Bridgette-DHS wrote on Wed, 20 February 2013 11:46Here is a response from one of our STATA experts Tom Pullum, that should answer your question.
Assuming you want a single file that includes men and women, as individuals, and has the HIV data merged onto the individual records. In Stata, I would go through the following steps:
Open the IR file and construct a new variables, sex=2 (female), for all cases. Save as file 1.
Open the MR file and construct a new variable, sex=1 (male), for all cases. For all variables you need that have an mv prefix, drop the m, so the prefix becomes v. Save as file 2.
Open the AR file and change the variable names exactly as you did. Sort on v001 v002 v003. Save as file 3.
Open file 1. Then APPEND file 2 to the end of file 1, getting a file with all the men and women as observations. Sort on v001 v002 v003. Merge with file 3, on v001 v002 v003. Drop any cases with hiv05 missing (these are cases with no HIV result). Save as file 4. This will be your working file.
In file 4, the preferred weight will be hiv05, rather than v005. The cluster variable will be v001 (it is duplicated in the v020's but we always use v001). There may be a variable that is identified as a stratum variable, e.g. v022, but we recommend that you use what is identified as the domain variable, e.g. v023. If domains are not given, you can construct a domain variable for virtually all the surveys as all combinations of region and urban/rural.
However, in our case, is it necessary to construct a new sex variable in the individual files, as this information is available in the household member recode and could be included when the PR data is merged onto the combined IR and MR file?
Also, we wonder whether the above steps need to be modified specifically for SPSS and/or the household member recode, and if an example syntax could please be provided?
[Updated on: Sun, 01 February 2015 22:35] Report message to a moderator
|
|
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Mergining PR onto a Combined IR, MR Dataset in SPSS
By: cudis on Sun, 01 February 2015 22:05
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Mergining PR onto a Combined IR, MR Dataset in SPSS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Mergining PR onto a Combined IR, MR Dataset in SPSS
By: cudis on Fri, 06 February 2015 14:13
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Mergining PR onto a Combined IR, MR Dataset in SPSS
By: Gazimbi on Wed, 01 April 2015 18:00
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Mergining PR onto a Combined IR, MR Dataset in SPSS
By: Gazimbi on Wed, 01 April 2015 18:15
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Mergining PR onto a Combined IR, MR Dataset in SPSS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Mergining PR onto a Combined IR, MR Dataset in SPSS
By: Gazimbi on Sun, 05 April 2015 07:32
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Mergining PR onto a Combined IR, MR Dataset in SPSS
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Mergining PR onto a Combined IR, MR Dataset in SPSS
By: Hassen on Sun, 06 May 2018 06:06
|
![Read Message Read Message](/theme/default/images/read.png) |
|
Re: Mergining PR onto a Combined IR, MR Dataset in SPSS
|
Goto Forum:
Current Time: Mon Aug 19 03:17:03 Coordinated Universal Time 2024
|