About Reggiete

Reggiete · ‎12-14-2017

Thank you that worked! many thanks!

Reggiete · ‎12-14-2017

hey reeza, example of the date i am trying to convert '2015-12-14T12:00:29.3387979-05:00' input(submitdate, E8601Dz.) as date format=datetime20. i tried the above code and i get blanks

Reggiete · ‎12-14-2017

would this be correct I still get an error. input(date, informat=e8601dzw.d) as Date format=datetime20

Reggiete · ‎12-14-2017

hey, I found that page on a google search, but don't quite understand what I would need to do to convert from ISO8601 varchar to datetime22.9 format in SAS. using the above code.

Reggiete · ‎12-14-2017

Hello Everyone, I am new to sas and I am trying to convert a character string which is in ISO8601 to datetime format in sas. My code looks like this proc sql; Select appnum ,input(submitdate,datetime22.9) as Submitdate from test ;quit; submitdate is being pulled from an XML data source so its currently in varchar format Could any help me with converting the submitdate(which is in iso8601) to datetime? I am new and I only use proc sql; since I have a sql background and still very new to SAS.

Reggiete · ‎09-15-2017

Yes i would prefer sql since i have a entire statement i am running to create a table.

Reggiete · ‎09-15-2017

yes you are right the variable name is normally at the end but you can also put it in the beginning. the SQL code above was writen in SQL server. Basically what the line of sql is giving the max status for the max date so for example, below i would want to return the max status which is the record with the greatest date. Max status would be Completed. A Date Status Example 1/1/2017 Open Example 1/3/2017 Pending Example 1/4/2017 Completed

Reggiete · ‎09-15-2017

Hello, I am new to SAS. I am trying to write the below SQL script in SAS and wrap in Proc SQL FinalStatus = CAST(SUBSTRING(MAX(CAST(cl.DateNotesEntered AS BINARY(6)) + CAST(cl.CallResult AS VARBINARY(1000))), 7, 1000) AS VARCHAR(1000)), Any help on how this statement would be written in Proc SQL for SAS

Online Status	Offline
Date Last Visited	‎01-07-2018 09:26 PM

Re: Convert ISO8601 string to datetime format

Re: Convert ISO8601 string to datetime format

Re: Convert ISO8601 string to datetime format

Re: Convert ISO8601 string to datetime format

Convert ISO8601 string to datetime format

Re: SAS Proc SQL Help

Re: SAS Proc SQL Help

SAS Proc SQL Help

Re: Convert ISO8601 string to datetime format

Re: Convert ISO8601 string to datetime format

Re: Convert ISO8601 string to datetime format

Re: Convert ISO8601 string to datetime format

Re: Convert ISO8601 string to datetime format

Convert ISO8601 string to datetime format

Re: SAS Proc SQL Help

Re: SAS Proc SQL Help

SAS Proc SQL Help