topic Re: macro var not being resolved in SAS Procedures

macro var not being resolved

Tal — Wed, 28 Jun 2017 14:25:53 GMT

hello,

%LET dte = %sysfunc(intnx(month, &today, -27));

i am running a query with a pass through connection and when using

where>'01Mar2015'd everything looks fine but if i use a macro variable

where>&dte then i get the warning 'symbolic reference dte not being resolved" which leads to an error

i also tried to double qoute this macro var and again the same warning and error

Any idea why is this happening?

Re: macro var not being resolved

PaigeMiller — Wed, 28 Jun 2017 14:29:49 GMT

Does &today have a value?

Re: macro var not being resolved

Tal — Wed, 28 Jun 2017 14:40:42 GMT

yes it does ,sorry

%LET today = %sysfunc(today());

Re: macro var not being resolved

PaigeMiller — Wed, 28 Jun 2017 14:42:47 GMT

Then we need to see a larger section of your code so we can understand the entire usage.

Re: macro var not being resolved

Astounding — Wed, 28 Jun 2017 15:04:52 GMT

Without seeing more of your code, this is a shot in the dark. Try adding a %GLOBAL statement before assigning a value to DTE:

%global dte;

%let dte = %sysfunc ...........;

Re: macro var not being resolved

Tal — Wed, 28 Jun 2017 17:03:35 GMT

%global not working either 😞

the code works fine if i use tab2.CREATION_DATE >="01MAR2015"d but not if i use the macro var below and it resolves fine everywhere out of the query but not in the query below

%LET today = %sysfunc(today());
%LET month_27 = %sysfunc(intnx(month, &today, -27));

%put &month_27;

CREATE TABLE clkb_base AS
SELECT x,y,z

FROM tab1
JOIN tab2 ON tab1.ADDR_ENTITY_ID = tab2.CUSTOMER_ID
JOIN tab3. ON tab1.ID = tab3.ENTITY_ID
........................
.........................
WHERE tab2.CREATION_DATE >="&month_27"
QUIT;

Re: macro var not being resolved

PaigeMiller — Wed, 28 Jun 2017 17:15:31 GMT

You don't need the double quotes around &month_27

This macro variable is resolved for me in my application with my database and works as expected.

Re: macro var not being resolved

Tal — Wed, 28 Jun 2017 17:36:37 GMT

yea,i also tried the same code on EG SAS and works but did not on PC SAS so definately not a syntax issue

thank you