I have a macro to import multiple excel spreadsheets and then to rename some column names to be consistent across the datasets. However only some of the datasets have the 'oldname' column name so rename is failing when it can't find the column name. Is there a way to use rename=(&renamelist.) to rename column names that exist and just skip over those that are not found in the datasets rather than stop the process? proc sql print; select catx('=', OldName, NewName) into :renamelist separated by " " from work.DataName; quit; data _null_; set sashelp.vcolumn (where=(libname="WORK" and memname= "&&data.")); if _n_ = 1 then call execute('data &&data.; set &&data. (rename=(&renamelist.)); run;'); Run;
... View more