I am trying to run the follwing macro fro simple purpose to rename the variables. But somehow the macro variables do not get resolved, unable to understand why.Any help would be appreciated. %macro renaming; %do i=1 %to &vmcnt; data V_&i._b; set V_&i._b; rename _LEAF_=&&V_&i.._B;*These are the bins of interest of the varialbe which are generateted in form of 1,2,3 and etc.; rename P_&target=&&V_&i.._P;*This is the avg probablity of target in each bin of the variable; run; %end; %mend; %renaming; Log is:- MLOGIC(RENAMING): %DO loop index variable I is now 3; loop will iterate again. MPRINT(RENAMING): data V_3_b; MPRINT(RENAMING): set V_3_b; 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Syntax error, expecting one of the following: -, :, =. 76: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 76-322: Syntax error, statement will be ignored. MPRINT(RENAMING): rename _LEAF_=ltv_orig _B; 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Syntax error, expecting one of the following: -, :, =. 76: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 76-322: Syntax error, statement will be ignored. MPRINT(RENAMING): rename P_lgd_tgt=ltv_orig _P; MPRINT(RENAMING): run; WARNING: Variable P_lgd_tgt cannot be renamed to ltv_orig because ltv_orig already exists. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.V_3_B may be incomplete. When this step was stopped there were 0 observations and 5 variables. WARNING: Data set WORK.V_3_B was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds
... View more