topic Re: Macro value not getting referred in SAS Programming

Macro value not getting referred

sayanapex06 — Tue, 06 Feb 2018 16:56:04 GMT

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

Re: Macro value not getting referred

Reeza — Tue, 06 Feb 2018 17:07:17 GMT

What’s the type and format of BILLING_YEAR_MONTH

@sayanapex06 wrote:

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

Re: Macro value not getting referred

sayanapex06 — Tue, 06 Feb 2018 17:09:24 GMT

Billing_year_month is a field in a oracle database and we are establishing the conncection to it

it should have values in 'yyyy-mm'

I am getting the yyyy-mm from code

how to get it in Billing_year_month ?

Re: Macro value not getting referred

Reeza — Tue, 06 Feb 2018 17:12:24 GMT

Thanks, but That doesn’t answer my question.