topic Re: separate date and time in New SAS User

separate date and time

chinna0369 — Thu, 05 Sep 2019 17:56:25 GMT

Hi all,

How can I separate date (date9.) and time (time5.) from below data:

Obs subj date
1 CA2099DX-1-304 2019-08-09
2 CA2099DX-1-304 2019-06-13T12:00
3 CA2099DX-1-304 2019-07-13T09:00
4 CA2099DX-1-304 2019-05-06
5 CA2099DX-108-175 2019-03-08
6 CA2099DX-108-175 2019-06-28
7 CA2099DX-108-175 2019-03-07
8 CA2099DX-108-175 2019-03-07
9 CA2099DX-108-175 2019-03-07
10 CA2099DX-108-175 2019-02-04
11 CA2099DX-108-175 2019-01-10T00:00
12 CA2099DX-108-175 2019-01-28
13 CA2099DX-108-175 2019-03-08
14 CA2099DX-108-175 2019-05-02
15 CA2099DX-108-175 2019-02-04

Thanks,

Adi

Re: separate date and time

chinna0369 — Thu, 05 Sep 2019 17:58:34 GMT

and I want to create datetime20. by using those two new variables and if time is missing then I want to show as following format

"07MAR2019:00:00:00"

Thanks,

Adithya

Re: separate date and time

ballardw — Thu, 05 Sep 2019 18:01:12 GMT

@chinna0369 wrote:

Hi all,

How can I separate date (date9.) and time (time5.) from below data:

Obs subj date
1 CA2099DX-1-304 2019-08-09
2 CA2099DX-1-304 2019-06-13T12:00
3 CA2099DX-1-304 2019-07-13T09:00
4 CA2099DX-1-304 2019-05-06
5 CA2099DX-108-175 2019-03-08
6 CA2099DX-108-175 2019-06-28
7 CA2099DX-108-175 2019-03-07
8 CA2099DX-108-175 2019-03-07
9 CA2099DX-108-175 2019-03-07
10 CA2099DX-108-175 2019-02-04
11 CA2099DX-108-175 2019-01-10T00:00
12 CA2099DX-108-175 2019-01-28
13 CA2099DX-108-175 2019-03-08
14 CA2099DX-108-175 2019-05-02
15 CA2099DX-108-175 2019-02-04

Thanks,

Adi

Is that actually the content of a SAS dataset? If so, what is the current format for that "date" variable?

If that is actually a character variable the first thing will be to read the date into a SAS date/ datetime value.

Re: separate date and time

chinna0369 — Thu, 05 Sep 2019 18:09:40 GMT

Yes, this is SAS content. and my date variable is charecter $16. format.

I don't understand second question? can you explain it to me clearly?

Thanks,

Adithya

Re: separate date and time

novinosrin — Thu, 05 Sep 2019 18:17:48 GMT

data have;
input Obs subj :$20. datetime :ymddttm24.;
date=datepart(datetime);
time=timepart(datetime);
format datetime datetime20. date date9. time time5.;
cards;
1   CA2099DX-1-304     2019-08-09
2   CA2099DX-1-304     2019-06-13T12:00
3   CA2099DX-1-304     2019-07-13T09:00
4   CA2099DX-1-304     2019-05-06
5   CA2099DX-108-175 2019-03-08
6   CA2099DX-108-175 2019-06-28
7   CA2099DX-108-175 2019-03-07
8   CA2099DX-108-175 2019-03-07
9   CA2099DX-108-175 2019-03-07
10 CA2099DX-108-175 2019-02-04
11 CA2099DX-108-175 2019-01-10T00:00
12 CA2099DX-108-175 2019-01-28
13 CA2099DX-108-175 2019-03-08
14 CA2099DX-108-175 2019-05-02
15 CA2099DX-108-175 2019-02-04
;

Re: separate date and time

Reeza — Thu, 05 Sep 2019 18:21:12 GMT

INPUT() can be used to convert dates and times.

You can try ANYDTDTM. as your informat and it should do a decent job at guessing the data. I think that will get you what you want and you just need to apply the formats that after the fact.

Here's a great, but longer and in depth, reference for dates and times in SAS - it covers in detail how to do this and answers your question in detail.
https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354

@chinna0369 wrote:

Hi all,

How can I separate date (date9.) and time (time5.) from below data:

