hi i am tring to conver a charecter field popelated with (2018-09-01 00:00:00) to datetime19. format . as i have used the below script but it give me the output of only dates without time: data want (drop=TRANSACTION_DATE _date );
set b;
format TRANSACTION_DATE_1 YYMMDD10. ;
informat TRANSACTION_DATE_1 YYMMDD10. ;
_date=substr(TRANSACTION_DATE,1,18);
TRANSACTION_DATE_1=INPUT(_date,YYMMDD10.);
run;
data want2 (drop=TRANSACTION_DATE_ );
set want;
format TRANSACTION_DATE YYMMDD10. ;
informat TRANSACTION_DATE YYMMDD10.;
TRANSACTION_DATE=TRANSACTION_DATE_1;
run; Thank You
... View more