topic Re: format date time in New SAS User

format date time

Smitha9 — Tue, 30 Jun 2020 03:11:05 GMT

Hi,

I have a data,

2020-03-20 13:00:23

2019-04-28 14:18:00

2015-05-20 15:20:30

I want to change to

03/20/2020 13:00:23

04/28/2019 14:18:00

05/20/2015 15:20:30

can you let me know the code.

thank you.

Re: format date time

Kurt_Bremser — Tue, 30 Jun 2020 06:09:40 GMT

Have a look at the NLDATMS format.

Re: format date time

Jagadishkatam — Tue, 30 Jun 2020 09:06:31 GMT

Is the date in character format

Re: format date time

Jagadishkatam — Tue, 30 Jun 2020 09:48:39 GMT

If the date is in character format then you may try the below code

data have;
input date&$20.;
cards;
2020-03-20 13:00:23
2019-04-28 14:18:00
2015-05-20 15:20:30
;

data want;
set have;
date2=cat(put(input(scan(date,1,''),yymmdd10.),ddmmyys10.),scan(date,2,''));
run;

Re: format date time

Kurt_Bremser — Tue, 30 Jun 2020 10:35:31 GMT

To convert from character, use the E8601DT informat:

data have;
input datechar $19.;
datenum = input(datechar,e8601dt19.);
format datenum nldatms19.;
datalines;
2020-03-20 13:00:23
2019-04-28 14:18:00
2015-05-20 15:20:30
;

How the datetime is displayed depends on the setting of the LOCALE= system option.