topic Re: inserting macro variable in the middle of specific word in SAS Programming

inserting macro variable in the middle of specific word

km0927 — Tue, 06 Nov 2018 06:11:07 GMT

hello. i want to insert macro variable in the middle of specific word.

example is as follows...

%macro test(name=);

proc sql;
create table.&namea as
select *
from mywork.sample
;quit;

%mend test;

%test(name=sample);

using macro, i want to make this.

proc sql;
create table.samplea as
select *
from mywork.sample
;quit;

however, as you might expect, error statement appears in log screen. &namea wasn't converted into 'samplea'

instead, SAS recoganize '&namea' as one complete variable.

i want to make SAS recognize '&namea' as &name+a, conclusively, 'simplea'

I would really appreciate your help. thanks.

SASKiwi — Tue, 06 Nov 2018 06:14:51 GMT

Try this:

%macro test(name=);

proc sql;
create table.&name.a as
select *
from mywork.sample
;quit;

%mend test;

%test(name=sample);

Kurt_Bremser — Tue, 06 Nov 2018 07:21:15 GMT

See Maxim 48.

s_lassen — Tue, 06 Nov 2018 14:13:15 GMT

The problem seems to be that there is a syntax error in the code you are submitting (and in the code that you are trying to generate):

You submitted "create table.&namea", I think it should be "create table &namea", with a space instead of the dot.

ballardw — Tue, 06 Nov 2018 15:03:12 GMT

%macro test(name=);

proc sql;
   create  table   &name.a   as
   select *
   from mywork.sample
   ;
quit;

%mend test;

%test(name=sample);

km0927 — Mon, 26 Nov 2018 11:43:59 GMT

thanks all. due to my submitting of master's graduation paper, i couldn't care less about this project.

i'm sorry for not accepting answer. due to my carelessness, maybe you all have wondered why answers were not accepted, though it was right.

thanks for all your help.