Using the Service Delivery Point data with Household and Female data

The service delivery point files were designed to describe the service delivery environment that the women in sampled households experience. Facilities within the same enumeration area (EA) as samples households were chosen to be interviewed. The EAID codes, which are unique to EAs across countries and years, can be used to merge information from the SDP files onto the female record. The codes for EAID in the household and female files and the SDP files correspond exactly.

IPUMS PMA has produced Stata code to assist users in calculating indicators at the EAID level and merge the information to the person record. Before this code can be used, users must insert variables from the SDP record. Below is an example of usable code. After that is a template of code for users to adjust themselves.

local filepath "C:/Users/Documents/Data"
local sdp_data "pma_00001.dta"
local female_data "pma_00002.dta"
local statvar1 iudprov
local stat1 mean
local statvar2 fpoffered
local stat2 count
set more off

use "`filepath'/`sdp_data'"

drop if consentsq == 0
replace `stat1' = 0 if `stat1' == 99
collapse (`stat1') `statvar1' (`stat2') `statvar2', by(eaid)
merge 1:m eaid using "`filepath'/`female_data'"


The outcome of this sample code is that the number of facilities that usually offer family planning services and the percent of all facilities in the EA that provide IUDs will be attached to the person records in the data file pma_00002.

Note that cases of IUDPROV that are out of universe (code 99) are replaced with zero. The universe of IUDPROV is service delivery points that offer family planning services. Thus, out of universe cases do not offer any family planning services, and are recoded to No (code 0).

local filepath "insert filepath to SDP and female data here"
local sdp_data "pma_#####.dta" **insert name of customized
							   **SDP data file from the IPUMS website here
local female_data "pma_#####.dta" ** insert name of female data file here
local statvar1 *insert name of first variable here*
local stat1 "insert name of statistical process here.  Examples are mean,
			***median, sd, count, percent, etc"
local statvar2 *insert name of second variable here*
local stat2 "insert name of second statistical process here"
set more off

use "`filepath'\`sdp_data'"

drop if consentsq == 0
replace `stat1' = 0 if `stat1' > 90
replace `stat2' = 0 if `stat1' > 90
collapse (`stat1') `statvar1' (`stat2') `statvar2', by(eaid)
merge 1:m eaid using "`filepath'\`female_data'"