The DHS Program User Forum: Dataset use in SPSS

Home » Data » Dataset use in SPSS » Duplicate variables?

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

Duplicate variables? [message #779]

Mon, 16 September 2013 16:05

WoodyWoodruff
Messages: 5
Registered: September 2013
Location: Victoria, British Columbi...

Member

Dear All:
I am new to DHS data analysis, so please excuse what may be an overly simple question. I am using the child data from the three surveys in Ethiopia. So far, I have looked extensively only at the DHS 2010 dataset in which there seems to be duplicate variables, most of which contain the same data. However, there is one pair of variable (V415 and M38) which both seem to contain the responses to question 460 on the woman's questionnaire (Did (NAME) drink anything from a bottle with a nipple yesterday or last night?). Although the Recode Manual for DHS6 contains the same description of these two variables, the data in them are different, as demonstrated by a cross-tabulation (see attached file). Does anyone know what is the difference between the data in these two variables?
Thanks in advance for any help.

Attachment: Cross-tab V415 and M38.jpg
(Size: 24.79KB, Downloaded 922 times)

Report message to a moderator

Re: Duplicate variables? [message #834 is a reply to message #779]

Fri, 11 October 2013 08:39

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Here is a response from one of our Senior Data Processing Specialists, Lady Ortiz, that should answer your questions.

Question M38 "drank from a bottle with nipple" was asked for all living children born in the last 5 years preceding the survey. Question V415 has the same information as M38 but contains information only for the LAST child born in the last 5 years before the survey.

Report message to a moderator

Re: Duplicate variables? [message #836 is a reply to message #834]

Fri, 11 October 2013 21:35

WoodyWoodruff
Messages: 5
Registered: September 2013
Location: Victoria, British Columbi...

Member

Dear Ms. Ortiz:

Thank you for your prompt answer. You know what they say: Don't demonstrate your competence or people will put you to work. So here's a few more questions I have about DHS datasets:

1) Two variables (V024 and V101) seem to contain the region of residence. What is the difference between them?

2) Two variables record time after birth breastfeeding was initiated: V426 and M34. This question asked ONLY about most recently born child. In the DHS 2011 Ethiopia child dataset, V426 has only 250 (3.0%) missing values. M34 has 4,114 (35.3%) missing values, which seems more likely given that children born less recently should have missing values. What is the difference between these two variables?

Thank you in advance for your help.

Report message to a moderator

Re: Duplicate variables? [message #886 is a reply to message #836]

Tue, 29 October 2013 12:25

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Here is another answer from Ms. Ladys Ortiz:

Dear Woody

Variables V024 and V101 has the same information but different denominators. Unfortunately you can't see the difference because when we export our data to SPSS/Stat/SAS, we only include completed cases. V024 has the region information for all the individuals regardless of the result of the interview; V101 has the region information for individuals with completed interviews only.

In reference to your second question, you should follow the same approach in my previous answer, related to questions M38/V415.

Thanks

Ladys

Report message to a moderator

Previous Topic:	Transforming variables to combine responses in SPSS
Next Topic:	Data Analysis in SPSS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 26 17:40:09 Coordinated Universal Time 2024