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
Hi @anlyar2050
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.
Hi @anlyar2050
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.
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.
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?
Thanks.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.