BookmarkSubscribeRSS Feed
mmea
Quartz | Level 8

Hi

 

How can i change this datetime format 

22APR2021:07:51:00.000

to

2021-04-22 :07:51:00.000

 

1 REPLY 1
Kurt_Bremser
Super User

Create your own picture format:

proc format;
picture yymmddhhmmss
  low-high = '%Y-%0m-%0d :%0H:%0M:%0s'(datatype=datetime decsep='.')
;
run;

data want;
dt = '22APR2021:07:51:00.000'dt;
format dt yymmddhhmmss25.3;
run;