topic Re: datatype teradata to sas in SAS Programming

datatype teradata to sas

LearnByMistk — Tue, 28 Feb 2017 09:49:46 GMT

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 — Tue, 28 Feb 2017 10:20:27 GMT

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?

LearnByMistk — Mon, 06 Mar 2017 10:54:50 GMT

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