Dynamic SAS macro variable

Question

I have a SAS code like this:

%if &tp. = kdb %then %do;
    %let sn = "&kdbsn.";
%end;
%if &tp. = bkb %then %do;
    %let sn = &bkbsn.;
%end;
%if &tp. = edw %then %do;
    %let sn = &edwsn.;
%end;
%if &tp. = odw %then %do;
    %let sn = &odwsn.;
%end;
%if &tp. = adw %then %do;
    %let sn = &adwsn.;
%end;

%put &sn;

I need to do this for many other cases and the pattern is always the same. Depending on the variable &tp. I set the variable &sn. to the same value as a variable with a name that has the first 3 characters equal to value of &tp. and two additional characters sn. Is there a function that would return the name of variable that I need so I don't need to have endless number of if statements?

Why does one add quotes and the other's don't?

Tom
– Tom

2018-10-15 19:29:59 +00:00
Commented Oct 15, 2018 at 19:29 — Tom
– Tom, Commented Oct 15, 2018 at 19:29

Tom · Accepted Answer · 2018-10-15 19:33:43Z

5

You add more &. The macro processor resolves && to & and sets a note to itself to rescan the token for more macro processing.

%let tp=kdb;
%let kdbsn=1234;
%let sn=&&&tp.sn ;

So && -> & and &tp. -> kdb to get &kdbsn, which will resolve to 1234.

answered Oct 15, 2018 at 19:33

Tom

52.3k2 gold badges19 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dynamic SAS macro variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related