I have many variables as the following (Year and Month go from 20170701 until 20170930: FACE_YEARMONTHDAY Bucket_YEARMONTHDAY I have saved a list of this variables in variables1709, variables1708 and variables1707 as follows: proc contents data= charge.actdays_&yymm. noprint out=conts&yymm; run; proc sql noprint; select name into :variables&yymm. separated by " " from conts&yymm where (name like "FACE%") or (name like "BUCKET%") ; quit; But i need to rename them so that every variable that begins with "FACE" now begins with "AMT" and every variable that begins with "BUCKET" now begins with "SERVICE".
... View more