BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Srigyan
Quartz | Level 8
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.

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

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;

View solution in original post

2 REPLIES 2
PeterClemmensen
Tourmaline | Level 20

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;
Srigyan
Quartz | Level 8

You are genius :).

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2972 views
  • 1 like
  • 2 in conversation