topic Re: Convert Date Format in SAS Programming

Convert Date Format

goms — Tue, 07 Jun 2016 12:13:03 GMT

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

Re: Convert Date Format

Jagadishkatam — Tue, 07 Jun 2016 12:45:19 GMT

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
;

Re: Convert Date Format

Kurt_Bremser — Tue, 07 Jun 2016 13:43:04 GMT

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

Re: Convert Date Format

goms — Tue, 07 Jun 2016 14:07:00 GMT

Its a SAS dataset only

Re: Convert Date Format

Jagadishkatam — Tue, 07 Jun 2016 14:16:09 GMT

Then, are these variables character type

Re: Convert Date Format

Kurt_Bremser — Tue, 07 Jun 2016 14:27:16 GMT

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.