Can I use Macro in the table name?

[sachin01663]

Hi,

I am trying to use a macro in the table name but its not recognizing. Am I doing anything wrong?

Data test;

Set acc_&max_acc;

run;

Max_acc is macro with value 12.

Sachin

[kuridisanjeev]

Hi Sachin,

May i know what error you are getting .

I guess That variable containing leading blanks.

Regards,

Sanjeev.K

[sachin01663]

I think you are right Sanjeev. I am getting this error:

NOTE: Line generated by the macro variable "MAX_ACC".

392   acc_      12

                --

                22

ERROR: File WORK.ACC_.DATA does not exist.

There are some leading blanks before 12 so its not recognizing table name - its reading table name till Acc_.

However, I used SQL INTO: to create this macro and its numeric - so how come there are leading blanks

Thanks

Sachin

[kuridisanjeev · Accepted solution]

Yes,My Guess is Correct.

Macro variable containing Leading balnks

here is the solution to avoid these type of error,

Data a;

set acc%sysfunc(trim(&max_acc));

run;

Regards,

Sanjeev.K

[kuridisanjeev]

Hi Sachin,

Basically Macro concept is Text Substitution.So what ever the value you going to store in a macro variable ,it always stores as a text only.

Regards,

Sanjeev.K

[sachin01663]

Thank you Sanjeev. Very Helpful.