datatype teradata to sas

[LearnByMistk]

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;

[LinusH]

Assuming that you already have read this:

http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#n0v7nh4ylrihtin1te...

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?

[LearnByMistk]

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