According to SAS documentation on 9.4 version(latest as date), length(max) of numeric variable in SAS data set is 8 bytes or 15 significant digits. However, in Netezza, numeric-BIGINT can hold up to 18 significant digits. source: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Netezza-5.-54/page/4/Data-Types When we attempt to pull a numeric variable with more than 15 significant digits from Netezza into SAS; as it can’t hold excess of 15 digits, SAS throws either of the below errors: 28 PROC SQL; 29 CREATE TABLE NETEZZA_TEST AS 30 SELECT 31 SRC_STM_CD, 32 COUNT(PUT(CUST_ID,Z20.)||PUT(CUST_ID,Z20.)) AS CHK_COUNT 33 FROM DATA_Q.D_TABLE; ERROR: Error during in-database processing. ERROR: ERROR: ERROR: relation does not exist CCRMPRD.DATA_Q.D_TABLE The maximum value of CHK_COUNT in above query is 6016788360167883 aka length of 16 digits.
... View more