convert numeric to datetimew.d

[sophia_SAS]

I would like to convert a SAS numeric to datetime22.3. However, as my original value does not have the time values (only dates) how, do I get my new format to accurately reflect the date and automatically add zeros for the time part.

What SAS statement should I use to produce the below datetime22.3 format if I have the SAS numeric code as my starting point?

SAS numeric = 18453  --> format mmddy10 = 07/10/2010 --> format datetime22.3 =10JUL2010:00:00:00.000

[PGStats · Accepted solution]

Convert the SAS date value to a SAS datetime value like so:

format dt datetime22.3;

dt = dhms(myDate, 0, 0, 0);

PG