topic Re: format time to show business hours or after hours in SAS Procedures

format time to show business hours or after hours

Beto16 — Sun, 29 May 2016 17:07:39 GMT

Hi I have a table that has a datetime field and the ask came in if there was a way to determine if it was after hr or during business hrs ...
Here is example

Id. Date time
A. 26 may 2016 11:53:00
C. 27may. 2016 06:00:00

Here is what I need
Id. Date time. Business
A. 26 may 2016 11:53:00. AFTER
C. 27may. 2016 06:00:00. DURING

Our business hrs start from 8 Am to 9 pm
7 days a week
Thanks for the assistance

Re: format time to show business hours or after hours

Reeza — Mon, 30 May 2016 00:55:50 GMT

Use TIMEPART() to get the time portion of your date time, and then format it with a custom format.

proc format;
value business_hours_fmt
0 - < 28800, 75600 <- 86400 = "Outside"
28800 - 75600 = "Business Hours";
run;

/*Sample data*/
data want;
do time=3600 to 86400 by 3600;
i=time;
business_hours = put(time, business_hours_fmt.);
format time time.;
output;
end;
run;


data sample;
set have;
business_hours = put(datepart(datetime), business_hours_fmt.);
run;

Re: format time to show business hours or after hours

Beto16 — Mon, 30 May 2016 15:28:58 GMT

Thank you

Re: format time to show business hours or after hours

Beto16 — Mon, 30 May 2016 16:30:05 GMT

Got it to work thanks again I learn something new today