The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Ethiopia » SPA data set related question
Re: SPA dataset: antanatal care dataset [message #17935 is a reply to message #17869] Fri, 19 July 2019 11:28 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1784
Registered: February 2013
Senior Member
Following is a response from DHS Senior Analysis and Research Manager, Wenjuan Wang:

The DRC SPA data are raw data, and the recode data are not yet available. That is why you saw the letter code as shown in the table below or in your tabulation.
Variable oa115 comes from Q115 in the ANC observation questionnaire, see below: In the raw data file, the letters remain as categories without recoding. For example, in the tabulation below, the first row means A (asked the client where she will deliver) was done for 147 observed clients; the second row "AB" means Both A and B were done for 124 clients, the third row, "ABC" means A, B, and C were done for 86 clients, so on and so forth... But when you analyze data, you probably want to know how many or what percentage of clients got A regardless instead of different combinations listed in variable oa115. In that case, you need to recode variable oa115. If you use Stata, you can use this command "regexm" to generate a new variable that indicates if A was done at all, regardless it was the only thing done or with other services.

Hope this helps and let us know if you have other questions.

gen a=0
replace a=1 if regexm(of115,"A")

  • Attachment: Antenatal.PNG
    (Size: 179.09KB, Downloaded 126 times)
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: matching data with the report
Next Topic: Where can I find ethnicity codes
Goto Forum:

Current Time: Tue May 26 04:19:13 Eastern Daylight Time 2020