Hello, I have a data set with 6 variables: ID, IR00, IR10, IR20, IR30, IR40. ID is an 8 digit numeric ID. IR00 through IR40 are each continous variable from 0 to 1. I need to find the min and max for each ID across the IR00 to IR40 variables. The min has to be above 0. I have found the max using: data new; set old; MAX_IR = max(of IR00 - IR40) ; output; keep ID IR00 IR10 IR20 IR30 IR40 MAX_IR; run; But I cannot figure out how to find the min value above zero. Any help would be appreciated.
... View more