I am trying to rename all the columns by adding a sequence as suffix. For example, right now my column names are A B C... and I want to rename them to var1 var2 var3...   Is there a way to do it? Thanks! ... View more

I am trying to rename my columns in a macro but my desired column names have spaces and special characters in them. (e.g. change column name aaa to aaa $)The code with nliteral works fine outside of the macro but when running in the macro it produces error:    ERROR 24-322: Variable name is not valid.   My code is below   data names; input name_old $3. name_new & $5.; datalines; aaa aaa $ bbb bbb $ ; run; %macro process; PROC SQL; SELECT cats(name_old,' = ',nliteral(name_new)) INTO :rename separated by ' ' FROM names; quit; data data2; SET data1 (rename=(&rename)); run; %mend; %process;   I need to write in the macro because I have to perform this action to proceed to my next desired output for multiple data sets.   Thanks for your help! ... View more

Hi,   I am trying to read in selected tabs from a excel file and append them into one dataset. I have created a macro variable called TabList where the values are quoted strings with spaces in them (e.g. "aaa bbb","bbb ccc"...) as this is how the sheets are named. I am having trouble passing the list in macro. I am getting the following error with the code below:   ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required.   Thank you for your help!   proc sql; select Tab into :TabList separated by "," from mapping; quit;   %macro process; %let n=%sysfunc(countw("&TabList.", ',' )); %put &n; %do i=1 %to &n; %let val = %scan(&TabList.,&i); %put &val &i &n; OPTION VALIDVARNAME=V7; PROC IMPORT DATAFILE= &in_dir. OUT= data DBMS=XLSX REPLACE; SHEET= &val; GETNAMES=NO; datarow=3; RUN; %end; %mend; %process; ... View more