Hello everyone, i want to find maximum values within a range and base on the maximum value creat a new column. Here as an example and my code, id zweck lead 1 4 284 1 6 54 1 7 0 1 5 -13 1 1 167 1 2 56 1 7 0 2 2 201 2 1 87 2 7 0 data Hz.y; set Hz.WegeketteP3lead; by lead; retain max_val; drop max_val; if lead ne 0 then max_val=lead; else do; max_val=max(maxval,lead); maxLead=max_val; end; if max_val then do zweckH=catx('-',zweck,7); end; run; what i want is to find the maximum value between the number before 0 and the maximum value stay just in the same row as orignal like following, at the meantime a new created column 'zweckH' will get the 'zweck' from the row of 'mal_val' and plus7 till 'zweck' is 7: id zweck lead max_val zweckH 1 4 284 284 4-7 1 6 54 0 4-7 1 7 0 0 4-7 1 5 -13 0 1-7 1 1 167 167 1-7 1 2 56 0 1-7 1 7 0 0 1-7 2 2 201 201 2-7 2 1 87 0 2-7 2 7 0 0 2-7
... View more