topic Re: Timestamp conversion in SAS in SAS Procedures

Timestamp conversion in SAS

KevinC_ — Thu, 10 Sep 2009 19:55:19 GMT

Hello everyone,

Does anyone know how to convert a DB2 timestamp value from this:

15JUL1992:14:15:44.00208

to something like this?
1992-07-15:14:15:44.00208

I really appreciate your help!

Re: Timestamp conversion in SAS

sbb — Thu, 10 Sep 2009 20:50:29 GMT

From the SAS support http://support.sas.com/, using SEARCH facility:

Usage Note 8510: PROC FORMAT with PICTURE statement gives flexibility for DATE, TIME and DATETIME FORMATS

http://support.sas.com/kb/8/510.html

Scott Barry
SBBWorks, Inc.

Re: Timestamp conversion in SAS

KevinC_ — Thu, 10 Sep 2009 21:40:15 GMT

Hi Scott,

Thank you so much for the input! I got this instruction from the link you provided:

proc format;
picture dttime other='%0m/%0d/%0y %0H:%0M:%0S'
(datatype=datetime);
run;

It has worked for the most part. But the problem now is the milisecond (in bold print) at the end has been truncated:
This is the data before:
15JUL1992:14:15:44.002087

This is the data after:
1992-07-15-14.15.44

Is there a milisecond symbol I can use in this case?

Thank you !!

Re: Timestamp conversion in SAS

sbb — Thu, 10 Sep 2009 22:10:29 GMT

I don't believe there is support beyond the second. If you are printing this information, it is possible to use the format in a DATA step PUT function assignment (to generate the date portion) and then concatenate the date with a SAS time-portion variable using the TIME format.

Scott Barry
SBBWorks, Inc.