Hey guys, I am trying to query the min date and min time by multiple groups but no luck. Sample data LOC CAR DATE TIME A 123 5/10 02:35 A 123 5/10 13:45 B 123 5/12 04:45 B 123 5/15 00:35 B 124 5/10 15:55 C 123 5/17 12:00 C 124 5/11 05:30 C 124 5/12 18:00 I want the result dataset to show LOC CAR DATE TIME A 123 5/10 2:35 B 123 5/12 4:45 B 124 5/10 15:55 C 123 5/17 12:00 C 124 5/11 05:30 So I want the minimum date and time for each car at each location. I tried proc sql but over partition by function isn’t allowed and the min function isn’t giving me the desired output. Any help would be greatly appreciated! Thanks
... View more