topic Re: Teradata column bigint is not showing in SAS in SAS Data Management

Teradata column bigint is not showing in SAS

anlyar2050 — Thu, 19 Jan 2017 16:03:21 GMT

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

Re: Teradata column bigint is not showing in SAS

JBailey — Thu, 19 Jan 2017 16:23:48 GMT

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.

http://support.sas.com/kb/39/831.html

Re: Teradata column bigint is not showing in SAS

anlyar2050 — Fri, 20 Jan 2017 01:46:00 GMT

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.

Re: Teradata column bigint is not showing in SAS

LinusH — Fri, 20 Jan 2017 05:41:49 GMT

Agree that it's not very clear in the usage note, but I found a little more specific description in the ACCESS to Netezza doc:

"suppress the errors by setting the TRUNCATE_BIGINT environment variable to YES before you start SAS."

Re: Teradata column bigint is not showing in SAS

anlyar2050 — Fri, 20 Jan 2017 15:21:28 GMT

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.

Re: Teradata column bigint is not showing in SAS

LinusH — Sat, 21 Jan 2017 00:39:09 GMT

It depends on how/where your SAS session is/starts. Generally you could either use a SET instruction in a config file, or have it set in operating system, for your user or globally. You might sent to talk to your SAS responsible/admin or platform team for on site guidance.