how to convert teradata timestamp while culling data in to sas using proc sql:
condition
suppose in TD we have table T1
columns id number (20,0)
dt timestamp(0)
while culling this data in sas as
proc sql;
create table mylib.t1 as
select id,dt from td.T1;quit;
error:Datatype not supported by this engine
have used below step also but it's not working
proc sql;
create table mylib.t1 as
select id
,dt format =datetime21. from td.T1;quit;
Assuming that you already have read this:
TMESTAMP(0) is supported as DATETIME19. in SAS.
If you have a time zone on the column, it will be read as CHAR in SAS. Perhaps this is the case?
Hi ,
Thanks for infoo ,I have read that post but my issue still remains the same
column datatype in teradata is timestamp(0) and when i tried to cull data from TD to sas via pass through sql as
proc sql;
connect to teradata (user=&user password=&pwd mode=teradata);
create table mysas.data1 as
select * from connection to teradata(
/**********approaches i used so far****/
select employee_id , registration_date format =timestamp19.); fail
select employee_id , cast(registration_date as mm-dd-yyyy hh:mm:ss.); fail
disconnect to teradata;
quit;
could you help me how to get this thing into SAS
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.