I have the following data set resp: PatientID RespRate1 RespRate2 .... RespRate20 XYZ 16 18 17 ACW 21 17 21 For each row (PatientID) I want to be able to obtain the min, max, mean, and std of the first 10 respiratory rates, then the next ten respiratory rates. I wanted to do this: data resp; set resp; min1 = min(of RespRate1-RespRate10); max1 = min(of RespRate1-RespRate10); mean1 = min(of RespRate1-RespRate10); std1 = min(of RespRate1-RespRate10); min2 = min(of RespRate11-RespRate12); max2 = min(of RespRate11-RespRate20); mean2 = min(of RespRate11-RespRate20); std2 = min(of RespRate11-RespRate20); run; Yet the min, max, mean, and std functions don't work unless you list out all of the variables, i.e. min1 = min(RespRate1, RespRate2, RespRate3.... RespRate10). Any ideas on how to do this in Base SAS (I dont want to go over to IML in this instance).
... View more