The DHS Program User Forum: India » Merging caste information

Home » Countries » India » Merging caste information

Show: Today's Messages :: Show Polls :: Message Navigator

Merging caste information [message #8198]

Thu, 10 September 2015 03:46

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?

Report message to a moderator

Re: Merging caste information [message #8222 is a reply to message #8198]

Thu, 17 September 2015 14:34

Bridgette-DHS
Messages: 3230
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.

Report message to a moderator

Re: Merging caste information [message #8224 is a reply to message #8222]

Fri, 18 September 2015 01:42

komalsahai
Messages: 11
Registered: September 2015

Member

Hey Bridgette!

Thank you so much for your assistance!

Report message to a moderator

Re: Merging caste information [message #8252 is a reply to message #8224]

Tue, 22 September 2015 07:20

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

You are welcome.

Report message to a moderator

Re: Merging caste information [message #8271 is a reply to message #8252]

Sat, 26 September 2015 15:46

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

Attachment: Merged data.smcl
(Size: 0.96KB, Downloaded 782 times)

Report message to a moderator

Re: Merging caste information [message #8284 is a reply to message #8271]

Wed, 30 September 2015 10:44

Bridgette-DHS
Messages: 3230
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.

Report message to a moderator

Re: Merging caste information [message #8359 is a reply to message #8284]

Wed, 14 October 2015 23:46

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

Report message to a moderator

Re: Merging caste information [message #8370 is a reply to message #8359]

Fri, 16 October 2015 13:32

Bridgette-DHS
Messages: 3230
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.

Report message to a moderator