SKILLED BIRTH ATTENDANTS ON SAS
PDHS 2012-13
/** SKILLED BIRTH ATTENDANT **/
DATA Pakistan_DHS;
SET WORK.births_recode;
WHERE m3a in(0,1,9) AND m3b in(0,1,9) AND m3i in(0,1,9) /*AND v208 in(1,2,3,4)*/;
/* THE CODE ABOVE SELECTS THE SAMPLE TO MATCH THE TABLE IN THE DHS REPORT */
/* NOW, TO DERIVE THE DEPENDENT VARIABLE (Skilled_birth)*/
IF m3a = 1 or m3b = 1 or m3i = 1 THEN skilled = 1; else
IF m3a or m3b or m3i NE 1 THEN skilled = 0;
FORMAT skilled_birth$32.;
IF skilled = 0 THEN Skilled_birth = "0. Non-skilled provider";
IF skilled = 1 THEN Skilled_birth = "1. Skilled provider";
WEIGHT = (v005 / 1000000);
PROC TEMPLATE;
EDIT BASE.FREQ.CROSSTABFREQS;
EDIT FREQUENCY;
FORMAT=BEST12.;
END;
END;
RUN;
/* CHECK IF IT MATCHES THE RESULTS ON THE DHS REPORT*/
/* Percentage delivered by a skilled provider in Pakistan DHS 2012-13 report = 52.1% and I get 52.6%*/
PROC FREQ DATA=WORK.Pakistan_DHS;
TABLE Skilled_birth /NOCOL NOROW;
WEIGHT WEIGHT;
RUN;
/* CHECK WITH OTHER VARIABLES */
PROC FREQ DATA=WORK.Pakistan_DHS;
TABLE V025 * Skilled_birth /NOCOL NOFREQ NOPERCENT;
TABLE V024 * Skilled_birth /NOCOL NOFREQ NOPERCENT;
TABLE V190 * Skilled_birth /NOCOL NOFREQ NOPERCENT;
WEIGHT WEIGHT;
RUN;