Hello. I am trying to merge two variables by replacing the word OTHERcin one column with the content of another column. I am using the code below, but I have 3-4 cells that are blank (They didn't merge both columns). I can't seem to figure out what's the problem with those specific cells. DATA WANT(RENAME=(AFORF2=AFORF_H_OF1));; /*THE NEW RISK HISTORY COLUMN IS AFORF_H_OF1*/ set HAVE; if index(upcase(AFORF_H_OF),'OTHER') THEN DO ; AFORF1=cats(TRANSTRN(AFORF_H_OF,"Other",trimn('')),'|',Risk_H);; AFORF2=TRANWRD(AFORF1,'||','|'); END; ELSE AFORF2=AFORF_H_OF; DROP AFORF1; if index(upcase(AFORF_C_PREGN1),'OTHER') THEN DO ; AFORF_C1=cats(TRANSTRN(AFORF_C_PREGN1,"Other",trimn('')),'|',C_Risks);; AFORF_C2=TRANWRD(AFORF_C1,'||','|'); END; ELSE AFORF_C2=AFORF_C_PREGN1;/*THE NEW CURRENT RISKS COLUMN IS AFORF_C2*/ DROP AFORF_C1; RUN;
... View more