Hi Everyone, I am trying to rename all my column names to something that is meaningful to the audience. My column names vary from demand1-demand288. I would like it to be renamed to Input Table: Demand1, Demand2, Demand3, Demand4........Demand288 Output Table: Demand0000, Demand0005,Demand0010.........Demand2355 Required: Demand1 --> Demand0000 Demand2 --> Demand0005 Demand3 --> Demand0010 : : Demand12 --> Demand0055 Demand13 --> Demand1000 : : Demand288 --> Demand2355 Sample Code: DATA WORK.DEMAND_TEST;; ARRAY DEMAND [288] DEMAND1 - DEMAND288; run; %MACRO TEST_RENAME; DATA WORK.RENAME_TEST; SET WORK.DEMAND_TEST; %DO i = 0 %TO 23 %BY 1; %DO j = 0 %TO 55 %BY 5; k+1; CALL SYMPUTX("k" ,k); RENAME DEMAND&k = DEMAND&i&j; OUTPUT; %END; %END; RUN; %MEND; %TEST_RENAME; Any help is much appreciated.
... View more