topic Can I use Macro in the table name? in SAS Programming

Can I use Macro in the table name?

sachin01663 — Mon, 30 Sep 2013 09:44:19 GMT

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 — Mon, 30 Sep 2013 09:53:04 GMT

Hi Sachin,

May i know what error you are getting .

I guess That variable containing leading blanks.

Regards,

Sanjeev.K

sachin01663 — Mon, 30 Sep 2013 10:05:11 GMT

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

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

392 acc_ 12

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 — Mon, 30 Sep 2013 10:09:14 GMT

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 — Mon, 30 Sep 2013 10:13:28 GMT

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 — Mon, 30 Sep 2013 10:27:58 GMT

Thank you Sanjeev. Very Helpful.