************************************************************************************** ;
%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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.