Re: create a previous month field using a current date field.

VALLY · Posted 06-15-2021 04:13 AM

i need to extract data from the previous month (lastday) using the current date (DLA).

however the code is not assigning any values

Kurt_Bremser · Posted 06-15-2021 04:20 AM

Please do NOT post text in pictures, use a code box for code.

Your code assumes that DLA is a character variable, and with that, your code works:

data have;
input dla $8.;
datalines;
20210615
;

data test;
set have;
format lastday date9.;
lastday = intnx('month',input(dla,yymmdd8.),-1,'E');
run;

If DLA is in fact already a SAS date, this will fail. Maxim 2: Read the Log.

So please post the log from your step by copy/pasting the whole text (code and messages) into a box opened with this button:

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

VALLY · Posted 06-15-2021 04:46 AM

I need to create a variable , that will show me today's date and the previous month.

Kurt_Bremser · Posted 06-15-2021 05:37 AM

Post the log as requested.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

VALLY · Posted 06-15-2021 05:46 AM

Kurt_Bremser · Posted 06-15-2021 06:18 AM

Is it really so hard to read my posts?

Quote:

So please post the log from your step by copy/pasting the whole text (code and messages) into a box opened with this button:

The first message points to log line 30, which I need to see to point out where your mistake is; and since there might be other important things, it is always imperative to post the whole log from a step.

