Please explain the expected result. Do you want to append the monthly datasets creating a new dataset? Or, do you want to rename the monthly datasets?
The following code creates one dataset per quarter:
proc sql noprint;
create view work.datasets as
select catx('.', LibName, MemName) as Dataset,
input(cats('01', substr(MemName, 6)), ddmmyy8.) as quarter format=yyq.
from sashelp.vtable
where libname = 'WORK' and MemName like 'CASE%2017'
order by quarter;
;
quit;
data work.NewNames;
set work.Datasets;
by quarter;
length DatasetList $ 200;
if first.Quarter then DatasetList = '';
DatasetList = catx(' ', DatasetList, Dataset);
if last.Quarter then do;
call execute(catx(' ', 'data', cats('case_', vvalue(Quarter)), '; set', DatasetList, '; run;'));
end;
run;
... View more
