Home » Topics » Service Provision Assessment (SPA) » Merging Nepal datasets (2015 and 2021_ (Nepal data merge)
|
Re: Merging Nepal datasets (2015 and 2021_ [message #28788 is a reply to message #28754] |
Thu, 07 March 2024 13:10 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
Janet-DHS
Messages: 805 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS SPA Specialist, Rajendra Dangol:
Hello Emily,
From the survey design, sub-region was not included in the 2021 Nepal SPA because it was not representative as a sample domain. There is Province in the 2021 Nepal SPA, although Province was not included in the 2015 Nepal SPA.
However, there are District codes in both surveys (variable V002 from the recode file). Note that the order of the District codes differs between the 2015 and 2021 datasets, but you can use the District labels to find the same District between the 2021 and 2015 surveys. You can create sub-region using the District variable as follows:
First, these are District codes in 2021 and 2015 from the recode datasets:
V002 District code in 2021 Nepal SPA. Note that this is a longer list, but the screenshot is truncated.
![/index.php?t=getfile&id=2262&private=0](/index.php?t=getfile&id=2262&private=0)
V002 District code in 2015 Nepal SPA. Note that this is a longer list, but this screenshot is truncated.
![/index.php?t=getfile&id=2263&private=0](/index.php?t=getfile&id=2263&private=0)
Below is the recoding from District into Sub-regions from the 2015 Nepal SPA:
{13 Sub-regions as per sample design - country specific}
recode DISTRICT => V001;
1,9,11 => 1; {Eastern mountain}
22,23,29 => 2; {Central mountain}
41,42,62,63,64,65,66,67,68,75 => 3; {Western mountain}
2,3,7,8,10,12,13,14 => 4; {Eastern hill}
20,21,24,25,26,27,28,30,31 => 5; {Central hill}
36,37,38,39,40,43,44,45,46,47,51 => 6; {Western hill}
52,53,54,55,59,60,61 => 7; {Mid western hill}
69,70,73,74 => 8; {Far western hill}
4,5,6,15,16 => 9; {Eastern terai}
17,18,19,32,33,34,35 => 10; {Central terai}
48,49,50 => 11; {Western terai}
56,57,58 => 12; {Mid western terai}
71,72 => 13; {Far western terai}
endrecode;
-
Attachment: 28754-1.png
(Size: 49.55KB, Downloaded 117 times)
-
Attachment: 28754-2.png
(Size: 40.89KB, Downloaded 111 times)
|
|
|
|
Goto Forum:
Current Time: Sat Aug 24 22:15:11 Coordinated Universal Time 2024
|