The DHS Program User Forum: Merging data files » Merging HIV data with Couples recode

Home » Data » Merging data files » Merging HIV data with Couples recode

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

Re: Merging HIV data with Couples recode [message #2346 is a reply to message #1656]

Fri, 06 June 2014 13:04

sinaiemail
Messages: 3
Registered: June 2014
Location: United States

Member

Hi Trevor-

I am also merging couples with HIV data and am having some problems. I am using SAS however, so I will review what I did in that code language. Any suggestions as to where I messed up please let me know.

First I created new variables in both datasets to merge with from the original unique identifiers:

data keyhiv.a;
set keyhiv.kear51fl;
hivclust_merge=hivclust;
hivline_merge=hivline;
hivnumb_merge=hivnumb;
hivline_merge1=hivline;
hivline_merge2=hivline;
run;

This one is unique for women
data keyhiv.w (keep=hivclust_merge hivnumb_merge hivline_merge1 whiv03 whiv05);
set keyhiv.a;
whiv03=hiv03;
whiv05=hiv05;
run;

And this one unique for men
data keyhiv.m (keep=hivclust_merge hivnumb_merge hivline_merge2 mhiv03 mhiv05);
set keyhiv.a;
mhiv03=hiv03;
mhiv05=hiv05;
run;

Now creating the same variables in the couples dataset:
data keycpl.a;
set keycpl.kecr52fl;
hivclust_merge=v001;
hivline_merge=v003;
hivnumb_merge=v002;
hivline_merge1=v003;
hivline_merge2=v034;
run;

Sorting
proc sort data= keycpl.a;
by hivclust_merge hivline_merge1 hivnumb_merge;
run;
proc sort data= keyhiv.w;
by hivclust_merge hivline_merge1 hivnumb_merge;
run;

Merging the womens data
data keymcpl.keymcpl1;
merge keyhiv.w (in=x) keycpl.a (in=y);
by hivclust_merge hivline_merge1 hivnumb_merge;
if x and y;
run;

Sorting for the mens hiv data:
proc sort data=keymcpl.keymcpl1;
by hivclust_merge hivline_merge2 hivnumb_merge;
run;

proc sort data= keyhiv.m;
by hivclust_merge hivline_merge2 hivnumb_merge;
run;

And merging one more time with mens:
data keymcpl.keymcplwm;
merge keyhiv.m (in=x) keymcpl.keymcpl1 (in=y);
by hivclust_merge hivline_merge2 hivnumb_merge;
if x and y;
run;

The unweighted final number of couples that I get with HIV data is 1228. Which I understand to be too high- I should only have 1188 before weighting. I dont understand where the extra 40 rows of data (couples) come from in my dataset. So I think the problem is before this step.

Now weighting to do the check against the final report data:
data keymcpl.keymcplwm2;
set keymcpl.keymcplwm;
wgt = mhiv05/1000000;
run;

proc freq data=keymcpl.keymcplwm2;
tables whiv03* mhiv03;
weight wgt;
run;

The numbers I get from this are 1294 total couples, 90.98% concordant neg, 2.75% m+ w-, 3.2% m- w+, 3.06% concordant pos. I am very close to the numbers in the final report, but I think it has to do with those extra 40 I have before weighting! Did they exclude any of these coupels in the final report? Please help. THANK YOU SO MUCH for your reply.

Colleen:

Report message to a moderator

[Message index]

		Merging HIV data with Couples recode By: tedrigecho on Tue, 11 March 2014 08:42
		Re: Merging HIV data with Couples recode By: Sarah-DHS on Tue, 11 March 2014 10:19
		Re: Merging HIV data with Couples recode By: tedrigecho on Wed, 12 March 2014 02:49
		Re: Merging HIV data with Couples recode By: Trevor-DHS on Wed, 12 March 2014 11:19
		Re: Merging HIV data with Couples recode By: tedrigecho on Thu, 13 March 2014 02:58
		Re: Merging HIV data with Couples recode By: tedrigecho on Fri, 14 March 2014 10:01
		Re: Merging HIV data with Couples recode By: user-rhs on Mon, 24 March 2014 17:09
		Re: Merging HIV data with Couples recode By: Trevor-DHS on Mon, 24 March 2014 14:13
		Re: Merging HIV data with Couples recode By: sinaiemail on Fri, 06 June 2014 13:04
		Re: Merging HIV data with Couples recode By: sinaiemail on Mon, 09 June 2014 11:32
		Re: Merging HIV data with Couples recode By: Bridgette-DHS on Thu, 12 June 2014 11:22

Previous Topic:	Merging data files in Stata
Next Topic:	Merge HIV and Couples

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 9 09:46:25 Coordinated Universal Time 2025