Hi, vallsas! DATA HAVE; INPUT NAME $20.; DATALINES; DR JOHN DAS DR JOHNDR DAS DR JOHN DRDAS DR JOHN DR DRDAS MISS ANNAMISS RAFT MISS ANNA MISSRAFT MISS ANNA MISS RAFT MA MIC JAG MA MICMA JAG MA MIC MAJAG MA MIC MA JAG JAGA TOOMBA YUOMBA ; RUN; DATA WANT; SET HAVE; DO; NV=TRANWRD(NAME,'DR ',''); NV=TRANWRD(NV,'MISS ',''); NV=TRANWRD(NV,'MA ',''); IF FIND(NV,'')=1 THEN NV=SUBSTR(NV,2,LENGTH(NV)); IF SUBSTR(NAME,1,3)='DR ' THEN NV_SUBSTR=SUBSTR(NAME,4,LENGTH(NAME)); ELSE IF SUBSTR(NAME,1,5)='MISS ' THEN NV_SUBSTR=SUBSTR(NAME,6,LENGTH(NAME)); ELSE IF SUBSTR(NAME,1,3)='MA ' THEN NV_SUBSTR=SUBSTR(NAME,4,LENGTH(NAME)); ELSE NV_SUBSTR=NAME; OUTPUT; END; RUN;
... View more