I'm trying to create 7 consecutive new variables Combined_Dxcode&i where each new field will contain a single, identical diagnosis code from:
the 4 variables ComorbidityCode&i (ComorbidityCode1, ComorbidityCode2, ComorbidityCode3, ComorbidityCode4)
the 3 variables DgnsCode&i (DgnsCode1, DgnsCode2, DgnsCode3, DgnsCode4)
For example,
Comorbidity1 becomes Combined_Dxcode1
Comorbidity4 becomes Combined_Dxcode4 BUT
DgnsCode1 becomes Combined_Dxcode5 ...
DgnsCode3 becomes Combined_Dxcode7
I was thinking something like below but this logic doesn't work correctly for DgnsCode1, DgnsCode2, DgnsCode3
%do i=1 %to 4; Combined_Dxcode&i = ComorbidityCode&i; %end;
Reeza, thanks for letting me know about the extra '$'!
... View more