SAS timestamp from scientific notation to yyyy / mm / dd hh: mm: ss

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. , . , , , , !

+4
1

datetime17. - SAS, . ymddttm. , , .

: SAS : date datetime. date - 1 1960 , datetime - 01.01.1960 00:00:00 , . datepart datetime → dhms → .

, , . UNIX - 1970 . SAS - 1960 .

, , w.d bestw.d - format timestampvar 14., , w - (), .

+6

All Articles