BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sophia_SAS
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

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

1 REPLY 1
PGStats
Opal | Level 21

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

format dt datetime22.3;

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

PG

PG

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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