06-28-2017 10:25 AM
%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?
06-28-2017 11:04 AM
Without seeing more of your code, this is a shot in the dark. Try adding a %GLOBAL statement before assigning a value to DTE:
%let dte = %sysfunc ...........;
06-28-2017 01:03 PM
%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));
CREATE TABLE clkb_base AS
JOIN tab2 ON tab1.ADDR_ENTITY_ID = tab2.CUSTOMER_ID
JOIN tab3. ON tab1.ID = tab3.ENTITY_ID
WHERE tab2.CREATION_DATE >="&month_27"
Need further help from the community? Please ask a new question.