Convert Date Format

[goms]

Hi,

Below is my output

src_systime	date_systime	logtime
28APR2016:14:58:51.000000	28apr16	14:58:51
28APR2016:14:58:51.000000	28apr16	14:58:51
28APR2016:14:58:51.000000	28apr16	14:58:51
28APR2016:14:58:51.000000	28apr16	14:58:51
28APR2016:14:58:52.000000	28apr16	14:58:52
28APR2016:14:58:52.000000	28apr16	14:58:52

I want to convert the date format as below

src_systime	date_systime	logtime
2016-04-28 14:58:51	2016-04-28	14:58:51
2016-04-28 14:58:51	2016-04-28	14:58:51
2016-04-28 14:58:51	2016-04-28	14:58:51
2016-04-28 14:58:51	2016-04-28	14:58:51
2016-04-28 14:58:52	2016-04-28	14:58:52
2016-04-28 14:58:52	2016-04-28	14:58:52

[Jagadishkatam]

data have;
input src_systime : anydtdtm20.	date_systime :date9.	logtime :time8.;
format src_systime  datetime20. 	date_systime date9. logtime time8.;
cards;
28APR2016:14:58:51.000000	28apr16	14:58:51
28APR2016:14:58:51.000000	28apr16	14:58:51
28APR2016:14:58:51.000000	28apr16	14:58:51
28APR2016:14:58:51.000000	28apr16	14:58:51
28APR2016:14:58:52.000000	28apr16	14:58:52
28APR2016:14:58:52.000000	28apr16	14:58:52
;

[Kurt_Bremser]

Is the "output" a text file or already a SAS dataset?

[goms]

Its a SAS dataset only

[Jagadishkatam]

Then, are these variables character type

[Kurt_Bremser]

If these are already SAS datetime, date and time values, you just need the proper formats.

Look at the E8601DT19. format for the datetime value, YYMMDDD10. for the date and TIME8. for the time.