Obs subj date
1 CA2099DX-1-304 2019-08-09
2 CA2099DX-1-304 2019-06-13T12:00
3 CA2099DX-1-304 2019-07-13T09:00
4 CA2099DX-1-304 2019-05-06
5 CA2099DX-108-175 2019-03-08
6 CA2099DX-108-175 2019-06-28
7 CA2099DX-108-175 2019-03-07
8 CA2099DX-108-175 2019-03-07
9 CA2099DX-108-175 2019-03-07
10 CA2099DX-108-175 2019-02-04
11 CA2099DX-108-175 2019-01-10T00:00
12 CA2099DX-108-175 2019-01-28
13 CA2099DX-108-175 2019-03-08
14 CA2099DX-108-175 2019-05-02
15 CA2099DX-108-175 2019-02-04

Thanks,

Adi

Re: separate date and time

novinosrin — Thu, 05 Sep 2019 18:22:01 GMT

And if your data is in a SAS dataset, then


data have;
input Obs subj :$20. datetime :$24.;
cards;
1   CA2099DX-1-304     2019-08-09
2   CA2099DX-1-304     2019-06-13T12:00
3   CA2099DX-1-304     2019-07-13T09:00
4   CA2099DX-1-304     2019-05-06
5   CA2099DX-108-175 2019-03-08
6   CA2099DX-108-175 2019-06-28
7   CA2099DX-108-175 2019-03-07
8   CA2099DX-108-175 2019-03-07
9   CA2099DX-108-175 2019-03-07
10 CA2099DX-108-175 2019-02-04
11 CA2099DX-108-175 2019-01-10T00:00
12 CA2099DX-108-175 2019-01-28
13 CA2099DX-108-175 2019-03-08
14 CA2099DX-108-175 2019-05-02
15 CA2099DX-108-175 2019-02-04
;

data want;
set have;
datetime_num =input(datetime,ymddttm24.);
date=datepart(datetime_num);
time=timepart(datetime_num);
format datetime_num datetime20. date date9. time time5.;
run;

Re: separate date and time

Jagadishkatam — Thu, 05 Sep 2019 18:25:39 GMT

Please try the below code

data have;
input Obs subj :$20. datetime:$100.;
if index(datetime,'T') then newdate=input(scan(datetime,1,'T'),yymmdd10.);
else newdate=input(datetime,yymmdd10.);
if index(datetime,'T') then time=input(scan(datetime,2,'T'),time5.);
if index(datetime,'T') then newdatetime=input(datetime,is8601dt.);
else newdatetime=input(cats(datetime,'T00:00'),is8601dt.);
format newdate date9. time time5. newdatetime datetime20.;
cards;
1   CA2099DX-1-304     2019-08-09
2   CA2099DX-1-304     2019-06-13T12:00
3   CA2099DX-1-304     2019-07-13T09:00
4   CA2099DX-1-304     2019-05-06
5   CA2099DX-108-175 2019-03-08
6   CA2099DX-108-175 2019-06-28
7   CA2099DX-108-175 2019-03-07
8   CA2099DX-108-175 2019-03-07
9   CA2099DX-108-175 2019-03-07
10 CA2099DX-108-175 2019-02-04
11 CA2099DX-108-175 2019-01-10T00:00
12 CA2099DX-108-175 2019-01-28
13 CA2099DX-108-175 2019-03-08
14 CA2099DX-108-175 2019-05-02
15 CA2099DX-108-175 2019-02-04
;

Re: separate date and time

Reeza — Thu, 05 Sep 2019 18:32:49 GMT

Also, why do you want to do this? You can often summarize your data using just a datetime variable and using the appropriate formats in your procedures.

Re: separate date and time

data_null__ — Thu, 05 Sep 2019 18:36:05 GMT

Read the field with in-format B8601DT. no need to fiddle with anything.

datetime :b8601dt.;

Re: separate date and time

alexpat — Mon, 09 Sep 2019 20:58:33 GMT

data jugular;
input Obs subj :$20. datetime :$24.;
cards;
1 CA2099DX-1-304 2019-08-09
2 CA2099DX-1-304 2019-06-13T12:00
3 CA2099DX-1-304 2019-07-13T09:00
4 CA2099DX-1-304 2019-05-06
5 CA2099DX-108-175 2019-03-08
6 CA2099DX-108-175 2019-06-28
7 CA2099DX-108-175 2019-03-07
8 CA2099DX-108-175 2019-03-07
9 CA2099DX-108-175 2019-03-07
10 CA2099DX-108-175 2019-02-04
11 CA2099DX-108-175 2019-01-10T00:00
12 CA2099DX-108-175 2019-01-28
13 CA2099DX-108-175 2019-03-08
14 CA2099DX-108-175 2019-05-02
15 CA2099DX-108-175 2019-02-04
;

data foramen;
set jugular;
datetime_num =input(datetime,ymddttm24.);
date=datepart(datetime_num);
time=timepart(datetime_num);
format datetime_num datetime20. date date9. time time5.;
run;

This solution is lot easier ...