09-03-2014 02:25 PM
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.
Need further help from the community? Please ask a new question.