The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » merging different countries data
merging different countries data [message #3965] Wed, 11 March 2015 09:03 Go to next message
PMKenya is currently offline  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
Re: merging different countries data [message #3967 is a reply to message #3965] Wed, 11 March 2015 11:30 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1770
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.
Re: merging different countries data [message #3979 is a reply to message #3967] Sat, 14 March 2015 05:55 Go to previous messageGo to next message
PMKenya is currently offline  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?
Re: merging different countries data [message #3980 is a reply to message #3967] Sat, 14 March 2015 06:05 Go to previous messageGo to next message
PMKenya is currently offline  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?
Re: merging different countries data [message #3991 is a reply to message #3980] Mon, 16 March 2015 14:06 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1770
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
Previous Topic: Merge HIV data with individuals
Next Topic: merging height weight file to children's file in SPSS
Goto Forum:
  


Current Time: Fri Apr 3 06:05:03 Eastern Daylight Time 2020