I want to make new libref name and their new path so that my production code is not changed when i work on it. ***********original path************* libname t "Y:\permanent\final_data.xls"; libname p "Y:\temporary"; **********now i want to have a new libref for p i.e per and path will also be different , similarly for t new libref will be tem and a diff path*********** %let libref = p,t; %let new_libref=per,tem; %macro change; %let wordc= %sysfunc(countw(%bquote(&libref),",")); %put &wordc; %do i=1 %to &wordc; %let name = %scan("&libref",&i,","); %let new_name = %scan("&new_libref",&i,","); %put &name; %put &new_name; %if &name = p %then libname &new_name "Y:\&new_name" ; %if &name = t %then libname &new_name "Y:\&new_name\final_data.xls"; %end; %mend change; %change; the issue is that only one libref "per" is created and not tem. help needed ....Thanks in advance.
... View more