topic Add columns up to a specified maximum value in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Add-columns-up-to-a-specified-maximum-value/m-p/184495#M46919 <HTML><HEAD></HEAD><BODY><P>I am trying to add 3 columns of data in a table:</P><P></P><P>VAR_1 IND_1 IND_2</P><P></P><P>new_VAR = VAR_1 + IND_1 + IND_2&nbsp; -&gt; MAX of 30</P><P></P><P>The two indicator variables two have 0,1 values, the first variable has a value from 0 to 30.&nbsp; 30 is the maximum result I want.&nbsp; How can I "neatly" add these three columns such that no resulting value is above 30? I am open to SAS SQL procedures.&nbsp; 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.&nbsp; Thanks in advance. </P></BODY></HTML> Wed, 03 Sep 2014 18:25:55 GMT EricinVA 2014-09-03T18:25:55Z Add columns up to a specified maximum value https://communities.sas.com/t5/SAS-Procedures/Add-columns-up-to-a-specified-maximum-value/m-p/184495#M46919 <HTML><HEAD></HEAD><BODY><P>I am trying to add 3 columns of data in a table:</P><P></P><P>VAR_1 IND_1 IND_2</P><P></P><P>new_VAR = VAR_1 + IND_1 + IND_2&nbsp; -&gt; MAX of 30</P><P></P><P>The two indicator variables two have 0,1 values, the first variable has a value from 0 to 30.&nbsp; 30 is the maximum result I want.&nbsp; How can I "neatly" add these three columns such that no resulting value is above 30? I am open to SAS SQL procedures.&nbsp; 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.&nbsp; Thanks in advance. </P></BODY></HTML> Wed, 03 Sep 2014 18:25:55 GMT https://communities.sas.com/t5/SAS-Procedures/Add-columns-up-to-a-specified-maximum-value/m-p/184495#M46919 EricinVA 2014-09-03T18:25:55Z Re: Add columns up to a specified maximum value https://communities.sas.com/t5/SAS-Procedures/Add-columns-up-to-a-specified-maximum-value/m-p/184496#M46920 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P><P>new_VAR = min(30, VAR_1 + IND_1 + IND_2);</P></BODY></HTML> Wed, 03 Sep 2014 18:31:40 GMT https://communities.sas.com/t5/SAS-Procedures/Add-columns-up-to-a-specified-maximum-value/m-p/184496#M46920 Rick_SAS 2014-09-03T18:31:40Z Re: Add columns up to a specified maximum value https://communities.sas.com/t5/SAS-Procedures/Add-columns-up-to-a-specified-maximum-value/m-p/184497#M46921 <HTML><HEAD></HEAD><BODY><P>That did the trick.&nbsp; Thank you</P></BODY></HTML> Wed, 03 Sep 2014 18:39:12 GMT https://communities.sas.com/t5/SAS-Procedures/Add-columns-up-to-a-specified-maximum-value/m-p/184497#M46921 EricinVA 2014-09-03T18:39:12Z