************************************************************************************** ; %LET CURR = TODAY() ; %LET PREMO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -1), YYMMD.); %LET PRPREMO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -2), YYMMD.); %LET CURRMO = %SYSFUNC(TODAY(),YYMMD.) ; ************************************************************************************** ; CREATE TABLE TOTDTL_CURRMO AS (SELECT BILLING_YEAR_MONTH, SERVICE_TYPE, DESCRIPTION10_TO_IBS, BILLING_SERVICE, COMP_CODE, REFUND_MONTH, COST_OF_SERVICE, UNITS, TAX FROM mydblib.t_other_detail_internal WHERE BILLING_YEAR_MONTH = "&CURRMO"); QUIT ; NOTE: Table WORK.TOTDTL_CURRMO created, with 0 rows and 9 columns. &CURRMO is supposed to have 2018-02 but the value isn't getting in BILLING_YEAR_MONTH . Could you please help me with this
... View more