Can I use Macro in the table name?

Accepted Solution Solved
Reply
Contributor
Posts: 40
Accepted Solution

Can I use Macro in the table name?

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


Accepted Solutions
Solution
‎09-30-2013 06:09 AM
Super Contributor
Posts: 276

Re: Can I use Macro in the table name?

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

View solution in original post


All Replies
Super Contributor
Posts: 276

Re: Can I use Macro in the table name?

Hi Sachin,

May i know what error you are getting .

I guess That variable containing leading blanks.

Regards,

Sanjeev.K

Contributor
Posts: 40

Re: Can I use Macro in the table name?

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

Solution
‎09-30-2013 06:09 AM
Super Contributor
Posts: 276

Re: Can I use Macro in the table name?

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

Super Contributor
Posts: 276

Re: Can I use Macro in the table name?

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

Contributor
Posts: 40

Re: Can I use Macro in the table name?

Thank you Sanjeev. Very Helpful.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 320 views
  • 3 likes
  • 2 in conversation