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?

Posted in reply to sachin01663

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?

Posted in reply to sachin01663

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?

Posted in reply to kuridisanjeev

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?

Posted in reply to sachin01663

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?

Posted in reply to sachin01663

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?

Posted in reply to kuridisanjeev

Thank you Sanjeev. Very Helpful.

🔒 This topic is solved and locked.

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

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