The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Reproductive Health » sas commands for delivery assistance by health professional
sas commands for delivery assistance by health professional [message #12073] Sat, 25 March 2017 11:45 Go to next message
phres110 is currently offline  phres110
Messages: 39
Registered: October 2014
Location: korea
Member
Dear Experts
Thanks in advance. Could you please help me defining sas commands for using M3A-N for delivery assistance by health professional including doctors and nurses etc (excluding TBA)
Regards
dhs110


dhs110
Re: sas commands for delivery assistance by health professional [message #12089 is a reply to message #12073] Tue, 28 March 2017 13:35 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
Sorry - we do not have SAS commands for this.
Re: sas commands for delivery assistance by health professional [message #12094 is a reply to message #12089] Tue, 28 March 2017 14:33 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
We do not have any assistance to offer on this post.
Re: sas commands for delivery assistance by health professional [message #12122 is a reply to message #12073] Wed, 29 March 2017 22:54 Go to previous messageGo to next message
phres110 is currently offline  phres110
Messages: 39
Registered: October 2014
Location: korea
Member
I am sorry i think i questioned in a wrong way. I mean to say that i want to use this variable by making a dichotomous variable doctor and all other SBA as 1 and all others including TBA as 0......kindly help me in combining M3A to N thorough SAS commands
Thanks and Regards


dhs110
Re: sas commands for delivery assistance by health professional [message #12123 is a reply to message #12073] Thu, 30 March 2017 07:32 Go to previous messageGo to next message
Mlue
Messages: 92
Registered: February 2017
Location: North West
Senior Member
Hi,

I'm not sure if this is what you're looking for, but I hope it points you into the right direction.

The code below replicates [Table 9.6 Assistance during delivery] - from the Sierra Leone DHS report of 2013


PLEASE NOTE THAT I USED THE INDIVIDUAL RECODE FILE (WOMEN DATASET) TO ACHIEVE THE FOLLOWING

Also note that in order to achieve all of this, I had to import Stata data into SAS and analyse as shown below

**========================================================== =========**

SAS programme

/** SKILLED BIRTH ATTENDANT **/
DATA SLDHS2013_1;
	SET WORK.SLDHS_2013;
	WHERE m3a in(0,1,9) AND m3b in(0,1,9) AND m3c 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	m3c = 1	THEN	skilled = 1; else
		IF	m3a 	or m3b 		or m3c 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 Sierra Leone DHS 2013 report = 59.7% */

PROC FREQ DATA=WORK.SLDHS2013_1;
	TABLE Skilled_birth /NOCOL NOROW;
	WEIGHT WEIGHT;
RUN;

/* CHECK WITH OTHER VARIABLES */

PROC FREQ DATA=WORK.SLDHS2013_1;
	TABLE V025 * Skilled_birth /NOCOL NOFREQ NOPERCENT;
	TABLE V024 * Skilled_birth /NOCOL NOFREQ NOPERCENT;
	TABLE V190 * Skilled_birth /NOCOL NOFREQ NOPERCENT;
	WEIGHT WEIGHT;
RUN;

[Updated on: Thu, 30 March 2017 09:41]

Report message to a moderator

Re: sas commands for delivery assistance by health professional [message #12129 is a reply to message #12123] Thu, 30 March 2017 21:18 Go to previous messageGo to next message
phres110 is currently offline  phres110
Messages: 39
Registered: October 2014
Location: korea
Member
Thank you very much...it worked well this is what i wanted.
Again thanks a lot.
Regards.


dhs110
Re: sas commands for delivery assistance by health professional [message #12136 is a reply to message #12073] Fri, 31 March 2017 11:44 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
Glad you found someone with SAS code to share. I just want to note that what is classified as skilled attendance is specific to each survey. For example for some surveys you would need to include additional variables other than m3a-c, and in some others you would have to exclude m3c. You would need to test this with each survey.
Re: sas commands for delivery assistance by health professional [message #12143 is a reply to message #12136] Sat, 01 April 2017 10:51 Go to previous message
Mlue
Messages: 92
Registered: February 2017
Location: North West
Senior Member
True...

I concur. dhs110, you'll have to check the footnote on the table for the country which you are interested in analysing... For Sierra Leone, m3c (MCH aide) was included under skilled birth...

See: http:// userforum.dhsprogram.com/index.php?t=msg&th=5888&got o=11843&#msg_11843
Previous Topic: Previous adverse pregnancy outcome variable
Next Topic: ANC coverage for BDHS-2011
Goto Forum:
  


Current Time: Thu Mar 28 14:34:56 Coordinated Universal Time 2024