Hello experts! I need help in merging this data set. Everything comes out fine expect the 2nd column "visit" please see pictures below. Any guidance will be much appreciated. Here is the directions for my problem: Patients underwent knee replacement surgeries for one or both knees. The data record patient id, the replaced knee number (1 or 2), and satisfaction scores pre-operatively, one day, one week, and one month after the surgery. The data are Patient Knee Score Score at Score at Score at ID Number Pre-op one day one week one month 01 1 0 5 7 10 02 1 0 10 15 15 02 2 3 5 8 10 03 1 0 3 3 3 03 2 0 6 9 9 04 1 0 4 10 10 C) Use the MERGE statement to create the merged file Here is my code for part C: data examEX4;
input id $ KneeNumber ScorePre Score1Day Score1Week Score1Month;
cards;
01 1 0 5 7 10
02 1 0 10 15 15
02 2 3 5 8 10
03 1 0 3 3 3
03 2 0 6 9 9
04 1 0 4 10 10
;
data A(keep=id visit score_knee1);
set examEX4;
array x[4] ScorePre Score1Day Score1Week Score1Month;
do i=1 to 4;
visit=i;
score_knee1=x[i];
if KneeNumber=1;
output;
end;
run;
data B(keep=id visit score_knee2);
set examEX4;
array x[4] ScorePre Score1Day Score1Week Score1Month;
do i=1 to 4;
visit=i;
score_knee2=x[i];
if KneeNumber=2;
output;
end;
run;
proc sort data=A;
by id;
proc sort data=B;
by id;
run;
data A_B_merged;
merge A B;
by id;
run;
proc print noobs;
run; However my output looks like this: when it needs to look like this: Thank you for any help.
... View more