topic Store Date Milliseconds in SAS Programming

Store Date Milliseconds

arnouxvr — Mon, 11 May 2015 10:03:20 GMT

Is it possible to store a timestamp on a SAS Dataset date column that will contain milliseconds as well?

Re: Store Date Milliseconds

RW9 — Mon, 11 May 2015 10:31:59 GMT

Hi,

See:

Re: Store Date Milliseconds

Ksharp — Mon, 11 May 2015 12:04:19 GMT

No. Date type variable (integer) is different with DateTime(double) type variable. You should firstly know what kind of variable you should use .

Message was edited by: xia keshan

Re: Store Date Milliseconds

arnouxvr — Mon, 11 May 2015 12:20:31 GMT

I just want to make sure about the following:

data timestamp;

date1 = date();

date2 = datetime();

run;

date1 contains the number of days from 1 JAN 1960 and date2 contains the number of seconds from midnight 1 JAN 1960.

How do I create a variable date3 that contains the number of milliseconds from 1 JAN 1960?

Re: Store Date Milliseconds

Kurt_Bremser — Mon, 11 May 2015 12:21:38 GMT

You first have to convert a date column (days from 01jan1960) to a datetime column (seconds from 01jan1960:00:00:00), then you can use the fractional part of the datetime value to store fractions of a second. Use datetime23.3 as format to display milliseconds.

Re: Store Date Milliseconds

Kurt_Bremser — Mon, 11 May 2015 12:23:00 GMT

If you only want to display the total number of milliseconds, just multiply the datetime value by 1000. And use a simple numerical format instead of a datetime format.

Re: Store Date Milliseconds

arnouxvr — Mon, 11 May 2015 12:32:31 GMT

Thanks KurtBremser,

It looks like it is working when I create two data steps in order to "delay" execution I can see that the timestamp per millisecond is different.

data time1;

date1 = datetime();

run;

data time2;

date1 = datetime();

run;

data time;

set time1 time2;

format date: datetime23.3;

run;

proc print;

run;