Help using Base SAS procedures

format time to show business hours or after hours

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

format time to show business hours or after hours

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

Accepted Solutions
Solution
‎05-30-2016 11:29 AM
Super User
Posts: 19,850

Re: format time to show business hours or after hours

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;

View solution in original post


All Replies
Solution
‎05-30-2016 11:29 AM
Super User
Posts: 19,850

Re: format time to show business hours or after hours

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;
Frequent Contributor
Posts: 80

Re: format time to show business hours or after hours

Thank you
Frequent Contributor
Posts: 80

Re: format time to show business hours or after hours

Got it to work thanks again I learn something new today
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 2074 views
  • 4 likes
  • 2 in conversation