And do not skip using a code box for the log, as the positioning of markers within the log is crucial, and the main posting window destroys that. Use the button indicated in the picture (maxi-sized hint: do not respond to posts directly from a mail, go to communities.sas.com in your browser on your computer (not a mobile device) and navigate to the thread there, and use the "Reply" button; the interface from the mail and the mobile interface do not offer all the necessary options.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

VALLY · Posted 06-15-2021 06:28 AM

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 FILENAME EGSR TEMP;
15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16 STYLE=HtmlBlue
17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
18 NOGTITLE
19 NOGFOOTNOTE
20 GPATH=&sasworklocation
21 ENCODING=UTF8
22 options(rolap="on")
23 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26 DATA VIEW;
27 FORMAT LASTMONTH YYMMDD8.;
28 SET BRAC.FINAL_BRACC_ALL (OBS=10);
29 LASTMONTH =
30 INTNX ( 'MONTH', 'today()',INPUT(PUT(DLA,8.),YYMMDD8.),-1, 'E');
31
32 ;
33 RUN;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
30:19
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
30:57
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
LASTMONTH=. AccNrSer=19000 NEW_ACC=19 AccountsForThisBP=1 MultipleSerials= MultipleSerials_ForOpened= MultipleSerials_ForClosed=
AE_NO=0044162 BA_NAME=CANYON SPRINGS INVES BOL=Using BOL BOL_BP=BP using BOL BP_ID=502771114 BPKND=ZRET BPCAT=2 - Enterprize
CashMan=Not using CashMan CashMan_BP=BP Not using CashMan CARR=Not using CARR CARR_BP=BP Not using CARR CDI=Not using CDI
CDI_BP=BP Not using CDI COYY=Not using COYY COYY_BP=BP Not using COYY CENTRE=14255 DATE_CLOSED=9999-01-01 DATE_OPENED=2008-01-10
DLA=20210610 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3 GROUP_NO=0 BOOK_BAL=314397.87 IBTNO=02-05
IDNUMBER=2007/034034/07 ID_TYPE=ZFS003 KYC=Y MISC1=1 MKT_SEG=552 BP_MKT_SEG=552
BP_MKT_SEG_DESC=BUSINESS Business_Area=Business Banking Portfolio=CIB
LEGAL_NAME=CANYON SPRINGS INVESTMENTS 146 (PTY) LTD LEGAL_ENTITY=07 LEGAL_ENTITY_DESC=Private Company
MultipleAccountsPerBP=Only 1 acc for this BP NegotiatedPricingAcc=Acc not using Neg Pricing
NegotiatedPricingBP=BP Not using Neg Pricing NP_Cheque_Serve_Min_Serv_Fee=Not using Cheque Serve Fee and Minimum Service F
NP_Cash_Deposit_Fee=Not using Cash Deposit Fee NP_Monthly_Management_Fee_Ind=Not using Monthly Management Fee
NP_Cheque_Deposit_Encash_Ind=Not using Cheque Deposit and Cheque Encashment NP_Dishonour_Fee_Ind=Not using Dishonour Fee
NP_Automatic_Clear_Facility_Ind=Not using Automatic Clearing Facility NP_Nominated_Fee_Acc_Ind=Not using Nominated Fee Accounts
NP_Overdraft_Service_Fee_Ind=Not using Overdraft Service Fee NP_Initiation_Fee_Ind=Not using Initiation Fee
NP_Unutilised_Facility_Fee_Ind=Not using Unutilised Facility Fee NP_Honour_Fee_Ind=Not using Honour Fee
NP_Statement_Fee_Ind=Not using Statement Enquiry Fee NP_Stop_Payment_Fee_Ind=Not using Stop Payment Fee
TestingAndTrainingBranch=Not a Testing and Training account OpenOrClosed=Open UsingNomination=Not Use Nomination
PRODUCT=LEGACY BUSINESS CURRENT ACCOUNT PRODUCT_CODE=0161 ProdCodeDescr=0161 - LEGACY BUSINESS CURRENT ACCOUNT RB_CODE=84209
2 The SAS System 10:47 Tuesday, June 15, 2021

NEW_SERIAL=0 STATUS=UK STYLE=ORD STYLE_DESC=CURRENT ACCOUNT StyleCodeDescr=ORD - CURRENT ACCOUNT TPFA=Not using TPFA
TPFA_BP=BP Not using TPFA ACCOUNT_TYPE=Cheque Account ACNT_DESCRIPTION=CURRENT ACCOUNTS M_TYPE=0 TypeDesc=Transactional
RSKGP_N=42140 E3_RISK_GROUPS=Managed M_OD_INSURANCE=N PLPP_Description=Closed Account PLPPDescr=N - Closed Account
Suite_Description=BA02 - FRE CSA_OVERDRAFT_LIMIT=0 OD_1ST_RATE=17.7 OD_1ST_LIMIT=0 OD_2ND_RATE=0 OD_2ND_LIMIT=0 OD_3RD_RATE=0
OD_3RD_DECIMALS=0 PLEDGE_IND=Account does not have Pledge LAST_ACTIVE_BUCKET=1 week DATE_LAST_ACTIVE=2021-06-10 MATURITY_DATE=
MATURITY_DATE_YEAR_MONTH= FUNDS_UNDER_NOTICE= AB_EXTERNAL_FUNDING= DATETIME_OPENED=2008/01/10 00:00:00
BP_SYST_IND=BP is only BRACC CAPITAL_DISPOSAL= CAPITAL_DISPOSAL_BP_FLAG= INTEREST_DISPOSAL= INTEREST_DISPOSAL_BP_FLAG=
DISPOSAL_INSTRUCTION= _ERROR_=1 _N_=1
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
LASTMONTH=. AccNrSer=86000 NEW_ACC=86 AccountsForThisBP=1 MultipleSerials= MultipleSerials_ForOpened= MultipleSerials_ForClosed=
AE_NO= BA_NAME=NATIONAL SPRING RETI BOL=Using BOL BOL_BP=BP using BOL BP_ID=451579695 BPKND=ZCIB BPCAT=2 - Enterprize
CashMan=Using CashMan CashMan_BP=BP using CashMan CARR=Not using CARR CARR_BP=BP Not using CARR CDI=Not using CDI
CDI_BP=BP Not using CDI COYY=Not using COYY COYY_BP=BP Not using COYY CENTRE=144 DATE_CLOSED=9999-01-01 DATE_OPENED=1980-01-01
DLA=20210526 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3 GROUP_NO=0 BOOK_BAL=25026474.72 IBTNO=02-05
IDNUMBER= ID_TYPE= KYC=Y MISC1=1 MKT_SEG=704 BP_MKT_SEG=704 BP_MKT_SEG_DESC=CORPORATE PARASTATAL
Business_Area=CIB Portfolio=CIB LEGAL_NAME=NATIONAL SPRING RETIR BEN FUND LEGAL_ENTITY=YO LEGAL_ENTITY_DESC=Other
MultipleAccountsPerBP=Only 1 acc for this BP NegotiatedPricingAcc=Acc using Neg Pricing NegotiatedPricingBP=BP using Neg Pricing
NP_Cheque_Serve_Min_Serv_Fee=Negotiated Pricing - Cheque Serve Fee and Minimum Service F
NP_Cash_Deposit_Fee=Negotiated Pricing - Cash Deposit Fee NP_Monthly_Management_Fee_Ind=Negotiated Pricing - Monthly Management Fee
NP_Cheque_Deposit_Encash_Ind=Negotiated Pricing - Cheque Deposit and Cheque Encashment NP_Dishonour_Fee_Ind=Not using Dishonour Fee
NP_Automatic_Clear_Facility_Ind=Not using Automatic Clearing Facility NP_Nominated_Fee_Acc_Ind=Not using Nominated Fee Accounts
NP_Overdraft_Service_Fee_Ind=Not using Overdraft Service Fee NP_Initiation_Fee_Ind=Not using Initiation Fee
NP_Unutilised_Facility_Fee_Ind=Not using Unutilised Facility Fee NP_Honour_Fee_Ind=Not using Honour Fee
NP_Statement_Fee_Ind=Not using Statement Enquiry Fee NP_Stop_Payment_Fee_Ind=Not using Stop Payment Fee
TestingAndTrainingBranch=Not a Testing and Training account OpenOrClosed=Open UsingNomination=Not Use Nomination
PRODUCT=LEGACY BUSINESS CURRENT ACCOUNT PRODUCT_CODE=0161 ProdCodeDescr=0161 - LEGACY BUSINESS CURRENT ACCOUNT RB_CODE=64231
NEW_SERIAL=0 STATUS=EF STYLE=ORD STYLE_DESC=CURRENT ACCOUNT StyleCodeDescr=ORD - CURRENT ACCOUNT TPFA=Not using TPFA
TPFA_BP=BP Not using TPFA ACCOUNT_TYPE=Cheque Account ACNT_DESCRIPTION=CURRENT ACCOUNTS M_TYPE=0 TypeDesc=Transactional RSKGP_N=.
E3_RISK_GROUPS=Not in a Risk Group M_OD_INSURANCE=N PLPP_Description=Closed Account PLPPDescr=N - Closed Account
Suite_Description=BA02 - FRE CSA_OVERDRAFT_LIMIT=0 OD_1ST_RATE=7 OD_1ST_LIMIT=0 OD_2ND_RATE=0 OD_2ND_LIMIT=0 OD_3RD_RATE=0
OD_3RD_DECIMALS=0 PLEDGE_IND=Account does not have Pledge LAST_ACTIVE_BUCKET=2-3 weeks DATE_LAST_ACTIVE=2021-05-26 MATURITY_DATE=
MATURITY_DATE_YEAR_MONTH= FUNDS_UNDER_NOTICE= AB_EXTERNAL_FUNDING= DATETIME_OPENED=1980/01/01 00:00:00
BP_SYST_IND=BP is only BRACC CAPITAL_DISPOSAL= CAPITAL_DISPOSAL_BP_FLAG= INTEREST_DISPOSAL= INTEREST_DISPOSAL_BP_FLAG=
DISPOSAL_INSTRUCTION= _ERROR_=1 _N_=2
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
LASTMONTH=. AccNrSer=116000 NEW_ACC=116 AccountsForThisBP=1 MultipleSerials= MultipleSerials_ForOpened=
MultipleSerials_ForClosed= AE_NO=0044108 BA_NAME=NO 39 SPRINGWOOD CLO BOL=Not using BOL BOL_BP=BP Not using BOL BP_ID=531295479
BPKND=ZRET BPCAT=2 - Enterprize CashMan=Not using CashMan CashMan_BP=BP Not using CashMan CARR=Not using CARR
CARR_BP=BP Not using CARR CDI=Not using CDI CDI_BP=BP Not using CDI COYY=Not using COYY COYY_BP=BP Not using COYY CENTRE=16286
DATE_CLOSED=9999-01-01 DATE_OPENED=2016-02-22 DLA=20210601 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3
GROUP_NO=0 BOOK_BAL=16775.72 IBTNO=02-05 IDNUMBER=1998/071282/23 ID_TYPE=ZFS003 KYC=Y MISC1=0 MKT_SEG=552 BP_MKT_SEG=552
BP_MKT_SEG_DESC=BUSINESS Business_Area=Business Banking Portfolio=CIB
LEGAL_NAME=NO 39 SPRINGWOOD CLOSE CORPORATION LEGAL_ENTITY=01 LEGAL_ENTITY_DESC=CC (Close Corporation)
MultipleAccountsPerBP=Only 1 acc for this BP NegotiatedPricingAcc=Acc not using Neg Pricing
NegotiatedPricingBP=BP Not using Neg Pricing NP_Cheque_Serve_Min_Serv_Fee=Not using Cheque Serve Fee and Minimum Service F
NP_Cash_Deposit_Fee=Not using Cash Deposit Fee NP_Monthly_Management_Fee_Ind=Not using Monthly Management Fee
NP_Cheque_Deposit_Encash_Ind=Not using Cheque Deposit and Cheque Encashment NP_Dishonour_Fee_Ind=Not using Dishonour Fee
NP_Automatic_Clear_Facility_Ind=Not using Automatic Clearing Facility NP_Nominated_Fee_Acc_Ind=Not using Nominated Fee Accounts
NP_Overdraft_Service_Fee_Ind=Not using Overdraft Service Fee NP_Initiation_Fee_Ind=Not using Initiation Fee
NP_Unutilised_Facility_Fee_Ind=Not using Unutilised Facility Fee NP_Honour_Fee_Ind=Not using Honour Fee
NP_Statement_Fee_Ind=Not using Statement Enquiry Fee NP_Stop_Payment_Fee_Ind=Not using Stop Payment Fee
TestingAndTrainingBranch=Not a Testing and Training account OpenOrClosed=Open UsingNomination=Not Use Nomination
PRODUCT=LEGACY BUSINESS CURRENT ACCOUNT PRODUCT_CODE=0161 ProdCodeDescr=0161 - LEGACY BUSINESS CURRENT ACCOUNT RB_CODE=84209
NEW_SERIAL=0 STATUS=UK STYLE=ORD STYLE_DESC=CURRENT ACCOUNT StyleCodeDescr=ORD - CURRENT ACCOUNT TPFA=Not using TPFA
TPFA_BP=BP Not using TPFA ACCOUNT_TYPE=Cheque Account ACNT_DESCRIPTION=CURRENT ACCOUNTS M_TYPE=0 TypeDesc=Transactional
RSKGP_N=29753 E3_RISK_GROUPS=Managed M_OD_INSURANCE=N PLPP_Description=Closed Account PLPPDescr=N - Closed Account
Suite_Description=BA02 - FRE CSA_OVERDRAFT_LIMIT=0 OD_1ST_RATE=17.7 OD_1ST_LIMIT=0 OD_2ND_RATE=0 OD_2ND_LIMIT=0 OD_3RD_RATE=0
OD_3RD_DECIMALS=0 PLEDGE_IND=Account does not have Pledge LAST_ACTIVE_BUCKET=1-2 weeks DATE_LAST_ACTIVE=2021-06-01 MATURITY_DATE=
3 The SAS System 10:47 Tuesday, June 15, 2021

MATURITY_DATE_YEAR_MONTH= FUNDS_UNDER_NOTICE= AB_EXTERNAL_FUNDING= DATETIME_OPENED=2016/02/22 00:00:00
BP_SYST_IND=BP is only BRACC CAPITAL_DISPOSAL= CAPITAL_DISPOSAL_BP_FLAG= INTEREST_DISPOSAL= INTEREST_DISPOSAL_BP_FLAG=
DISPOSAL_INSTRUCTION= _ERROR_=1 _N_=3
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
LASTMONTH=. AccNrSer=124000 NEW_ACC=124 AccountsForThisBP=1 MultipleSerials= MultipleSerials_ForOpened=
MultipleSerials_ForClosed= AE_NO=0073M66 BA_NAME=THE VALKEN FAMILY TR BOL=Not using BOL BOL_BP=BP Not using BOL BP_ID=24191849
BPKND=ZRET BPCAT=2 - Enterprize CashMan=Not using CashMan CashMan_BP=BP Not using CashMan CARR=Not using CARR
CARR_BP=BP Not using CARR CDI=Not using CDI CDI_BP=BP Not using CDI COYY=Not using COYY COYY_BP=BP Not using COYY CENTRE=19119
DATE_CLOSED=9999-01-01 DATE_OPENED=1974-09-14 DLA=20210108 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3
GROUP_NO=0 BOOK_BAL=48613.45 IBTNO=02-05 IDNUMBER=IT1301/86 ID_TYPE=ZFS003 KYC=Y MISC1=1 MKT_SEG=400 BP_MKT_SEG=400
BP_MKT_SEG_DESC=LIFESTYLE Business_Area=Small enterprise Portfolio=CIB
LEGAL_NAME=THE VALKEN FAMILY TRUST LEGAL_ENTITY=ZO LEGAL_ENTITY_DESC=Living Inter Vivos Trust
MultipleAccountsPerBP=Only 1 acc for this BP NegotiatedPricingAcc=Acc not using Neg Pricing
NegotiatedPricingBP=BP Not using Neg Pricing NP_Cheque_Serve_Min_Serv_Fee=Not using Cheque Serve Fee and Minimum Service F
NP_Cash_Deposit_Fee=Not using Cash Deposit Fee NP_Monthly_Management_Fee_Ind=Not using Monthly Management Fee
NP_Cheque_Deposit_Encash_Ind=Not using Cheque Deposit and Cheque Encashment NP_Dishonour_Fee_Ind=Not using Dishonour Fee
NP_Automatic_Clear_Facility_Ind=Not using Automatic Clearing Facility NP_Nominated_Fee_Acc_Ind=Not using Nominated Fee Accounts
NP_Overdraft_Service_Fee_Ind=Not using Overdraft Service Fee NP_Initiation_Fee_Ind=Not using Initiation Fee
NP_Unutilised_Facility_Fee_Ind=Not using Unutilised Facility Fee NP_Honour_Fee_Ind=Not using Honour Fee
NP_Statement_Fee_Ind=Not using Statement Enquiry Fee NP_Stop_Payment_Fee_Ind=Not using Stop Payment Fee
TestingAndTrainingBranch=Not a Testing and Training account OpenOrClosed=Open UsingNomination=Not Use Nomination
PRODUCT=LEGACY BUSINESS CURRENT ACCOUNT PRODUCT_CODE=0161 ProdCodeDescr=0161 - LEGACY BUSINESS CURRENT ACCOUNT RB_CODE=74323
NEW_SERIAL=0 STATUS=U STYLE=ORD STYLE_DESC=CURRENT ACCOUNT StyleCodeDescr=ORD - CURRENT ACCOUNT TPFA=Not using TPFA
TPFA_BP=BP Not using TPFA ACCOUNT_TYPE=Cheque Account ACNT_DESCRIPTION=CURRENT ACCOUNTS M_TYPE=0 TypeDesc=Transactional RSKGP_N=.
E3_RISK_GROUPS=Not in a Risk Group M_OD_INSURANCE=N PLPP_Description=Closed Account PLPPDescr=N - Closed Account
Suite_Description=BA02 - FRE CSA_OVERDRAFT_LIMIT=0 OD_1ST_RATE=15 OD_1ST_LIMIT=0 OD_2ND_RATE=0 OD_2ND_LIMIT=0 OD_3RD_RATE=0
OD_3RD_DECIMALS=0 PLEDGE_IND=Account does not have Pledge LAST_ACTIVE_BUCKET=Greater than 12 weeks DATE_LAST_ACTIVE=2021-01-08
MATURITY_DATE= MATURITY_DATE_YEAR_MONTH= FUNDS_UNDER_NOTICE= AB_EXTERNAL_FUNDING= DATETIME_OPENED=1974/09/14 00:00:00
BP_SYST_IND=BP is only BRACC CAPITAL_DISPOSAL= CAPITAL_DISPOSAL_BP_FLAG= INTEREST_DISPOSAL= INTEREST_DISPOSAL_BP_FLAG=
DISPOSAL_INSTRUCTION= _ERROR_=1 _N_=4
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
LASTMONTH=. AccNrSer=132000 NEW_ACC=132 AccountsForThisBP=1 MultipleSerials= MultipleSerials_ForOpened=
MultipleSerials_ForClosed= AE_NO= BA_NAME=ELECTRO SERVICE RB S BOL=Not using BOL BOL_BP=BP Not using BOL BP_ID=531268671
BPKND=ZRET BPCAT=2 - Enterprize CashMan=Not using CashMan CashMan_BP=BP Not using CashMan CARR=Not using CARR
CARR_BP=BP Not using CARR CDI=Not using CDI CDI_BP=BP Not using CDI COYY=Not using COYY COYY_BP=BP Not using COYY CENTRE=13788
DATE_CLOSED=9999-01-01 DATE_OPENED=2016-02-19 DLA=20210609 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3
GROUP_NO=0 BOOK_BAL=2258.79 IBTNO=02-05 IDNUMBER=J40/27177 ID_TYPE=ZFS003 KYC=Y MISC1=1 MKT_SEG=400 BP_MKT_SEG=400
BP_MKT_SEG_DESC=LIFESTYLE Business_Area=Small enterprise Portfolio=CIB
LEGAL_NAME=ELECTRO SERVICE RB SRL LEGAL_ENTITY=YO LEGAL_ENTITY_DESC=Other MultipleAccountsPerBP=Only 1 acc for this BP
NegotiatedPricingAcc=Acc not using Neg Pricing NegotiatedPricingBP=BP Not using Neg Pricing
NP_Cheque_Serve_Min_Serv_Fee=Not using Cheque Serve Fee and Minimum Service F NP_Cash_Deposit_Fee=Not using Cash Deposit Fee
NP_Monthly_Management_Fee_Ind=Not using Monthly Management Fee
NP_Cheque_Deposit_Encash_Ind=Not using Cheque Deposit and Cheque Encashment NP_Dishonour_Fee_Ind=Not using Dishonour Fee
NP_Automatic_Clear_Facility_Ind=Not using Automatic Clearing Facility NP_Nominated_Fee_Acc_Ind=Not using Nominated Fee Accounts
NP_Overdraft_Service_Fee_Ind=Not using Overdraft Service Fee NP_Initiation_Fee_Ind=Not using Initiation Fee
NP_Unutilised_Facility_Fee_Ind=Not using Unutilised Facility Fee NP_Honour_Fee_Ind=Not using Honour Fee
NP_Statement_Fee_Ind=Not using Statement Enquiry Fee NP_Stop_Payment_Fee_Ind=Not using Stop Payment Fee
TestingAndTrainingBranch=Not a Testing and Training account OpenOrClosed=Open UsingNomination=Not Use Nomination
PRODUCT=LEGACY BUSINESS CURRENT ACCOUNT PRODUCT_CODE=0161 ProdCodeDescr=0161 - LEGACY BUSINESS CURRENT ACCOUNT RB_CODE=929
NEW_SERIAL=0 STATUS=UN STYLE=ORD STYLE_DESC=CURRENT ACCOUNT StyleCodeDescr=ORD - CURRENT ACCOUNT TPFA=Not using TPFA
TPFA_BP=BP Not using TPFA ACCOUNT_TYPE=Cheque Account ACNT_DESCRIPTION=CURRENT ACCOUNTS M_TYPE=0 TypeDesc=Transactional RSKGP_N=.
E3_RISK_GROUPS=Not in a Risk Group M_OD_INSURANCE=N PLPP_Description=Closed Account PLPPDescr=N - Closed Account
Suite_Description=BA02 - FRE CSA_OVERDRAFT_LIMIT=0 OD_1ST_RATE=17.7 OD_1ST_LIMIT=0 OD_2ND_RATE=0 OD_2ND_LIMIT=0 OD_3RD_RATE=0
OD_3RD_DECIMALS=0 PLEDGE_IND=Account does not have Pledge LAST_ACTIVE_BUCKET=1 week DATE_LAST_ACTIVE=2021-06-09 MATURITY_DATE=
MATURITY_DATE_YEAR_MONTH= FUNDS_UNDER_NOTICE= AB_EXTERNAL_FUNDING= DATETIME_OPENED=2016/02/19 00:00:00
BP_SYST_IND=BP is only BRACC CAPITAL_DISPOSAL= CAPITAL_DISPOSAL_BP_FLAG= INTEREST_DISPOSAL= INTEREST_DISPOSAL_BP_FLAG=
DISPOSAL_INSTRUCTION= _ERROR_=1 _N_=5
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
4 The SAS System 10:47 Tuesday, June 15, 2021

LASTMONTH=. AccNrSer=140000 NEW_ACC=140 AccountsForThisBP=1 MultipleSerials= MultipleSerials_ForOpened=
MultipleSerials_ForClosed= AE_NO=0072C39 BA_NAME=DITSHEGO AR BOL=Not using BOL BOL_BP=BP Not using BOL BP_ID=452360497 BPKND=ZRET
BPCAT=1 - Individual CashMan=Not using CashMan CashMan_BP=BP Not using CashMan CARR=Not using CARR CARR_BP=BP Not using CARR
CDI=Not using CDI CDI_BP=BP Not using CDI COYY=Not using COYY COYY_BP=BP Not using COYY CENTRE=13435 DATE_CLOSED=9999-01-01
DATE_OPENED=2016-02-19 DLA=20210524 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3 GROUP_NO=0
BOOK_BAL=-120623.5 IBTNO=02-05 IDNUMBER=7304205618084 ID_TYPE=ZFS001 KYC=Y MISC1=1 MKT_SEG=136 BP_MKT_SEG=136
BP_MKT_SEG_DESC=PRESTIGE BANKING Business_Area=Personal Portfolio=Prestige LEGAL_NAME= LEGAL_ENTITY=
LEGAL_ENTITY_DESC= MultipleAccountsPerBP=Only 1 acc for this BP NegotiatedPricingAcc=Acc not using Neg Pricing
NegotiatedPricingBP=BP Not using Neg Pricing NP_Cheque_Serve_Min_Serv_Fee=Not using Cheque Serve Fee and Minimum Service F
NP_Cash_Deposit_Fee=Not using Cash Deposit Fee NP_Monthly_Management_Fee_Ind=Not using Monthly Management Fee
NP_Cheque_Deposit_Encash_Ind=Not using Cheque Deposit and Cheque Encashment NP_Dishonour_Fee_Ind=Not using Dishonour Fee
NP_Automatic_Clear_Facility_Ind=Not using Automatic Clearing Facility NP_Nominated_Fee_Acc_Ind=Not using Nominated Fee Accounts
NP_Overdraft_Service_Fee_Ind=Not using Overdraft Service Fee NP_Initiation_Fee_Ind=Not using Initiation Fee
NP_Unutilised_Facility_Fee_Ind=Not using Unutilised Facility Fee NP_Honour_Fee_Ind=Not using Honour Fee
NP_Statement_Fee_Ind=Not using Statement Enquiry Fee NP_Stop_Payment_Fee_Ind=Not using Stop Payment Fee
TestingAndTrainingBranch=Not a Testing and Training account OpenOrClosed=Open UsingNomination=Not Use Nomination
PRODUCT=REVOLVING CREDIT PLAN LOAN PRODUCT_CODE=0008 ProdCodeDescr=0008 - REVOLVING CREDIT PLAN LOAN RB_CODE=110 NEW_SERIAL=0
STATUS=SUK STYLE=RCA STYLE_DESC=REVOLVING CREDIT PLAN StyleCodeDescr=RCA - REVOLVING CREDIT PLAN TPFA=Not using TPFA
TPFA_BP=BP Not using TPFA ACCOUNT_TYPE=Lending ACNT_DESCRIPTION=CURRENT ACCOUNTS M_TYPE=0 TypeDesc=Lending RSKGP_N=.
E3_RISK_GROUPS=Not in a Risk Group M_OD_INSURANCE=D PLPP_Description=Death,Disability,Dread Disease and Retrenchment
PLPPDescr=D - Death,Disability,Dread Disease and Retrenchment Suite_Description=BA02 - FRE CSA_OVERDRAFT_LIMIT=-130000
OD_1ST_RATE=12.77 OD_1ST_LIMIT=0 OD_2ND_RATE=0 OD_2ND_LIMIT=0 OD_3RD_RATE=0 OD_3RD_DECIMALS=0
PLEDGE_IND=Account does not have Pledge LAST_ACTIVE_BUCKET=3-4 weeks DATE_LAST_ACTIVE=2021-05-24 MATURITY_DATE=
MATURITY_DATE_YEAR_MONTH= FUNDS_UNDER_NOTICE= AB_EXTERNAL_FUNDING= DATETIME_OPENED=2016/02/19 00:00:00
BP_SYST_IND=BP has both SAP and BRACC CAPITAL_DISPOSAL= CAPITAL_DISPOSAL_BP_FLAG= INTEREST_DISPOSAL= INTEREST_DISPOSAL_BP_FLAG=
DISPOSAL_INSTRUCTION= _ERROR_=1 _N_=6
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
LASTMONTH=. AccNrSer=159000 NEW_ACC=159 AccountsForThisBP=3 MultipleSerials= MultipleSerials_ForOpened=
MultipleSerials_ForClosed= AE_NO=0046320 BA_NAME=SIBEKO GS BOL=Using BOL BOL_BP=BP using BOL BP_ID=450756066 BPKND=ZRET
BPCAT=1 - Individual CashMan=Not using CashMan CashMan_BP=BP Not using CashMan CARR=Not using CARR CARR_BP=BP Not using CARR
CDI=Not using CDI CDI_BP=BP Not using CDI COYY=Not using COYY COYY_BP=BP Not using COYY CENTRE=13440 DATE_CLOSED=9999-01-01
DATE_OPENED=2002-03-13 DLA=20210603 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3 GROUP_NO=0
BOOK_BAL=-126548.1 IBTNO=02-05 IDNUMBER=7907065310087 ID_TYPE=ZFS001 KYC=Y MISC1=1 MKT_SEG=140 BP_MKT_SEG=140
BP_MKT_SEG_DESC=PRIVATE BANKING Business_Area=Personal Portfolio=Private Banking LEGAL_NAME=
LEGAL_ENTITY= LEGAL_ENTITY_DESC= MultipleAccountsPerBP=Multiple Accs for this BP NegotiatedPricingAcc=Acc not using Neg Pricing
NegotiatedPricingBP=BP Not using Neg Pricing NP_Cheque_Serve_Min_Serv_Fee=Not using Cheque Serve Fee and Minimum Service F
NP_Cash_Deposit_Fee=Not using Cash Deposit Fee NP_Monthly_Management_Fee_Ind=Not using Monthly Management Fee
NP_Cheque_Deposit_Encash_Ind=Not using Cheque Deposit and Cheque Encashment NP_Dishonour_Fee_Ind=Not using Dishonour Fee
NP_Automatic_Clear_Facility_Ind=Not using Automatic Clearing Facility NP_Nominated_Fee_Acc_Ind=Not using Nominated Fee Accounts
NP_Overdraft_Service_Fee_Ind=Not using Overdraft Service Fee NP_Initiation_Fee_Ind=Not using Initiation Fee
NP_Unutilised_Facility_Fee_Ind=Not using Unutilised Facility Fee NP_Honour_Fee_Ind=Not using Honour Fee
NP_Statement_Fee_Ind=Not using Statement Enquiry Fee NP_Stop_Payment_Fee_Ind=Not using Stop Payment Fee
TestingAndTrainingBranch=Not a Testing and Training account OpenOrClosed=Open UsingNomination=Not Use Nomination
PRODUCT=PRIVATE BANKING PLUS CURRENT ACCOUNT PRODUCT_CODE=0644 ProdCodeDescr=0644 - PRIVATE BANKING PLUS CURRENT ACCOUNT RB_CODE=110
NEW_SERIAL=0 STATUS=UK STYLE=GLP STYLE_DESC=PRIVATE BANKING CURRENT ACCOUNT StyleCodeDescr=GLP - PRIVATE BANKING CURRENT ACCOUNT
TPFA=Not using TPFA TPFA_BP=BP Not using TPFA ACCOUNT_TYPE=Cheque Account ACNT_DESCRIPTION=CURRENT ACCOUNTS M_TYPE=0
TypeDesc=Transactional RSKGP_N=. E3_RISK_GROUPS=Not in a Risk Group M_OD_INSURANCE=A
PLPP_Description=Death,Disability,Dread Disease and Retrenchment PLPPDescr=A - Death,Disability,Dread Disease and Retrenchment
Suite_Description=BA02 - FRE CSA_OVERDRAFT_LIMIT=-126600 OD_1ST_RATE=8.5 OD_1ST_LIMIT=0 OD_2ND_RATE=0 OD_2ND_LIMIT=0 OD_3RD_RATE=0
OD_3RD_DECIMALS=0 PLEDGE_IND=Account does not have Pledge LAST_ACTIVE_BUCKET=1-2 weeks DATE_LAST_ACTIVE=2021-06-03 MATURITY_DATE=
MATURITY_DATE_YEAR_MONTH= FUNDS_UNDER_NOTICE= AB_EXTERNAL_FUNDING= DATETIME_OPENED=2002/03/13 00:00:00
BP_SYST_IND=BP has both SAP and BRACC CAPITAL_DISPOSAL= CAPITAL_DISPOSAL_BP_FLAG= INTEREST_DISPOSAL= INTEREST_DISPOSAL_BP_FLAG=
DISPOSAL_INSTRUCTION= _ERROR_=1 _N_=7
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
LASTMONTH=. AccNrSer=175000 NEW_ACC=175 AccountsForThisBP=2 MultipleSerials= MultipleSerials_ForOpened=
MultipleSerials_ForClosed= AE_NO=0046CW8 BA_NAME=WAJA J BOL=Not using BOL BOL_BP=BP Not using BOL BP_ID=451566318 BPKND=ZRET
BPCAT=1 - Individual CashMan=Not using CashMan CashMan_BP=BP Not using CashMan CARR=Not using CARR CARR_BP=BP Not using CARR
CDI=Not using CDI CDI_BP=BP Not using CDI COYY=Not using COYY COYY_BP=BP Not using COYY CENTRE=10878 DATE_CLOSED=9999-01-01
5 The SAS System 10:47 Tuesday, June 15, 2021

DATE_OPENED=1996-07-22 DLA=20210526 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3 GROUP_NO=205780
BOOK_BAL=-60968.83 IBTNO=02-05 IDNUMBER=6410170030089 ID_TYPE=ZFS001 KYC=Y MISC1=1 MKT_SEG=988 BP_MKT_SEG=988
BP_MKT_SEG_DESC=STAFF ACCOUNTS                               Business_Area=Staff Portfolio=Staff LEGAL_NAME= LEGAL_ENTITY=
LEGAL_ENTITY_DESC= MultipleAccountsPerBP=Multiple Accs for this BP NegotiatedPricingAcc=Acc not using Neg Pricing
NegotiatedPricingBP=BP Not using Neg Pricing NP_Cheque_Serve_Min_Serv_Fee=Not using Cheque Serve Fee and Minimum Service F
NP_Cash_Deposit_Fee=Not using Cash Deposit Fee NP_Monthly_Management_Fee_Ind=Not using Monthly Management Fee
NP_Cheque_Deposit_Encash_Ind=Not using Cheque Deposit and Cheque Encashment NP_Dishonour_Fee_Ind=Not using Dishonour Fee
NP_Automatic_Clear_Facility_Ind=Not using Automatic Clearing Facility NP_Nominated_Fee_Acc_Ind=Not using Nominated Fee Accounts
NP_Overdraft_Service_Fee_Ind=Not using Overdraft Service Fee NP_Initiation_Fee_Ind=Not using Initiation Fee
NP_Unutilised_Facility_Fee_Ind=Not using Unutilised Facility Fee NP_Honour_Fee_Ind=Not using Honour Fee
NP_Statement_Fee_Ind=Not using Statement Enquiry Fee NP_Stop_Payment_Fee_Ind=Not using Stop Payment Fee
TestingAndTrainingBranch=Not a Testing and Training account OpenOrClosed=Open UsingNomination=Not Use Nomination
PRODUCT=STAFF REVOLVING CREDIT (RCC) PLAN LOAN PRODUCT_CODE=0235 ProdCodeDescr=0235 - STAFF REVOLVING CREDIT (RCC) PLAN LOAN
RB_CODE=110 NEW_SERIAL=0 STATUS=SUVK STYLE=RCC STYLE_DESC=STAFF REVOLVING CREDIT PLAN
StyleCodeDescr=RCC - STAFF REVOLVING CREDIT PLAN TPFA=Not using TPFA TPFA_BP=BP Not using TPFA ACCOUNT_TYPE=Lending
ACNT_DESCRIPTION=CURRENT ACCOUNTS M_TYPE=0 TypeDesc=Lending RSKGP_N=. E3_RISK_GROUPS=Not in a Risk Group M_OD_INSURANCE=A
PLPP_Description=Death,Disability,Dread Disease and Retrenchment PLPPDescr=A - Death,Disability,Dread Disease and Retrenchment
Suite_Description=BA02 - FRE CSA_OVERDRAFT_LIMIT=-87500 OD_1ST_RATE=4.5 OD_1ST_LIMIT=0 OD_2ND_RATE=0 OD_2ND_LIMIT=0 OD_3RD_RATE=0
OD_3RD_DECIMALS=0 PLEDGE_IND=Account does not have Pledge LAST_ACTIVE_BUCKET=2-3 weeks DATE_LAST_ACTIVE=2021-05-26 MATURITY_DATE=
MATURITY_DATE_YEAR_MONTH= FUNDS_UNDER_NOTICE= AB_EXTERNAL_FUNDING= DATETIME_OPENED=1996/07/22 00:00:00
BP_SYST_IND=BP has both SAP and BRACC CAPITAL_DISPOSAL= CAPITAL_DISPOSAL_BP_FLAG= INTEREST_DISPOSAL= INTEREST_DISPOSAL_BP_FLAG=
DISPOSAL_INSTRUCTION= _ERROR_=1 _N_=8
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
LASTMONTH=. AccNrSer=256000 NEW_ACC=256 AccountsForThisBP=1 MultipleSerials= MultipleSerials_ForOpened=
MultipleSerials_ForClosed= AE_NO= BA_NAME=AF COLL S4 (5) A28 C BOL=Using BOL BOL_BP=BP using BOL BP_ID=31207508 BPKND=ZCIB
BPCAT=2 - Enterprize CashMan=Using CashMan CashMan_BP=BP using CashMan CARR=Not using CARR CARR_BP=BP Not using CARR
CDI=Not using CDI CDI_BP=BP Not using CDI COYY=Using COYY COYY_BP=BP using COYY CENTRE=144 DATE_CLOSED=9999-01-01
DATE_OPENED=1996-05-23 DLA=20210614 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3 GROUP_NO=0
BOOK_BAL=4670770.96 IBTNO=02-05 IDNUMBER= ID_TYPE= KYC=Y MISC1=1 MKT_SEG=704 BP_MKT_SEG=704
BP_MKT_SEG_DESC=CORPORATE PARASTATAL                         Business_Area=CIB Portfolio=CIB
LEGAL_NAME=ALEX FORBES IMPREST COLL ACC 2 LEGAL_ENTITY=YO LEGAL_ENTITY_DESC=Other MultipleAccountsPerBP=Only 1 acc for this BP
NegotiatedPricingAcc=Acc using Neg Pricing NegotiatedPricingBP=BP using Neg Pricing
NP_Cheque_Serve_Min_Serv_Fee=Negotiated Pricing - Cheque Serve Fee and Minimum Service F
NP_Cash_Deposit_Fee=Negotiated Pricing - Cash Deposit Fee NP_Monthly_Management_Fee_Ind=Negotiated Pricing - Monthly Management Fee
NP_Cheque_Deposit_Encash_Ind=Negotiated Pricing - Cheque Deposit and Cheque Encashment NP_Dishonour_Fee_Ind=Not using Dishonour Fee
NP_Automatic_Clear_Facility_Ind=Not using Automatic Clearing Facility NP_Nominated_Fee_Acc_Ind=Not using Nominated Fee Accounts
NP_Overdraft_Service_Fee_Ind=Not using Overdraft Service Fee NP_Initiation_Fee_Ind=Not using Initiation Fee
NP_Unutilised_Facility_Fee_Ind=Not using Unutilised Facility Fee NP_Honour_Fee_Ind=Not using Honour Fee
NP_Statement_Fee_Ind=Not using Statement Enquiry Fee NP_Stop_Payment_Fee_Ind=Not using Stop Payment Fee
TestingAndTrainingBranch=Not a Testing and Training account OpenOrClosed=Open UsingNomination=Not Use Nomination
PRODUCT=LEGACY BUSINESS CURRENT ACCOUNT PRODUCT_CODE=0161 ProdCodeDescr=0161 - LEGACY BUSINESS CURRENT ACCOUNT RB_CODE=64231
NEW_SERIAL=0 STATUS=E STYLE=ORD STYLE_DESC=CURRENT ACCOUNT StyleCodeDescr=ORD - CURRENT ACCOUNT TPFA=Not using TPFA
TPFA_BP=BP Not using TPFA ACCOUNT_TYPE=Cheque Account ACNT_DESCRIPTION=CURRENT ACCOUNTS M_TYPE=0 TypeDesc=Transactional RSKGP_N=.
E3_RISK_GROUPS=Not in a Risk Group M_OD_INSURANCE=N PLPP_Description=Closed Account PLPPDescr=N - Closed Account
Suite_Description=BA02 - FRE CSA_OVERDRAFT_LIMIT=0 OD_1ST_RATE=7 OD_1ST_LIMIT=0 OD_2ND_RATE=0 OD_2ND_LIMIT=0 OD_3RD_RATE=0
OD_3RD_DECIMALS=0 PLEDGE_IND=Account does not have Pledge LAST_ACTIVE_BUCKET=1 week DATE_LAST_ACTIVE=2021-06-14 MATURITY_DATE=
MATURITY_DATE_YEAR_MONTH= FUNDS_UNDER_NOTICE= AB_EXTERNAL_FUNDING= DATETIME_OPENED=1996/05/23 00:00:00
BP_SYST_IND=BP is only BRACC CAPITAL_DISPOSAL= CAPITAL_DISPOSAL_BP_FLAG= INTEREST_DISPOSAL= INTEREST_DISPOSAL_BP_FLAG=
DISPOSAL_INSTRUCTION= _ERROR_=1 _N_=9
NOTE: Invalid numeric data, 'today()' , at line 30 column 19.
LASTMONTH=. AccNrSer=259000 NEW_ACC=259 AccountsForThisBP=2 MultipleSerials= MultipleSerials_ForOpened=
MultipleSerials_ForClosed= AE_NO= BA_NAME=SU BEE Funding SPV BOL=Not using BOL BOL_BP=BP Not using BOL BP_ID=535337179 BPKND=ZCIB
BPCAT=2 - Enterprize CashMan=Not using CashMan CashMan_BP=BP using CashMan CARR=Not using CARR CARR_BP=BP Not using CARR
CDI=Not using CDI CDI_BP=BP Not using CDI COYY=Not using COYY COYY_BP=BP Not using COYY CENTRE=144 DATE_CLOSED=2019-02-22
DATE_OPENED=2018-12-06 DLA=20190222 DORM= DORM_DESC= DormCodeDescr= E3=Not using E3 E3_BP=BP Not using E3 GROUP_NO=0 BOOK_BAL=0
IBTNO=02-05 IDNUMBER=2018/550917/07 ID_TYPE=ZFS003 KYC=Y MISC1=9 MKT_SEG=701 BP_MKT_SEG=701
BP_MKT_SEG_DESC=SMALL CORPORATE                              Business_Area=CIB Portfolio=CIB
LEGAL_NAME=SU BEE Funding SPV (RF) (Pty) Ltd. LEGAL_ENTITY=07 LEGAL_ENTITY_DESC=Private Company
6 The SAS System 10:47 Tuesday, June 15, 2021

34
35 GOPTIONS NOACCESSIBLE;
36 %LET _CLIENTTASKLABEL=;
37 %LET _CLIENTPROCESSFLOWNAME=;
38 %LET _CLIENTPROJECTPATH=;
39 %LET _CLIENTPROJECTPATHHOST=;
40 %LET _CLIENTPROJECTNAME=;
7 The SAS System 10:47 Tuesday, June 15, 2021

41 %LET _SASPROGRAMFILE=;
42 %LET _SASPROGRAMFILEHOST=;
43
44 ;*';*";*/;quit;run;
45 ODS _ALL_ CLOSE;
46
47
48 QUIT; RUN;
49

Kurt_Bremser · Posted 06-15-2021 06:54 AM

So everything happens here:

30 INTNX ( 'MONTH', 'today()',INPUT(PUT(DLA,8.),YYMMDD8.),-1, 'E');

Note how the code box (which I expressly URGED you to use!) makes the code more readable because of the non-proportional font.

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
30:19

tells you that, since the INTNX function expects a number as its second argument, the string(!) 'today()' needs to be converted to a number.

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
30:57

tells you that the -1 (which you supplied as the fourth argument to INTNX) needs to be converted to character, as that is what INTNX expects as its fourth argument.

Both of these happen during the data step compilation phase.

NOTE: Invalid numeric data, 'today()' , at line 30 column 19.

is a consequence of the first NOTE and happens during the execution phase.

The listing for DLA:

DLA=20210610

lets me suspect that yo really have a "date" value stored in the stupid way that forces you to do a conversion on the fly. Next maxi-size hint: NEVER (as in NEVER) store dates in this way. Always do such a conversion as soon as you import data into SAS as part of the cleaning during ETL.

But since you have such data at the moment, let's keep the conversion in there. To correctly use the INTNX function, you need only four arguments (see documentation - Maxim 1! - here😞

lastmonth = intnx('month',input(put(DLA,8.),yymmdd8.),-1,'E');

The arguments are:

interval (character)
start value (numeric)
number of intervals (numeric)
alignment (character)

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

mkeintz · Posted 06-15-2021 02:59 PM

While I subscribe to the opinion that learners (of any subject) have to ultimately judge what are the most important aspects of a subject for them to master, I think that starting out by paying attention to advice given in response to the learner's question should not be discarded immediately.

So when @Kurt_Bremser suggests

posting the log (including the code as well as the notes/warnings)
using the </> icon

it is meant to help us help you.

It might be the best skill one learns on this forum. It was for me.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

VALLY · Posted 06-15-2021 05:37 AM

good day expects.

am trying to create a variable with include today's date and the previous 2 months using the below code:

DATA TEST;

FORMAT LASTMONTH YYMMDD8.;
SET BRAC.FINAL_BRACC_ALL (OBS=10);
LASTMONTH =
INTNX ( 'MONTH', 'TODAY()',INPUT(PUT(DLA,8.),YYMMDD8.),-1, 'E');
;
RUN;

However am getting the below results.

Kurt_Bremser · Posted 06-15-2021 05:38 AM

POST.

THE.

LOG.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Kurt_Bremser · Posted 06-15-2021 05:40 AM

Please do not post the same question in multiple messages. I had to merge them.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Astounding · Posted 06-15-2021 07:34 AM

Unless there is some enhancement to the software that I don't know about, nothing in your code suggests subsetting observations. You would need an IF statement to do that. So try:

if INTNX ( 'MONTH', today(),-1, 'B') <= input(put(dla,8.), yymmdd8.) <= INTNX('MONTH', today(), -1, 'E');

The middle part of the expression (the INPUT function) is a guess that depends on what is really contained in the variable DLA. It seems to be a character string that needs to be converted to an actual SAS date.

VALLY · Posted 06-15-2021 12:10 PM

Can this be done using a proc sql statement.

Kurt_Bremser · Posted 06-15-2021 02:36 PM

@VALLY wrote:

Can this be done using a proc sql statement.

In SQL, you create a new variable with

<calculation> as <name> <attributes>

which translates to this in your case

intnx('month',input(put(DLA,8.),yymmdd8.),-1,'E') as lastmonth format=yymmdd8.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

create a previous month field using a current date field.