topic Re: Sysdate to iso8601 in SAS Programming

Sysdate to iso8601

Pandu2 — Wed, 17 Nov 2021 04:41:09 GMT

Hi All,
Can anyone help me on how to convert today's date time to ISO 8601. Which is like YYYY-MM-DDTHH:MM:SS.000Z format.
Any help is appreciated.
Thanks.

Re: Sysdate to iso8601

Pandu2 — Wed, 17 Nov 2021 04:44:38 GMT

I didn't have any date time value stored. I need to take the daily wise system date to convert it to YYYY-MM-DDTHH:MM:SS.000Z.
Thanks.

Re: Sysdate to iso8601

Kurt_Bremser — Wed, 17 Nov 2021 05:00:37 GMT

See the DATETIME() function and the E8601DT format.

Re: Sysdate to iso8601

Pandu2 — Thu, 18 Nov 2021 07:09:30 GMT

Hi All,
I've got some api url named https://xyz.com/abc/def/expecteddel<YYYY-MM-DDTHH:MM:SS.000Z;status==1001

So over there YYYY-MM-DDTHH:MM:SS.000Z should be daily wise datetime and that datetime and status==1001 must be used as macro variable to create a url. For ex,
%let host= rest.xyz.com;
%let uri=/abc/def;
%let date must be equal to YYYY-MM-DDTHH:MM:SS.000Z; to this format.
%let status must be equal to ==1001.
So the final url looks like this.

%let url=&host.&uri.&date.&status.;
So, can anyone help me out on how to achieve the above url macro variable please. Any help appreciated.
Thanks.

Re: Sysdate to iso8601

Pandu2 — Thu, 18 Nov 2021 07:15:15 GMT

It's my bad the api url is https://xyz com/abc/def/?filters=expecteddel<YYYY-MM-DDTHH:MM:SS.000Z;status==1001

The must be converted into a macro variable as shown above ex

Re: Sysdate to iso8601

Kurt_Bremser — Thu, 18 Nov 2021 08:11:48 GMT

%let host= rest.xyz.com;
%let uri=/abc/def;
%let date = %sysfunc(datetime(),e8601dt24.3)Z;
%let status = status==1001;

%let everything=https://&host.&uri./?filters=expecteddel<&date.%str(;)&status;

%put "&everything";

Log:

 69         %let host= rest.xyz.com;
 70         %let uri=/abc/def;
 71         %let date = %sysfunc(datetime(),e8601dt24.3)Z;
 72         %let status = status==1001;
 73         
 74         %let everything=https://&host.&uri./?filters=expecteddel<&date.%str(;)&status;
 75         
 76         %put "&everything";
 "https://rest.xyz.com/abc/def/?filters=expecteddel<2021-11-18T09:07:54.382Z;status==1001"

Re: Sysdate to iso8601

Pandu2 — Thu, 18 Nov 2021 08:31:53 GMT

Thanks, Everything looks good but the isn't converted to that format 2021-11-18T09:07:54.382Z
Log :
"https://rest.xyz.com/abc/def/?filters=expecteddel<1952863053.113Z;status==1001"
This is how it printed the url.

Re: Sysdate to iso8601

Pandu2 — Thu, 18 Nov 2021 08:33:12 GMT

Date isn't converted

Re: Sysdate to iso8601

Kurt_Bremser — Thu, 18 Nov 2021 08:43:02 GMT

As you can see from the log that I posted, the code works (tested on SAS On Demand, so no special setup).

Post your complete log of these macro statements as you ran them.

Re: Sysdate to iso8601

Pandu2 — Thu, 18 Nov 2021 08:52:53 GMT

Here's the log:
1 The SAS System 01:33 Thursday, Nov
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
23
24 %let host=rest.xyz.com;
25 %let uri=/abc/def;
26 %let date = %sysfunc(datetime(),e8061dt24.3)Z;
27 %let status= status==1001;
28 %let url=https://&host.&uri./?filters=expecteddel<&date.%str(;)&status;
29 %put "&url";
"https://rest.xyz.com/abc/def/?filters=expecteddel<1952863053.113Z;status==1001"

Re: Sysdate to iso8601

Pandu2 — Thu, 18 Nov 2021 08:53:33 GMT

I ran it in Sas EG

Re: Sysdate to iso8601

Kurt_Bremser — Thu, 18 Nov 2021 09:18:32 GMT

You misspelled the format in the %SYSFUNC; it should be e8601, not e8061.

Re: Sysdate to iso8601

Pandu2 — Thu, 18 Nov 2021 09:22:02 GMT

I'm sorry my bad, I can't be thankful enough for your assistance.

Re: Sysdate to iso8601

Kurt_Bremser — Thu, 18 Nov 2021 09:26:57 GMT

Support the SASWare Ballot Idea I just posted 🙂