BookmarkSubscribeRSS Feed
pp2014
Fluorite | Level 6

I have date string  = "20150109103704" How do I  convert it to 09JAN2015:10:37:04

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Hi,

The DHMS() function is probably easiest:

data want;

  orig="20150109103704";

  datet=dhms(input(substr(orig,1,8),yymmdd8.),input(substr(orig,9,2),2.),input(substr(orig,11,2),2.),input(substr(orig,13,2),2.));

  format datet datetime.;

run;

pp2014
Fluorite | Level 6

Thanks..

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore 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
  • 2 replies
  • 1792 views
  • 0 likes
  • 2 in conversation