log
NOTE: Table WRK.FINAL_BRACC_16 created, with 2299377 rows and 118 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 5:17.36
user cpu time 1:26.53
system cpu time 1:37.68
memory 3157797.34k
OS Memory 3178424.00k
Timestamp 2021/10/11 07:45:36 AM
Step Count 66 Switch Count 0
Page Faults 0
Page Reclaims 13399330
Page Swaps 0
Voluntary Context Switches 1043821
Involuntary Context Switches 64960
Block Input Operations 0
Block Output Operations 0
ERROR: The value BOOK BALANCE is not a valid SAS name.
ERROR: The value BOOK BALANCE is not a valid SAS name.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
Good day,
Book balance value or field is not declared anywhere in the code, however the log shows me that book balance value is not a valid SAS name.
script
PROC SQL;
CREATE TABLE WRK.FINAL_BRACC_YG (ENCODING=ANY) AS
SELECT Business_Area
,Portfolio
,M_ACC_NO AS NEW_ACC
,M_GD_SERIAL AS NEW_SERIAL
,INPUT(ZZ0011,16.) AS ACCOUNT_NUMERIC
,B.M_ACC_TYPE AS M_TYPE
,B.M_ACC_MISC1 AS MISC1
,
CASE
WHEN B.M_ACC_MISC1 = "9" OR B.M_ACC_STYLE = "ZZZ"
THEN "Closed"
ELSE "Open"
END
AS OpenOrClosed
,ZZ0012
,ATWRT AS BP_MKT_SEG
,BP_MKT_SEG_DESC
,C.PMMADTLS_MKTSEG AS MKT_SEG
,PARTNER AS BPID
,ZZACCOUNTEXE as AE_NO
,TYPE
,B.STATUS
,NAME_ORG1 AS LEGAL_NAME
,ID_TYPE
,IDNUMBER
,INPUT(ZZCONTROLLIN,8.) AS CENTRE
,B.CSA_GRP_ACC_NO AS GROUP_NO
,B.M_BOOK_BAL AS BOOK_BAL
,B.M_NAME AS BA_NAME
,B.M_DORM_IND AS DORM
,B.M_BCH_NO AS IBT_NO
,YYKYC_STATUS AS KYC
,OD_ACC_TO_BE_DEBITED
,BPKIND
,SHORT_TEXT AS PRODUCT
,SUBSTR(PRODUCT_ID,37,4) AS PRODUCT_CODE /*PRODUCT CODE FOUND IN GTS TABLES AND USED BY BUSINESS IS FOUND WITHIN THE PRODUCT ID COLUMN*/
,B.M_ACC_STYLE AS STYLE
,C.PMMADTLS_RB_CODE AS RB_CODE
,C.PMMADTLS_DLA AS DLA
,C.PMMADTLS_DATE_OPENED
,C.PMMADTLS_DATE_CLOSED
,LEGAL_ENTY AS LEGAL_ENTITY
,UPCASE(M_OD_INSURANCE) AS M_OD_INSURANCE
,CSA_OVERDRAFT_LIMIT
,OD_1ST_RATE
,OD_1ST_LIMIT
,OD_2ND_RATE
,OD_2ND_LIMIT
,OD_3RD_RATE
,OD_3RD_DECIMALS
,B.M_LST_ACT AS LAST_ACTIVE_DATE
,A.ZZ0014
,COMPRESS(Business_Area||ZZ0011||ATWRT||PARTNER||TYPE||BPKIND||SHORT_TEXT||PRODUCT_ID||M_ACC_STYLE)
FROM WRK.TO_PROD_TEXT_YG (ENCODING=ANY) A
LEFT JOIN SRC.BA_PMMACCNT (ENCODING=ANY) B
ON INPUT(A.ZZ0011,16.) = INPUT(COMPRESS((PUT(B.M_ACC_NO,Z13.))||PUT(B.M_GD_SERIAL,Z3.)),16.)
LEFT JOIN SRC.BA_PMMADTLS (ENCODING=ANY) C
ON INPUT(A.ZZ0011,16.) = INPUT(COMPRESS((PUT(C.PMMADTLS_ACC_NO,Z13.))||PUT(C.PMMADTLS_SERIAL,Z3.)),16.)
WHERE B.M_ACC_NO <> .
;
QUIT;
PROC SORT DATA=WRK.FINAL_BRACC_YG (ENCODING=ANY) DUPOUT=DUPLICATES_YG (ENCODING=ANY) OUT=WRK.FINAL_BRACC_2_YG (ENCODING=ANY) NODUPKEY;
BY _TEMA001;
RUN;
Click image to register for webinar
