https://communities.sas.com/t5/SAS-Procedures/select-range-of-time/m-p/17371#M3290 I have these fields in my table.The time_start runs from 01:00 thru 23:00 <BR /> ID<BR /> DATE START<BR /> TIME_START<BR /> <BR /> I need to select a time range between 8:00 AM thru 17:00 only how do I exclude the time that falls from this range?<BR /> Thanks For Your Assistance Fri, 25 Feb 2011 01:10:04 GMT BETO 2011-02-25T01:10:04Z https://communities.sas.com/t5/SAS-Procedures/select-range-of-time/m-p/17371#M3290 I have these fields in my table.The time_start runs from 01:00 thru 23:00 <BR /> ID<BR /> DATE START<BR /> TIME_START<BR /> <BR /> I need to select a time range between 8:00 AM thru 17:00 only how do I exclude the time that falls from this range?<BR /> Thanks For Your Assistance Fri, 25 Feb 2011 01:10:04 GMT https://communities.sas.com/t5/SAS-Procedures/select-range-of-time/m-p/17371#M3290 BETO 2011-02-25T01:10:04Z https://communities.sas.com/t5/SAS-Procedures/select-range-of-time/m-p/17372#M3291 Hi.<BR /> How about :<BR /> <BR /> <BR /> [pre]<BR /> data x;<BR /> input time time5.;<BR /> format time time5.;<BR /> cards;<BR /> 08:09<BR /> 10:21<BR /> 12:00<BR /> 23:22<BR /> ;run;<BR /> data _x;<BR /> set x;<BR /> where time between '10:11't and '14:20't;<BR /> run; <BR /> [/pre]<BR /> <BR /> <BR /> <BR /> Ksharp Fri, 25 Feb 2011 03:07:26 GMT https://communities.sas.com/t5/SAS-Procedures/select-range-of-time/m-p/17372#M3291 Ksharp 2011-02-25T03:07:26Z