SAS Rename - proc datasets

SAS_rename_data_set_proc_datasets.sas

/*This code illustrates how to rename data sets dynamically*/

data _new_list;
 set sashelp.vtable 
    (where=(upcase(libname)='WORK')) end=eof;
 *filter list for only tables of interest;
 
 
 *start proc datasets;
 if _n_=1 then
    call execute ('proc datasets lib=WORK nodetails nolist; change');
    
 *add on new name calculation;
 new_name=catt('Name', put(_n_, z3.));
 
 *pass new and old name to proc datasets;
 call execute (memname);
 call execute ('=');
 call execute (new_name);
 
 *if last record then quit;
 If eof then
    call execute (';run;quit;');
run;