If this was all in WORK, this is how I would do it. Note this works for a smaller amount of data sets (a few hundred). If the macro variable gets too big then a data step/call execute approach is appropriate instead.
*delete fake data to avoid issues;
proc datasets nodetails nolist;
delete first second third fourth_multi fifth_drthtest;
quit;
*create fake data for testing;
data first_drt;
set sashelp.class;
data second_drt;
set sashelp.class;
data third_drt;
set sashelp.class;
run;
data fourth_multi_drt;
set sashelp.class;
run;
data fifth_drthtest_drt;
set sashelp.class;
run;
*create a macro variable with the new and old names;
proc sql NOPRINT;
select catx("=", /*separator between name and new name*/
memname, /*original name*/
substr(memname, 1, length(memname)-4) /*new name, 4 is length of suffix to remove*/
) into :rename_list separated by " "
from sashelp.vtable
where libname='WORK' and memname like '%_DRT';
quit;
*display macro variable for confirmation;
%put &rename_list.;
options symbolgen;
proc datasets lib=work nodetails nolist;
change &rename_list;
quit;
options nosymbolgen;
Log:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /home/fkhurshed/.sasstudio/.images/d3a117db-e70b-4b05-aa58-1ef8b16a1397
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
SYMBOLGEN: Macro variable GRAPHINIT resolves to GOPTIONS RESET=ALL GSFNAME=_GSFNAME;
68
69 *delete fake data to avoid issues;
70 proc datasets nodetails nolist;
71 delete first second third fourth_multi fifth_drthtest;
72 quit;
NOTE: Deleting WORK.FIRST (memtype=DATA).
NOTE: Deleting WORK.SECOND (memtype=DATA).
NOTE: Deleting WORK.THIRD (memtype=DATA).
NOTE: Deleting WORK.FOURTH_MULTI (memtype=DATA).
NOTE: Deleting WORK.FIFTH_DRTHTEST (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 362.18k
OS Memory 25252.00k
Timestamp 10/11/2022 11:42:16 PM
Step Count 156 Switch Count 10
Page Faults 0
Page Reclaims 57
Page Swaps 0
Voluntary Context Switches 45
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
73
74 *create fake data for testing;
75 data first_drt;
76 set sashelp.class;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.FIRST_DRT has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 685.21k
OS Memory 25508.00k
Timestamp 10/11/2022 11:42:16 PM
Step Count 157 Switch Count 2
Page Faults 0
Page Reclaims 124
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
77 data second_drt;
78 set sashelp.class;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.SECOND_DRT has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 684.84k
OS Memory 25508.00k
Timestamp 10/11/2022 11:42:16 PM
Step Count 158 Switch Count 2
Page Faults 0
Page Reclaims 90
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
79 data third_drt;
80 set sashelp.class;
81 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.THIRD_DRT has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 685.21k
OS Memory 25508.00k
Timestamp 10/11/2022 11:42:16 PM
Step Count 159 Switch Count 2
Page Faults 0
Page Reclaims 88
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
82 data fourth_multi_drt;
83 set sashelp.class;
84 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.FOURTH_MULTI_DRT has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 685.21k
OS Memory 25508.00k
Timestamp 10/11/2022 11:42:16 PM
Step Count 160 Switch Count 2
Page Faults 0
Page Reclaims 88
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
85 data fifth_drthtest_drt;
86 set sashelp.class;
87 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.FIFTH_DRTHTEST_DRT has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 684.84k
OS Memory 25508.00k
Timestamp 10/11/2022 11:42:16 PM
Step Count 161 Switch Count 2
Page Faults 0
Page Reclaims 88
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
88
89
90 *create a macro variable with the new and old names;
91 proc sql NOPRINT;
92 select catx("=", /*separator between name and new name*/
93 memname, /*original name*/
94 substr(memname, 1, length(memname)-4) /*new name, 4 is length of suffix to remove*/
95 ) into :rename_list separated by " "
96 from sashelp.vtable
97 where libname='WORK' and memname like '%_DRT';
98 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.01 seconds
memory 5266.28k
OS Memory 30372.00k
Timestamp 10/11/2022 11:42:16 PM
Step Count 162 Switch Count 0
Page Faults 0
Page Reclaims 44
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
99
100 *display macro variable for confirmation;
101 %put &rename_list.;
SYMBOLGEN: Macro variable RENAME_LIST resolves to FIFTH_DRTHTEST_DRT=FIFTH_DRTHTEST FIRST_DRT=FIRST FOURTH_MULTI_DRT=FOURTH_MULTI
SECOND_DRT=SECOND THIRD_DRT=THIRD
FIFTH_DRTHTEST_DRT=FIFTH_DRTHTEST FIRST_DRT=FIRST FOURTH_MULTI_DRT=FOURTH_MULTI SECOND_DRT=SECOND THIRD_DRT=THIRD
102
103 options symbolgen;
104 proc datasets lib=work nodetails nolist;
SYMBOLGEN: Macro variable RENAME_LIST resolves to FIFTH_DRTHTEST_DRT=FIFTH_DRTHTEST FIRST_DRT=FIRST FOURTH_MULTI_DRT=FOURTH_MULTI
SECOND_DRT=SECOND THIRD_DRT=THIRD
105 change &rename_list;
106 quit;
NOTE: Changing the name WORK.FIFTH_DRTHTEST_DRT to WORK.FIFTH_DRTHTEST (memtype=DATA).
NOTE: Changing the name WORK.FIRST_DRT to WORK.FIRST (memtype=DATA).
NOTE: Changing the name WORK.FOURTH_MULTI_DRT to WORK.FOURTH_MULTI (memtype=DATA).
NOTE: Changing the name WORK.SECOND_DRT to WORK.SECOND (memtype=DATA).
NOTE: Changing the name WORK.THIRD_DRT to WORK.THIRD (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 364.06k
OS Memory 25508.00k
Timestamp 10/11/2022 11:42:16 PM
Step Count 163 Switch Count 20
Page Faults 0
Page Reclaims 48
Page Swaps 0
Voluntary Context Switches 90
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
107 options nosymbolgen;
108
109
110 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
120
User: fkhurshed
@Zeus_Olympus wrote:
Dear all,
I have a library named TEST where all datasets names have a common suffix _DRT i.e.
First_DRT
Second_DRT
Third_DRT
etc...
I need to rename all of the datasets to
First
Second
Third
etc.
without the common suffix
Any advice would be more than welcome
Thanking you in advance
