************************************************************************************** ;
%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
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
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 ?
Thanks, but That doesn’t answer my question.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.