Hi all, my code currently uses the tranwrd function in order to update a column based on the occurrence of a specified substring. I would like to have a macro that achieves this in order to automate this process since my data set is quite large. Any solutions would be appreciated. My code is below.
data subject_data;
input SUBID;
datalines; /*OUTPUT*/
H7891133 1029 10151024 /*H7891133 1029 14451024*/
H7891133 1029 10241005 /*H7891133 1029 15101005*/
H7891133 1029 10241019 /*H7891133 1029 15101019*/
;
run;
Data update_sub ;
Set subject_data;
SUBID_char = put(SUBID, 22.) ;
/*drop SUBID ;
rename SUBID_char=SUBID ; */
if substr(SUBID_char,15,8)='10151024' then do
SUBID_char=tranwrd(SUBID_char, "10151024", "14451024");
put SUBID_char;
end;
if substr(SUBID_char,15,8)='10241005' then do
SUBID_char=tranwrd(SUBID_char, "10241005", "15101005");
put SUBID_char;
end;
if substr(SUBID_char,15,8)='10241019' then do
SUBID_char=tranwrd(SUBID_char, "10241019", "15101019");
put SUBID_char;
end;
run;
... View more