Help using Base SAS procedures

convert numeric to datetimew.d

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 110
Accepted Solution

convert numeric to datetimew.d

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


Accepted Solutions
Solution
‎01-09-2014 06:12 PM
Respected Advisor
Posts: 4,919

Re: convert numeric to datetimew.d

Posted in reply to sophia_SAS

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

format dt datetime22.3;

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

PG

PG

View solution in original post


All Replies
Solution
‎01-09-2014 06:12 PM
Respected Advisor
Posts: 4,919

Re: convert numeric to datetimew.d

Posted in reply to sophia_SAS

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

format dt datetime22.3;

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

PG

PG
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 784 views
  • 0 likes
  • 2 in conversation