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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.