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.
Is this what you want?
new_VAR = min(30, VAR_1 + IND_1 + IND_2);
That did the trick. Thank you
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.