The data set looks like day1 day2 day3 ......day359 day360. 1 0 1 1 1 1 0 0 1 1 0 1 1 0 0 1. I tried to rename the variables But only day1 change to month1. 2. then i tried the code given below %macro rename1(oldvarlist, newvarlist);
%let k=1;
%let old = %scan(&oldvarlist, &k);
%let new = %scan(&newvarlist, &k);
%do %while(("&old" NE "") & ("&new" NE ""));
rename &old = &new;
%let k = %eval(&k + 1);
%let old = %scan(&oldvarlist, &k);
%let new = %scan(&newvarlist, &k);
%end;
%mend;data a ;
set b;
%rename1(day1 day2...day30, month1); /*****didnt work as only day 1 changed********/
run;
... View more