topic Re: Formatting date in SAS Procedures

Formatting date

Pandu2 — Tue, 07 Dec 2021 07:19:58 GMT

Hi all,
I've a character value which is like "2012-07-07T20:44:30.293Z". I would like to change this format to datetime
Required : 2012-07-07T20:44:30.293Z
Thanks.

Re: Formatting date

sbxkoenk — Tue, 07 Dec 2021 10:38:27 GMT

Hello,

What is 'Z'?

data _NULL_;
 a="2012-07-07T20:44:30.293Z";
 b=input(scan(a,1,'T'),YYMMDD10.); put b= date9.;
 c=input(compress(scan(a,2,'T'),'Z'),time12.3); put c= time12.3;
 d=b*24*60*60 + c; put d= datetime22.3;
run;
/* end of program */

Koen

Re: Formatting date

Pandu2 — Tue, 07 Dec 2021 10:43:04 GMT

Z refers to ZULU

Re: Formatting date

Kurt_Bremser — Tue, 07 Dec 2021 10:46:36 GMT

I think "Z" means "Zulu Time", which is short for Coordinated Universal Time, or what is commonly known as GMT.

So simply discarding it will be OK.

Re: Formatting date

Reeza — Tue, 07 Dec 2021 17:55:57 GMT

That's an ISO date and there should be informats to handle it directly.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/leforinforref/n09tmeo4t9edo2n145twyoew1txu.htm

data demo;
 a="2012-07-07T20:44:30.293Z";
 b=input(a, B8601DZ.);
 format b B8601DZ.;
run;

proc print;run;

@Pandu2 wrote:
Hi all,
I've a character value which is like "2012-07-07T20:44:30.293Z". I would like to change this format to datetime
Required : 2012-07-07T20:44:30.293Z
Thanks.

Re: Formatting date

sbxkoenk — Tue, 07 Dec 2021 18:24:03 GMT

@Reeza : thanks for learning me something new.

@Pandu2 : sorry for my earlier reply which was of little or no use to you.

Koen

Re: Formatting date

Kurt_Bremser — Thu, 09 Dec 2021 08:41:26 GMT

I would rather use the extended ISO 8601 formats/informats:

data demo;
 a="2012-07-07T20:44:30.293Z";
 b=input(a,e8601DZ.);
 format b e8601DZ.;
run;