Can %let statement be used to substitute just a part of a word?

[ari2495]

Hi everybody, what i mean is I have two dataset which are named the same with the difference of a number, can i use %let so that the code runs the two dataset?

%let number=xx;

data= DB&number;
set DBinput;
run;

would this work? is it correct? thanks for support

[Patrick · Accepted solution]

The macro variable will resolve before the data step executes. The SAS "data step compiler" will "see":

data= DBxx;
set DBinput;
run;

If that's what you want to happen then you're good to go.