DATA Step, Macro, Functions and more

datatype teradata to sas

Reply
Contributor
Posts: 28

datatype teradata to sas

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;

 errorSmiley Very Happyatatype 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;

Super User
Posts: 5,257

Re: datatype teradata to sas

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?

Data never sleeps
Contributor
Posts: 28

Re: datatype teradata to sas

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

Ask a Question
Discussion stats
  • 2 replies
  • 118 views
  • 0 likes
  • 2 in conversation