topic %let & Macro issue - WARNING: Apparent symbolic reference XX not resolved." in SAS Programming

%let & Macro issue - WARNING: Apparent symbolic reference XX not resolved."

nicolaskan — Fri, 23 Feb 2018 08:03:56 GMT

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.

Re: %let & Macro issue - WARNING: Apparent symbolic reference XX not resolved."

andreas_lds — Fri, 23 Feb 2018 08:13:30 GMT

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;

Re: %let & Macro issue - WARNING: Apparent symbolic reference XX not resolved."

nicolaskan — Fri, 23 Feb 2018 08:16:18 GMT

Problem solved. Thanks for the quick reply.

Re: %let & Macro issue - WARNING: Apparent symbolic reference XX not resolved."

Patrick — Fri, 23 Feb 2018 08:42:39 GMT

@nicolaskan Then please mark the correct answer as solution.