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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.