Datatype mismatch converting SAS numeric to Teradata BIGINT -
i have sas dataset numeric variable acct_id (among other fields). attributes in proc contents
are:
# variable type len format informat label 1 acct_id num 8 19. 19. acct_id
i know field doesn't have non-integer values in it, want store bigint in teradata, , i've specified dbtype
data set option this:
data td.output(dbtype=(acct_id="bigint", <etc etc>));
however, gives following error:
error: datatype mismatch column: acct_id.
there no missing or non-integer values in field, , error persists if round acct_id using round(acct_id, 1)
explicitly remove floating point values could exist.
strangely enough, no error given if assign decimal(18,0) in teradata rather bigint. guess 1 workaround, i'd understand how can create integer fields in teradata sas numeric variables given sas doesn't distinguish types between integer , floating point.
sas not support bigint datatype. see http://support.sas.com/kb/34/729.html.
teradata's bigint data type not supported in sas/access interface teradata. cannot read or update table containing column bigint data type in sas/access interface teradata. attempting generates following error message:
error: @ least 1 of columns in dbms table has datatype not supported engine.
Comments
Post a Comment