format time to show business hours or after hours

[Beto16]

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

[Reeza · Accepted solution]

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;

[Beto16]

Thank you

[Beto16]

Got it to work thanks again I learn something new today