I am trying to add 3 columns of data in a table: VAR_1 IND_1 IND_2 new_VAR = VAR_1 + IND_1 + IND_2  -> MAX of 30 The two indicator variables two have 0,1 values, the first variable has a value from 0 to 30.  30 is the maximum result I want.  How can I "neatly" add these three columns such that no resulting value is above 30? I am open to SAS SQL procedures.  I know of a messy way by creating a very lengthy case statement and subtracting 30, but would prefer the use of a more concise method, such as a function, if one exists.  Thanks in advance. ... View more