About LK357

LK357 · ‎07-14-2016

Excellent thanks this works great

LK357 · ‎07-14-2016

Excellent thank you!

LK357 · ‎07-14-2016

Thanks @Reeza that works and allows me to sort but is there a way of showing it in a format that is easy to understand ie 10:00AM and not 36000

LK357 · ‎07-14-2016

Hi yes and I have managed to get that but it is in a char format so when I sort by it, it's not sorting correctly... ie I need 7:30am before 12.30pm etc

LK357 · ‎07-14-2016

The date sits in a separate text field September 1, 2015

LK357 · ‎07-14-2016

Hi there I am trying to convert this text so I can use the time element in SAS.? 12:30PM:Tuesday:Weekday 7:30AM:Tuesday:Weekday 6:60AM:Saturday:Weekend currently stored as CHAR $25 I have managed to extract the time by doing the following but it is still text so cant use to sort by time time= Substr(text_,1,index(text_,"M:")); How can I then convert to a SAS format thanks

LK357 · ‎07-14-2016

Hi there, Is there a similar solution to extract the time from this text var format $25. 12:30PM:Friday:Weekday

LK357 · ‎07-14-2016

Thank you for this it works fine and is a lot simpler!.

LK357 · ‎07-13-2016

Thanks for the response but im getting the following error... sas_date = input(date, worddate18.); ----------- 48 ERROR 48-59: The informat WORDDATE was not found or could not be loaded

LK357 · ‎07-13-2016

Hi how can I convert this text to a date I can use in SAS.? April 1, 2016 currently stored as CHAR $18 thanks

LK357 · ‎07-07-2016

Excellent thanks for the reply!

LK357 · ‎06-28-2016

Hi I am tring to extract the number following the id= from within this string below http://www.blahblah/blahblah/confirmation?id=1234567&media=12345

Online Status	Offline
Date Last Visited	‎02-27-2023 06:32 PM

Re: Time Formats from Text

Re: Time Formats from Text

Re: Time Formats from Text

Re: Time Formats from Text

Re: Time Formats from Text

Time Formats from Text

Re: Text dates to a Sas date

Re: Text dates to a Sas date

Re: Text dates to a Sas date

Text dates to a Sas date

Re: Time Formats from Text

Re: Time Formats from Text

Re: Time Formats from Text

Re: Text dates to a Sas date

Re: Text dates to a Sas date

Re: Time Formats from Text

Re: Time Formats from Text

Re: Time Formats from Text

Re: Time Formats from Text

Re: Time Formats from Text

Time Formats from Text

Re: Text dates to a Sas date

Re: Text dates to a Sas date

Re: Text dates to a Sas date

Text dates to a Sas date

Re: Extract within a string

Extract within a string

SAS Analytics Explorers