numeric datetime to character

JillChen0131 — Fri, 29 Jul 2022 22:23:42 GMT

I have a numeric version of datetime, like13DEC2021:10:28:00. I would like to convert it to character format like yyyy-mm-dd:hh:mm. Thanks for your help

Re: numeric datetime to character

Reeza — Fri, 29 Jul 2022 22:32:49 GMT

Why character? Teradata load?

https://communities.sas.com/t5/SAS-Data-Management/Timestamp-format-of-YYYY-MM-DD-HH-MM-SS/td-p/314667

Otherwise I typically recommend the ISO format.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.2/leforinforref/n03vr57gdozvean1klfaaa14c9c0.htm

proc format;
picture dtpic
other='%Y-%0m-%0d %0H:%0M:%0S' (datatype=datetime)
;
run;

data a;
 a = datetime();
length b $30.;
 b = put(a, dtpic.);
 format a dtpic.;
run;

topic Re: numeric datetime to character in SAS Programming

numeric datetime to character

Re: numeric datetime to character