macro var not being resolved

[Tal]

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?

[PaigeMiller]

Does &today have a value?

[Tal]

yes  it does  ,sorry

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

[PaigeMiller]

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

[Astounding]

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 ...........;

[Tal]

%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;

[PaigeMiller · Accepted solution]

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.

[Tal]

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