While reading and pushing BIGINT data type in teradata i am facing problem..if i create the table in teradara with one of the column defined data type IS BIGINT but it will not appear in sas di what i do......thanks in advance.....
DI Studio uses Base SAS and is therefore bound to its limitations.
Use a direct connection between the databases, or program it manually, using proc ds2.
In a standard SAS data step, there is no BIGINT data type. SAS only knows 8-byte real numeric data.
Either use a direct connection from one DB to the other, or take a look at PROC DS2, which has more datatypes, including BIGINT.
There have been several threads on the communities dealing with this issue.
A quick search will hopefully give you some insight and alternatives how to proceed.
DI Studio uses Base SAS and is therefore bound to its limitations.
Use a direct connection between the databases, or program it manually, using proc ds2.
Hi @ganeshmule,
Check out...
Problem Note 39831: Problem occurs with BIGINT data types within SAS 9.2 (pay special attention to the environment variable at the bottom)
Usage Note 31560: Choosing your degree of numeric precision
Best wishes,
Jeff
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.