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
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
Hi Sachin,
May i know what error you are getting .
I guess That variable containing leading blanks.
Regards,
Sanjeev.K
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
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
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
Thank you Sanjeev. Very Helpful.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.