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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.