Store Date Milliseconds

[arnouxvr]

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

[RW9]

Hi,

See:

[Ksharp]

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

[arnouxvr]

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?

[Kurt_Bremser]

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.

[Kurt_Bremser · Accepted solution]

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.

[arnouxvr]

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;