01-19-2017 10:45 AM - last edited on 01-19-2017 11:03 AM by ChrisHemedinger
There is a table in Teradata which has bigint column, those columns aren't accessible from SAS. Is there any option to get access that columns from SAS EG 7.12
01-19-2017 11:23 AM
SAS cannot read the BIGINT data types, directly. There are a couple of ways to handle it.
The first is to have your DBA create views which CAST the BIGINT columns to a character data type (Linus' recommendation). You can do this, without creating Teradata views, using explicit pass-thru.
I have pulled some slides covering using SAS with Teradata BIGINT from a workshop that I used to deliver. Hopefully, they will help. If the slides require clarification please let me know.
Be careful with TRUNCATE_BIGINT. Doing calculations using BIGINT columns could very well be problematic because you can get incorrect answers.
01-19-2017 08:46 PM
thanks for the reply.
I understand this but users usually won't do coding they will use tables and do query builder. So where can we set truncate_bigint to Yes? So that they can use tables in query builder instead of coding.
01-20-2017 12:41 AM
01-20-2017 10:21 AM
Thanks for the reply.
I understand to set the TRUNCATE_BIGINT environment variable to YES, but I don't understand is where to set environmental variable?
01-20-2017 07:39 PM