data local.tay_nsc_all_r2; set local.tay_nsc_all_r1; rename PS_LEVEL22=PS_LEVEL23 PS_LEVEL21=PS_LEVEL22 PS_LEVEL20=PS_LEVEL21 PS_LEVEL19=PS_LEVEL20 PS_LEVEL18=PS_LEVEL19 PS_LEVEL17=PS_LEVEL18 ; /* PREDOM_FT RECODE */ if PREDOM_FT = 13 then PREDOM_FT = 29; /* TIME_IN RECODE */ if TIME_IN= 5 then TIME_IN= 6; if TIME_IN= 4 then TIME_IN= 5; if TIME_IN= 3 then TIME_IN= 4; if TIME_IN= 2 then TIME_IN= 3; if TIME_IN= 1 then TIME_IN= 2; if TIME_IN= 0.5 then TIME_IN= 1; run; /* Create full data set adding AGENCY=4 value */ data agencytemp; set local.tay_nsc_all_r2; AGENCY=4; run; data local.tay_nsc_all_r3; set local.tay_nsc_all_r2 agencytemp; run;