Here is what I did:

*Create new library caleld malawi;

libname malawi '/folders/myfolders/MProject/MWKR71SD';

run;

data malawi.malpro;

set malawi.MWKR71FL;

run;

proc print data=malawi.malpro;

run;

I created a new library to the exact folder I downloaded from the DHS website. Then I created a new dataset from the file(s) found in that library's folder. After that, I *plan* on selecting on the variables I want to look at, then printing the data.

Otherwise, there are like 850+ variables and 2000+ observations and printing takes forever. ]]>

I've looked through the code book/manual for the survey and have decided to look at the Rapid Malaria Test as my outcome/dependent variable and see how it is affected by the number of people in the household as well as the education level of the parents.

Does this sound like a do-able idea?

Secondly, I'm really lost in how to even get the data. I've downloaded the files for each type (household, individual, child, etc.) and I'm planning to use SAS to do my analysis.

I've downloaded both the SAS and the FLAT file types; I've also looked at the DHS website's description of each type to see what they mean (.dat, .fqw, etc.). But I can't for the life of me figure out how/where I'm supposed to get a hold of the actual data. I've tried importing all of the files (one by one) into SAS and got nowhere. I've tried opening them all up in my Text editor. Nothing.

I've tried importing the SAS7BDAT files, too, and have gotten next to nothing. I've even gotten a couple errors. Upon trying this tactic, I've gotten the following results, as mentioned in the images I've attached.

What am I doing wrong? It doesn't seem like it should be this difficult. ]]>

When the 2015 Nigeria Malaria Indicator Survey data (Household member recode file or children's file ) and the 2015 Nigeria GPS datasets are merged using their cluster numbers (HV001 in survey data and DHSCLUST in GPS data) using spss.

variables.

Thank you.]]>

]]>

Dear user,

Thank you for providing code with your question. It is greatly appreciated!

Everything looks correct with the code but with malaria microscopy you need to include hml32==6 since there were some tests that were undetermined but they still should be included in the number of children tested (or the denominator of the indicator).

Let us know if you have additional questionstab rdtmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 & (hml35==0|hml35==1) [iweight=wgt] tab micmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml32==0|hml32==1|hml32==6) [iweight=wgt]

Cameron

-------

*Parasitemia (vis RDT) in children 6-59 months

cap gen rdtmalpos=0

cap replace rdtmalpos=(HML35==1)

cap lab var rdtmalpos "Parasitemia (via RDT) in children 6-59 months"

*Parasitemia (vis microscopy) in children 6-59 months

cap gen micmalpos=0

cap replace micmalpos=(HML32==1)

cap lab var micmalpos "Parasitemia (via microscopy) in children 6-59 months"

*Weighting

gen wgt = hv005/1000000

*Proportion of children 6-59 months old with malaria infection (RDT)

tab rdtmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml35==0|hml35==1) [iweight=wgt]

tab micmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml32==0|hml32==1) [iweight=wgt]

*RDT by region

tab rdtmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml35==0|hml35==1) & hv024==1 [iweight=wgt]

tab rdtmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml35==0|hml35==1) & hv024==2 [iweight=wgt]

tab rdtmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml35==0|hml35==1) & hv024==3 [iweight=wgt]

*Mic by region

tab micmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml32==0|hml32==1) & hv024==1 [iweight=wgt]

tab micmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml32==0|hml32==1) & hv024==2 [iweight=wgt]

tab micmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml32==0|hml32==1) & hv024==3 [iweight=wgt]

]]>

https://blog.dhsprogram.com/dhsdataintro/

Thank you!

]]>

https://blog.dhsprogram.com/dhsdataintro/

Thank you!]]>

Please i need your help with this tab on stata (do file).

I try and I got the tabs (12.1; 12.5 and 12.8)

I think that the question are 134 (hml22) and 135 (hml23) (DHS 2015-2016, Angola household questionnaire)

But i´m having a wrong numbers app the filters.

example: if obtained net on campaign

gen wt=hv005/1000000 (for weight)

hml22==1 (Variable)

obs: I just try with PR data too.

Please hellpp, how can i replicate this tab using the right data?????

Thanksssssss]]>

]]>

Dear User,

All DHS Program tables are weighted (unless otherwise noted in the table). You can learn more about weighted tables by reading through the Reading and Understanding Tables from the 2015 Nigeria Malaria Indicator Survey (NMIS) pdf. Please pay close attention to page 4 of the document. https://dhsprogram.com/pubs/pdf/DM93/DM93.pdf

To answer your second question the 2010 Nigeria MIS did not sample at the state level. This means that it is not possible to compare state level data between the 2010 and 2015 MIS. You can read more about the sampling design of both reports in Appendix A in the back of each report.

I have a follow-up question on using Nigeria MIS 2010 and 2015. In your published final report for NMIS2015, there are counts for children U5 who had a positive result for malaria measurement in each state, however, the NMIS2010 report didn't have such detailed information. I would like to know 1) what does those counts mean, are they weighted number of infected children under 5 or the raw counts, are those number representative? 2) if so, how to compute the counts of children U5 who had positive results for malaria measurement in each state in Nigeria. I would like to have the comparable numbers in both 2015 and 2010.

Thanks for your kind help!

Best, J ]]>