I'd suggest doing the date and time conversion in SAS not Impala. Start with this which should handle the date:
proc sql;
connect to impala (dsn=abc user="&sysuserid." pw="&password.");
create table abc as
select *
,input(dt, yymmdd10.) as SAS_Date format = date9.
from connection to impala
(select id, dt, tm,
from DB
);
disconnect from impala;
quit;
What does your time string represent? Is it hh:mm:ss like 04:05:07.669747 or something else?
... View more
