| Senegal - problem merging data from main survey and GPS [message #30621] |
Thu, 09 January 2025 10:18  |
acseng
Messages: 8
Registered: November 2024
|
Member |
|
|
I have worked with the databases from Senegal. In most of the DHS surveys, I found 1 KR file that merges with 2 GPS files: 1 GPS file with latitude/longitude, and a 2nd GPS file with temperature, vegetation, etc. I have merged each KR file with the respective 2 GPS files, creating a single file: KR file + 1st GPS file + 2nd GPS file.
However, for the DHS surveys in 2014 and 2016, the number of KR files does not match the number of GPS files (see below), so I am unsure how to merge them. I would be grateful if you could help me. I really appreciate any help you can provide.
Year Folder/subfolder files Notes
2014 1. KR databases
1.1. SN_2014_CONTINUOUSDHS_11072024_141_61143 There are 2 KR files and 3 GPS files
1.1.1. SNKR71DT
1.1.1.1. SNKR6RDT SNKR6RFL.DTA
1.1.1.2. SNKR71DT SNKR71FL.DTA
2. GPS databases
2.1. SN_2014_CONTINUOUSDHS_11112024_1036_61143
2.1.1. SNGC72FL
2.1.2. SNGE71FL SNGC72FL.csv
2.1.2.1. SNGE6RFL SNGE6RFL.dbf
2.1.2.2. SNGE71FL SNGE71FL.dbf
2016 1. KR databases There are 2 KR files and 2 GPS files
1.1. SN_2016_CONTINUOUSDHS_11072024_140_61143
1.1.1. SNKR7IDT
1.1.1.1. SNKR7IDT SNKR7IFL.DTA
1.1.1.2. SNKRG0DT SNKRG0FL.DTA
2. GPS databases
2.1. SN_2016_CONTINUOUSDHS_11112024_1035_61143
2.1.1. SNGC7JFL SNGC7JFL.csv
2.1.2. SNGE7IFL SNGE7IFL.dbf
|
|
|
|
| Re: Senegal - problem merging data from main survey and GPS [message #30650 is a reply to message #30621] |
Tue, 14 January 2025 12:04  |
Janet-DHS
Messages: 938
Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
The Senegal Continuous Survey is difficult to work with and is under-analyzed, by DHS staff as well as other users, because there are so many different files with seemingly random names.
For the recode files such as the KR file, it helps to have a list that identifies the year (v007) that goes with each filename. Some files have been issued that span two years, with separate files for each year separately.
I'm afraid I don't quite understand your issue. Can you re-state it? Is there a file that you believe should exist but you can't find it?
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
