The DHS Program User Forum: Merging data files » Merging individual record to couples record

Home » Data » Merging data files » Merging individual record to couples record

Show: Today's Messages :: Show Polls :: Message Navigator

Merging individual record to couples record [message #13334]

Tue, 24 October 2017 01:55

Christopher
Messages: 4
Registered: February 2017
Location: taipei, Taiwan

Member

Good day,
I am just wondering what is the SAS syntax for merging the couples record (CR) and individual record (IR) files. Am using the couples record of 2016 and also Individual record data-set of 2016. am trying to evaluate the male involvement in the uptake of Ante-Natal Care the primary outcome which is ANC visits is not available in Couples 2016 Malawi data set.

(CR + IR)

Thank you!

Attachment: MWCR7HFL.SAS
(Size: 468.97KB, Downloaded 456 times)
Attachment: MWIR7HFL.SAS
(Size: 800.76KB, Downloaded 474 times)

Report message to a moderator

Re: Merging individual record to couples record [message #13412 is a reply to message #13334]

Thu, 02 November 2017 15:31

Bridgette-DHS
Messages: 3215
Registered: February 2013

Senior Member

Following is a response from DHS Senior Sampling Specialist, Mahmoud Elkasabi:

Below is the needed SAS code

data MWIR;
set 'C:\Users\......................\MWIR7HFL.sas7bdat';
RUN;

proc sort data=MWIR;
by V001 V002 V003; run;

data MWCR;
set 'C:\Users\.......................\MWCR7HFL.sas7bdat';
RUN;

proc sort data=MWCR;
by V001 V002 V003; run;

Data MWMI;
merge MWIR MWCR;
by V001 V002 V003;
run;

Report message to a moderator

Previous Topic:	urban/rural variable with education data in dhs in stata
Next Topic:	merging household data with female data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 30 13:15:44 Coordinated Universal Time 2024