Good afternoon.   I wonder if someone could provide some assistance with this? What I need is to compare groups of records to find the minimum value for each group and delete the record with the minimum value (easy). However, if the group hours are the same over the entire group I need to keep them all. In the example provided in record 9482 both records would need to be kept. For record 28552 only the record for week 1 should be deleted since 1 hour is less than all the other records for 28552 (therefore it's the minimum). Week 8 also has a minimum hours of 1 but only the first should be removed. Once a deletion over the group has been performed group checking ceases. For record group 30799 I would keep both.   I am using EG 7.15.   I would very much appreciate any help someone out there might be willing to provide.   Thanks. ... View more

Good afternoon.   I've posed this question before but can't seem to get a resolution to my dilemma. What I have is a list of locations with groups of caseload numbers within those locations. A caseload number can be repeated within a location a random number of times. What I need is a random selection of caseload numbers from within each location. Each location must have 11 total selections and each caseload must have at least one selection. So basically the strata are location and caseload and the n required are 11 and 1. I cannot figure out how to make this two step stratification selection.   If there a fewer than 11 selections in the location strata I need them all as long as I get one from each caseload. If there are more than 11 possible selections in the location strata I only need 11 total but 1 from each caseload. There are fewer than 11 caseloads in each location.   Can anyone assist me?   Thank you.   Code example: proc surveyselect data = have01 out = want01 selectall n = (11 1) method=srs; strata audit_location caseload; run; ... View more

Good afternoon.   Please see the example file at: https://communities.sas.com/t5/SAS-Procedures/Proc-Survey-Select-Stratified-Random-Sampling/m-p/441431/thread-id/69254   I'm hoping someone out there can help me with proc surveyselect. I have a dataset of multiple locations and within each location are multiple caseloads. What I need is to randomly select 1 case from each caseload to a maximum selection of 11 per audit location. If there are more caseloads than 11 in the audit location I just want a random selection of 11 even if that means not selecting a case from one caseload. If there are less than 11 caseloads for a location I need as many cases from each caseload to get to 11. I've read the documentation and read over the boards and some answers can just about get me there but not quite.   I am using Enterprise Guide version 7.15 HF2   Thank you for any help you can provide.   Here's one of the many iterations I've tried and a file attachment for practice   proc surveyselect data = have01 stats n = 1 out = want01 sampsize = 11 selectall;   /* method=sys*/ /* n=11;*/ /* control caseload;*/ strata audit_location caseload ; run; ... View more

Good afternoon. I'd be thankful for any help you might provide to me.   I have a date/time variable with 24-hour time as part of that. What I need to do is to not only strip out the time but to convert it to a simple number. So from 021318 14:30:00 I just need 143000. I can split out the date but each time I try to do the same with the time portion I get 14:30:00 (with special characters). I'd like them to be gone but I can't figure out a good way to do that.   Thank you very much.       start_time want 021318 14:30:00 143000 021318 13:10:00 131000 021318 13:30:00 133000 021318 13:37:00 133700 021318 15:30:00 153000 021318 15:30:00 153000 021318 18:30:00 183000 021318 19:00:00 190000 ... View more