topic Re: Can %let statement be used to substitute just a part of a word? in New SAS User

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

ari2495 — Wed, 28 Jun 2023 06:08:58 GMT

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

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

Patrick — Wed, 28 Jun 2023 07:01:45 GMT

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.