The DHS Program User Forum: Merging data files » merging different countries data

Home » Data » Merging data files » merging different countries data

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

merging different countries data [message #3965]

Wed, 11 March 2015 09:03

PMKenya
Messages: 3
Registered: March 2013
Location: Nairobi Kenya

Member

I would like to work with KR files for more than 10 countries in SPSS. could someone explain to me how i can merge or append the various country files?

Thank you

Peninah

Report message to a moderator

Re: merging different countries data [message #3967 is a reply to message #3965]

Wed, 11 March 2015 11:30

Bridgette-DHS
Messages: 1821
Registered: February 2013

Senior Member

Following is a response from Senior DHS Specialist, Ladys Ortiz:

Below is an example of appending two "KR" data files from two different Kenya DHS survey using SPSS.

*Openning data file.
GET FILE='C:\DHSSurvey\KEKR31FL.SAV'.

*Appending a second file.
ADD FILES /FILE=*
/FILE='C:\ DHSSurvey\KEKR52FL.SAV'
/IN=source01.
VARIABLE LABELS source01
'Case source is C:\ DHSSurvey\KEKR52FL.SAV'.
EXECUTE.

Report message to a moderator

Re: merging different countries data [message #3979 is a reply to message #3967]

Sat, 14 March 2015 05:55

PMKenya
Messages: 3
Registered: March 2013
Location: Nairobi Kenya

Member

Thanks Bridgette-DHS

Appending done, Is it possible to create a country code based on source01? I would like to run analysis for all the 10 countries on one go from the new file that has the appended data added, is a country code going to help get results for different countries?

Report message to a moderator

Re: merging different countries data [message #3980 is a reply to message #3967]

Sat, 14 March 2015 06:05

PMKenya
Messages: 3
Registered: March 2013
Location: Nairobi Kenya

Member

Thank you for the Response, very helpful.

How do i create survey year for the two different surveys using Kenya KR files?

Report message to a moderator

Re: merging different countries data [message #3991 is a reply to message #3980]

Mon, 16 March 2015 14:06

Bridgette-DHS
Messages: 1821
Registered: February 2013

Senior Member

Response from Senior DHS Specialist, Ladys Ortiz:

This decision is up to you. You can use the "source01?" to create the country codes variable or you can create it based on variables already included in our DHS data like:
V000 = country code and phase the country
V006 = months of the interview
V007 = Year of the interview

Report message to a moderator

Previous Topic:	Merge HIV data with individuals
Next Topic:	merging height weight file to children's file in SPSS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jul 14 19:26:57 Eastern Daylight Time 2020