Hi guys,
would like to seek advice in solving the issue of "apparent invocation of macro" issue when i try to use %let and & to call the variable using proc sql statement. Here is the case.
%let ABC =FY15;
/* the dataset name is "FY15_CDE" */
when i want call the macro variable in proc sql statement by:
proc sql;
create table temp as
select * from &ABC_CDE;
quit;
the warning occurs:
"WARNING: Apparent symbolic reference ABC not resolved."
May i know if there are any advice to solve this?
Thanks.
The warning should read "WARNING: Apparent symbolic reference ABC_CDE not resolved."
You have to tell sas that you want the variable ABC resolved, you just have to add a dot:
proc sql; create table temp as select * from &ABC._CDE; quit;
The warning should read "WARNING: Apparent symbolic reference ABC_CDE not resolved."
You have to tell sas that you want the variable ABC resolved, you just have to add a dot:
proc sql; create table temp as select * from &ABC._CDE; quit;
Problem solved. Thanks for the quick reply.
@nicolaskan Then please mark the correct answer as solution.
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.