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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: