Problem:
My timestamp is displayed in scientific notation. I would like to display a column without scientific notation and create a second column formatted as a long date, yyyy / mm / dd hh: mm: ss.
Steps taken:
I have already converted a column from the time of the UNIX Epoch (1960) timestamp to the SAS (1970) timestamp. But scientific notation persists. I tried the date20. also does not do the trick.
Timestamp in scientific notation
My current insufficient code cannot format the timestamp column as a date.
proc print data=heart._23a; format timestamp date9.; run;
Results:
, 1x3. , . , , , , !
datetime17. - SAS, . ymddttm. , , .
datetime17.
ymddttm.
: SAS : date datetime. date - 1 1960 , datetime - 01.01.1960 00:00:00 , . datepart datetime → dhms → .
date
datetime
datepart
dhms
, , . UNIX - 1970 . SAS - 1960 .
, , w.d bestw.d - format timestampvar 14., , w - (), .
w.d
bestw.d
format timestampvar 14.
w