DATA Step, Macro, Functions and more

Macro value not getting referred

Reply
Contributor
Posts: 54

Macro value not getting referred

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

Super User
Posts: 23,321

Re: Macro value not getting referred

Posted in reply to sayanapex06

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


 

Contributor
Posts: 54

Re: Macro value not getting referred

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 ?

Super User
Posts: 23,321

Re: Macro value not getting referred

Posted in reply to sayanapex06

Thanks, but That doesn’t answer my question. 

Ask a Question
Discussion stats
  • 3 replies
  • 56 views
  • 0 likes
  • 2 in conversation