topic Re: Time Formats from Text in SAS Procedures

Time Formats from Text

LK357 — Thu, 14 Jul 2016 12:36:08 GMT

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

Re: Time Formats from Text

GreggB — Thu, 14 Jul 2016 12:50:56 GMT

Your data needs a day, month and a year.

Re: Time Formats from Text

LK357 — Thu, 14 Jul 2016 13:01:17 GMT

The date sits in a separate text field

September 1, 2015

Re: Time Formats from Text

GreggB — Thu, 14 Jul 2016 13:03:20 GMT

Are you just wanting this?
12:30PM
7:30AM
.
.

Re: Time Formats from Text

GreggB — Thu, 14 Jul 2016 13:11:12 GMT

not elegant but it works.

data one;
informat time $25. ;
input time ;
cards;
12:30PM:Tuesday:Weekday
7:30AM:Tuesday:Weekday
6:60AM:Saturday:Weekend
;
run;
data want;
set one;
time2=scan(time,1,'M')||'M';
run;
proc print;
run;

Re: Time Formats from Text

Reeza — Thu, 14 Jul 2016 13:33:57 GMT

In general, the idea is the same as your earlier date question. Use input() with appropriate informat.

Assuming you've isolated the time portiom correctly it will be something like:

Time_sas = input(time, time.);

Re: Time Formats from Text

LK357 — Thu, 14 Jul 2016 13:43:58 GMT

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

Re: Time Formats from Text

LK357 — Thu, 14 Jul 2016 13:57:29 GMT

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

Re: Time Formats from Text

Reeza — Thu, 14 Jul 2016 14:20:17 GMT

Apply a format.

format time_sas time8.;

Re: Time Formats from Text

LK357 — Thu, 14 Jul 2016 14:44:17 GMT

Excellent thank you!

Re: Time Formats from Text

LK357 — Thu, 14 Jul 2016 15:00:36 GMT

Excellent thanks this works great