topic Re: Teradata connection in SAS Programming

Teradata connection

sam-syed — Sat, 23 Mar 2019 11:48:22 GMT

Hi,

I am connecting to Teradata using below code but SAS reading

teradata table wrong

For example customerId 23 in teradata, sas reading it as 24 and some ID sas not even reading

. Any help will be appropriated

Code

libname test teradata userid =“userid” pw “password” server =“teradata server” database =“DBName”;

VDD — Sat, 23 Mar 2019 12:42:09 GMT

remember the basics 8 bytes.

Tom — Sat, 23 Mar 2019 14:38:43 GMT

You haven't given us enough information to tell what your question is.

VDD — Sat, 23 Mar 2019 14:46:45 GMT

sounds like another question where the user doesn't understand why SAS uses 8 when setting up strings if the user doesn't define the length.