Hi Community, I am new to SAS Macro. I am debugging a code at the moment and having trouble trying to determine where the dates are coming from. How do I find out where the dates are coming from? Appreciate your help Below is the macro that is pulling the dates: %DetermineLoadDate(DefaultLoadPeriod=YESTERDAY); Below are the results from the log when running the above macro: SYMBOLGEN: Macro variable DATEUSEDFLAG2 resolves to SPECIFIED SYMBOLGEN: Macro variable DATEUSEDFLAG2 resolves to SPECIFIED SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATE resolves to 21494 SYMBOLGEN: Macro variable DATE resolves to 21494 SYMBOLGEN: Macro variable DATE resolves to 21494 SYMBOLGEN: Macro variable DATE resolves to 21494 SYMBOLGEN: Macro variable CALYEAR resolves to year(21494) SYMBOLGEN: Macro variable CALMONTH resolves to month(21494) SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATE resolves to 21494 SYMBOLGEN: Macro variable DATE resolves to 21494 SYMBOLGEN: Macro variable CALMONTH resolves to month(21494) SYMBOLGEN: Macro variable DATEUSEDFLAG2 resolves to SPECIFIED SYMBOLGEN: Macro variable FMTH resolves to month SYMBOLGEN: Macro variable CYR resolves to cyr SYMBOLGEN: Macro variable FYR resolves to input(year,4.) SYMBOLGEN: Macro variable CYR resolves to cyr SYMBOLGEN: Macro variable FYR resolves to input(year,4.) SYMBOLGEN: Macro variable CMTH resolves to cmth SYMBOLGEN: Macro variable FMTH resolves to month SYMBOLGEN: Macro variable DATEUSEDFLAG2 resolves to SPECIFIED SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 SYMBOLGEN: Macro variable DATEPASSED resolves to 21494 NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 16:59 16:183 NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 3 The SAS System 14:25 Wednesday, November 7, 2018 16:119 16:211 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable DAY_DATE9 resolves to 06NOV2018 SYMBOLGEN: Macro variable YEARTO resolves to 31AUG2019 SYMBOLGEN: Macro variable DAY_DATE9 resolves to 06NOV2018 SYMBOLGEN: Macro variable DAY_DATE9 resolves to 06NOV2018 SYMBOLGEN: Macro variable DAY_DATE9 resolves to 06NOV2018 SYMBOLGEN: Macro variable YEARFROM resolves to 01SEP2018 SYMBOLGEN: Macro variable YEARFROM resolves to 01SEP2018 SYMBOLGEN: Macro variable YEARFROM resolves to 01SEP2018 SYMBOLGEN: Macro variable YEARFROM resolves to 01SEP2018 SYMBOLGEN: Macro variable DAY_DATE9 resolves to 06NOV2018 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable DAY_DATE9 resolves to 06NOV2018 SYMBOLGEN: Macro variable MONTHTO resolves to 30NOV2018 SYMBOLGEN: Macro variable P_CMTHEND resolves to 31OCT2018 SYMBOLGEN: Macro variable DAY_DATE9 resolves to 06NOV2018 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable DATEUSEDFLAG2 resolves to SPECIFIED SYMBOLGEN: Macro variable DATEUSEDFLAG2 resolves to SPECIFIED SYMBOLGEN: Macro variable DATESPECIFIED resolves to 06NOV2018 SYMBOLGEN: Macro variable FMTH resolves to 03 SYMBOLGEN: Macro variable FYR resolves to 2019 SYMBOLGEN: Macro variable YRMTH resolves to 201903 SYMBOLGEN: Macro variable MONTHFROM resolves to 01NOV2018 SYMBOLGEN: Macro variable MONTHTO resolves to 30NOV2018 SYMBOLGEN: Macro variable SOM_YMD resolves to 20181101 SYMBOLGEN: Macro variable EOM_YMD resolves to 20181130 SYMBOLGEN: Macro variable YEARFROM resolves to 01SEP2018 SYMBOLGEN: Macro variable YEARTO resolves to 31AUG2019 SYMBOLGEN: Macro variable EOY_YMD resolves to 20190831 SYMBOLGEN: Macro variable CMTH resolves to 11 SYMBOLGEN: Macro variable CYR resolves to 2018 SYMBOLGEN: Macro variable CQTR resolves to 4 SYMBOLGEN: Macro variable CQTR_YRMTH resolves to 201810 SYMBOLGEN: Macro variable P_FMTH resolves to 02 SYMBOLGEN: Macro variable P_FYR resolves to 2019 SYMBOLGEN: Macro variable P_YRMTH resolves to 201902 SYMBOLGEN: Macro variable P_CMTHEND_YMD resolves to 20181031 SYMBOLGEN: Macro variable P_CMTHEND resolves to 31OCT2018 4 The SAS System 14:25 Wednesday, November 7, 2018 SYMBOLGEN: Macro variable P_CMTHFROM resolves to 01OCT2018 SYMBOLGEN: Macro variable P_CMTH resolves to 10 SYMBOLGEN: Macro variable P_CYR resolves to 2018 SYMBOLGEN: Macro variable P_CQTR resolves to 4 SYMBOLGEN: Macro variable P_CQTR_YRMTH resolves to 201810 SYMBOLGEN: Macro variable NEXT_FMTH resolves to 04 SYMBOLGEN: Macro variable NEXT_FYR resolves to 2019 SYMBOLGEN: Macro variable NEXT_YRMTH resolves to 201904 SYMBOLGEN: Macro variable NEXT_CMTHEND resolves to 31DEC2018 SYMBOLGEN: Macro variable NEXT_CMTHFROM resolves to 01DEC2018 SYMBOLGEN: Macro variable NEXT_CMTH resolves to 12 SYMBOLGEN: Macro variable NEXT_CYR resolves to 2018 SYMBOLGEN: Macro variable HALFYR_FROM resolves to 01JUN2018 SYMBOLGEN: Macro variable HALFYR_FMTH resolves to 10 SYMBOLGEN: Macro variable HALFYR_FYR resolves to 2018 SYMBOLGEN: Macro variable QTR resolves to 1 SYMBOLGEN: Macro variable P_QTR resolves to 4 SYMBOLGEN: Macro variable QTRFROM resolves to 01SEP2018 SYMBOLGEN: Macro variable QTRTO resolves to 30NOV2018 SYMBOLGEN: Macro variable DAY_YMD resolves to 20181106 SYMBOLGEN: Macro variable YYMMDD resolves to 181106 SYMBOLGEN: Macro variable CYYMM resolves to 1811 SYMBOLGEN: Macro variable NEXT_DMY resolves to 07112018 SYMBOLGEN: Macro variable DAY_DATE9 resolves to 06NOV2018 SYMBOLGEN: Macro variable WEEKDAY resolves to 3 SYMBOLGEN: Macro variable YESTERDAY resolves to 05NOV2018 SYMBOLGEN: Macro variable TOMORROW resolves to 07NOV2018 SYMBOLGEN: Macro variable YMD resolves to 20181106 SYMBOLGEN: Macro variable P_YMD resolves to 20181105 SYMBOLGEN: Macro variable MONTHWORD resolves to November SYMBOLGEN: Macro variable DAYSINMONTH resolves to 30 SYMBOLGEN: Macro variable DAYSINYEAR resolves to 365 SYMBOLGEN: Macro variable CALDTE resolves to November 2018 SYMBOLGEN: Macro variable REPORTDATE resolves to 07NOV2018 SYMBOLGEN: Macro variable TODAY_YMD resolves to 20181107 SYMBOLGEN: Macro variable LAST_EOM_DATE resolves to 31OCT2018 SYMBOLGEN: Macro variable FWK resolves to 11 SYMBOLGEN: Macro variable CREATEDATEMACROVARSERR resolves to 0 This Financial month macro variables from Date Specified of 06NOV2018: This Financial month macro variables: fmth =03 fyr =2019 YrMth =201903 MonthFrom =01NOV2018 MonthTo =30NOV2018 som_ymd =20181101 eom_ymd =20181130 YearFrom =01SEP2018 YearTo =31AUG2019 eoy_ymd =20190831 This Calendar month macro variables: cmth =11 cyr =2018 CQtr =4 (Calendar Year Quarter) CQtr_yrmth =201810 (Quarter Start Year/Month) 5 The SAS System 14:25 Wednesday, November 7, 2018 Previous Month macro variables: p_fmth =02 p_fyr =2019 p_YrMth =201902 p_CmthEnd_ymd=20181031 p_CmthEnd =31OCT2018 p_CmthFrom =01OCT2018 p_CMth =10 p_CYr =2018 p_CQtr =4 (Previous Months Calendar Year Quarter) p_CQtr_yrmth =201810 (Previous Months Quarter Start Year/Month) Next Month macro variables: Next_fmth =04 Next_fyr =2019 Next_YrMth =201904 Next_CMthEnd =31DEC2018 Next_CMthFrom =01DEC2018 Next_CMth =12 Next_CYr =2018 Half Year macro variables: HalfYr_From =01JUN2018 HalfYr_fmth =10 HalfYr_fyr =2018 This Quarter and Previous Quarter macro variables: qtr =1 (Financial Quarter) p_qtr =4 (Previous Financial Quarter - literally, not just for previous month) QtrFrom =01SEP2018 QtrTo =30NOV2018 Date Specified macro variables (set to Date Specified or EOM Date): day_ymd =20181106 yymmdd =181106 cyymm =1811 next_dmy =07112018 day_date9 =06NOV2018 Weekday =3 Yesterday =05NOV2018 Tomorrow =07NOV2018 Ymd =20181106 p_ymd =20181105 Other miscellaneous variables: MonthWord =November DaysInMonth =30 DaysInYear = 365 caldte =November 2018 ReportDate =07NOV2018 Today_ymd =20181107 last_eom_date =31OCT2018 fwk =11 (Financial Week Number) CreateDateMacroVarsErr = 0 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 6 The SAS System 14:25 Wednesday, November 7, 2018 NOTE: Deleting WORK.MACROTST (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 17 18 %LET _CLIENTTASKLABEL=; 19 %LET _EGTASKLABEL=; 20 %LET _CLIENTPROJECTNAME=; 21 %LET _SASPROGRAMFILE=; 22 23 ;*';*";*/;quit;run; 24 ODS _ALL_ CLOSE; 25 26 27 QUIT; RUN; 28
... View more