The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Merging caste information
Merging caste information [message #8198] Thu, 10 September 2015 03:46 Go to next message
komalsahai is currently offline  komalsahai
Messages: 11
Registered: September 2015
Member
Hi!

I am working with the NFHS III data. It provides specific caste names of all individuals and the household, but in a separate file. I want to merge it with one of the master files, say the couple recode file, IACR52FL. But there is no unique identifier in the castetribe file with which to merge it with any other data set. Could you assist me on how to do it?
Re: Merging caste information [message #8222 is a reply to message #8198] Thu, 17 September 2015 14:34 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member
Following is a response from Senior DHS Data Processing Specialist, Noureddine Abderrahim:

CTSTATE ( State ), CTPSU ( PSU ), CTHOUSE ( Household number ), and CTIND ( Individual ) are the identifiers of the cases in the Caste/Tribe data file that need to be used in conjunction with the variables V024, V001, V002, and V003 of the couple's file.

Re: Merging caste information [message #8224 is a reply to message #8222] Fri, 18 September 2015 01:42 Go to previous messageGo to next message
komalsahai is currently offline  komalsahai
Messages: 11
Registered: September 2015
Member
Hey Bridgette!

Thank you so much for your assistance!
Re: Merging caste information [message #8252 is a reply to message #8224] Tue, 22 September 2015 07:20 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member
You are welcome.
Re: Merging caste information [message #8271 is a reply to message #8252] Sat, 26 September 2015 15:46 Go to previous messageGo to next message
komalsahai is currently offline  komalsahai
Messages: 11
Registered: September 2015
Member
Dear Bridgette

I used the four variables told by you and merged the two data sets. However, the two data sets do not match completely. There are over 2000 unmatched entries in the couple data set. I am attaching the log file. Kindly look into it and suggest any solution if possible.

Regards
Komal
Re: Merging caste information [message #8284 is a reply to message #8271] Wed, 30 September 2015 10:44 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member
Following is a response from Senior DHS Data Processing Specialist, Noureddine Abderrahim:

The dropped cases might be incomplete cases that were excluded from the distributed data file but not from the Caste/Tribe file. Would you double check the numbers for the complete data file with the table 1.1 of the survey's final report?

Let us know if you still have problems.


Re: Merging caste information [message #8359 is a reply to message #8284] Wed, 14 October 2015 23:46 Go to previous messageGo to next message
komalsahai is currently offline  komalsahai
Messages: 11
Registered: September 2015
Member
Dear Bridgette,

I first of all converted the data in the couple recode from wide format to long format. Then i created a unique id for each entry. Due to polygamy, i had to drop 42 entries. After that, i merged this with the Caste/Tribe file, and then reconverted the data into wide format. Now, the caste information is missing for 1313 females and 1319 males. This effectively makes 2632 couples' information incomplete.
Is there a way to rectify this issue? i.e. can the missing caste data be obtained for the missing entries?

Thanks and regards
Komal
Re: Merging caste information [message #8370 is a reply to message #8359] Fri, 16 October 2015 13:32 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member
Following is a response from Senior DHS Data Processing Specialist, Noureddine Abderrahim:

Unfortunately, the survey is over and there is no way to go back to the survey respondents, and gather the missing information.
Re: Merging caste information [message #8371 is a reply to message #8370] Fri, 16 October 2015 14:41 Go to previous messageGo to next message
komalsahai is currently offline  komalsahai
Messages: 11
Registered: September 2015
Member
Yes I understand Brigette. Anyway, thank you for your assistance.
Re: Merging caste information [message #8385 is a reply to message #8371] Wed, 21 October 2015 12:30 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member
You are welcome.
Previous Topic: Appropriate stratification variable for NFHS data
Next Topic: India Subdistrict (Tehsil) Codes, 199203 NFHS
Goto Forum:
  


Current Time: Thu Mar 28 06:38:47 Coordinated Universal Time 2024