topic set if dataset have same suffix in SAS Programming

set if dataset have same suffix

Srigyan — Mon, 23 Sep 2019 13:18:48 GMT

data all;
set "%summary";//(All dataset where data name is suffix with "summary")
run;

I want to set all the data set if that suffix with summary.

Is there any way I can do that.

Re: set if dataset have same suffix

PeterClemmensen — Mon, 23 Sep 2019 13:22:37 GMT

One way..

data onesuffix;
   a=1;
run;

data two;
   a=2;
run;

data threesuffix;
   a=3;
run;

proc sql noprint;
   select memname into :ds separated by ' ' 
   from dictionary.tables
   where libname='WORK' & memname like '%SUFFIX';
quit;

%put &ds.;

data want;
   set &ds.;
run;

Re: set if dataset have same suffix

Srigyan — Mon, 23 Sep 2019 13:35:43 GMT

You are genius :).