data a;
input addtc $ ddtc dd;
cards;
a 1 2
a 2 3
;
run;
data b;
set sashelp.vcolumn;
where libname='WORK' and memname='A' and substr(left(reverse(name)),1,3)='ctd';;
run;
data b;
set b;
if _n_=1 then do; vlist=name;retain vlist;end;
else vlist=compress(vlist||'*'||name);
run;
data b;
set b;
by libname;
if last.libname;
vlist=tranwrd(vlist,'*',' ');
run;
proc sql noprint;
select vlist into :vlist
from b;
quit;
data c;
set a;
keep &vlist;
run;
data a;
input addtc $ ddtc dd;
cards;
a 1 2
a 2 3
;
run;
data b;
set sashelp.vcolumn;
where libname='WORK' and memname='A' and substr(left(reverse(name)),1,3)='ctd';;
run;
proc sql noprint;
select name into :keep
separated by " "
from b;
quit;