There is no error, it runs perfectly fine. However, I did not write it, I modified the code that was given on here by a few nice individuals, so that it would work for my specific datasets. But, it's the old "give a man a fish/teach a man to fish" proverb. I am now asking for assistance in understanding what the specific lines of the code are accomplishing. I simply do not really understand it. Specifically this part, and any help outling each step of the code and what it is doing would be greatly, greatly appreciated. proc sql noprint; select quote(trim(name)) into :names separated by ',' from dictionary.columns where libname='WORK' AND memname='B'; create table temp as select * from renames where original in (&names); select catx('=',original,newname) into :rename separated by ' ' from temp; quit; %put &rename; proc datasets nolist lib=work; modify b ; rename &rename; run; quit;
... View more