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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.