https://communities.sas.com/t5/SAS-Programming/Create-new-var-using-if-statement/m-p/285878#M58557 <P>Hi,</P><P>I want to create a new variable (newvar) based on conditional logic see below - i know this would be easy but I need help.</P><P>&nbsp;</P><P>have:</P><P>var1 &nbsp;var2 &nbsp; var3 &nbsp; <STRONG>var4</STRONG> &nbsp;<STRONG>var5</STRONG>&nbsp; var6 &nbsp;</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; d&nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;b&nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P>&nbsp;</P><P>want:</P><P>var1 &nbsp;var2 &nbsp; var3 &nbsp; <STRONG>var4</STRONG> &nbsp;<STRONG>var5</STRONG>&nbsp; var6 &nbsp;newvar</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(if var4 or var5 =a and var1 or var2 =1 then newvar=1)</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;0&nbsp;</SPAN></P><P><SPAN>0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; d&nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;0</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;b&nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;</SPAN></P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>thanks</P> Wed, 20 Jul 2016 17:06:33 GMT AZIQ1 2016-07-20T17:06:33Z https://communities.sas.com/t5/SAS-Programming/Create-new-var-using-if-statement/m-p/285886#M58542 <DIV class="lia-quilt-column lia-quilt-column-04 lia-quilt-column-left lia-quilt-column-main-left"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"><DIV class="lia-message-author lia-component-author"><DIV class="lia-message-author-post-count">Posts: 43</DIV><DIV class="lia-message-author-ipaddress">&nbsp;</DIV></DIV></DIV></DIV><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-right lia-quilt-column-main-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-message-heading lia-component-message-header"><DIV class="lia-quilt-row lia-quilt-row-standard"><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-left"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"><DIV class="lia-message-subject">Create new variable based on if statement</DIV></DIV></DIV><DIV class="lia-quilt-column lia-quilt-column-04 lia-quilt-column-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-message-options"><DIV class="lia-menu-navigation-wrapper lia-menu-action message-menu"><DIV class="lia-menu-navigation"><DIV class="dropdown-default-item"><A title="Show option menu" href="https://communities.sas.com/t5/SAS-Data-Management/Create-new-variable-based-on-if-statement/m-p/285883" target="_blank">Options</A><DIV class="dropdown-positioning">&nbsp;</DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV><P class="lia-message-dates lia-message-post-date lia-component-post-date-last-edited"><SPAN class="DateTime lia-message-posted-on lia-component-common-widget-date"><SPAN class="local-friendly-date">2 seconds ago</SPAN></SPAN></P><DIV class="lia-message-body"><DIV class="lia-message-body-content"><P>Hi,</P><P>I want to create a new variable (newvar) based on conditional logic see below - i know this would be easy but I need help.</P><P>&nbsp;</P><P>have:</P><P>var1 &nbsp;var2 &nbsp; var3 &nbsp; <STRONG>var4</STRONG> &nbsp;<STRONG>var5</STRONG>&nbsp; var6 &nbsp;</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; d&nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;b&nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P>&nbsp;</P><P>want:</P><P>var1 &nbsp;var2 &nbsp; var3 &nbsp; <STRONG>var4</STRONG> &nbsp;<STRONG>var5</STRONG>&nbsp; var6 &nbsp;newvar</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(if var4 or var5 =a and var1 or var2 =1 then newvar=1)</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;0&nbsp;</SPAN></P><P><SPAN>0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; d&nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;0</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;b&nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;</SPAN></P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>thanks</P></DIV></DIV></DIV></DIV> Wed, 20 Jul 2016 17:10:49 GMT https://communities.sas.com/t5/SAS-Programming/Create-new-var-using-if-statement/m-p/285886#M58542 AZIQ1 2016-07-20T17:10:49Z https://communities.sas.com/t5/SAS-Programming/Create-new-var-using-if-statement/m-p/285878#M58557 <P>Hi,</P><P>I want to create a new variable (newvar) based on conditional logic see below - i know this would be easy but I need help.</P><P>&nbsp;</P><P>have:</P><P>var1 &nbsp;var2 &nbsp; var3 &nbsp; <STRONG>var4</STRONG> &nbsp;<STRONG>var5</STRONG>&nbsp; var6 &nbsp;</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; d&nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;b&nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P>&nbsp;</P><P>want:</P><P>var1 &nbsp;var2 &nbsp; var3 &nbsp; <STRONG>var4</STRONG> &nbsp;<STRONG>var5</STRONG>&nbsp; var6 &nbsp;newvar</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(if var4 or var5 =a and var1 or var2 =1 then newvar=1)</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;0&nbsp;</SPAN></P><P><SPAN>0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; d&nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;0</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;b&nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;</SPAN></P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>thanks</P> Wed, 20 Jul 2016 17:06:33 GMT https://communities.sas.com/t5/SAS-Programming/Create-new-var-using-if-statement/m-p/285878#M58557 AZIQ1 2016-07-20T17:06:33Z https://communities.sas.com/t5/SAS-Programming/Create-new-var-using-if-statement/m-p/285883#M58560 <P>Hi,</P><P>I want to create a new variable (newvar) based on conditional logic see below - i know this would be easy but I need help.</P><P>&nbsp;</P><P>have:</P><P>var1 &nbsp;var2 &nbsp; var3 &nbsp; <STRONG>var4</STRONG> &nbsp;<STRONG>var5</STRONG>&nbsp; var6 &nbsp;</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; d&nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;b&nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P>&nbsp;</P><P>want:</P><P>var1 &nbsp;var2 &nbsp; var3 &nbsp; <STRONG>var4</STRONG> &nbsp;<STRONG>var5</STRONG>&nbsp; var6 &nbsp;newvar</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(if var4 or var5 =a and var1 or var2 =1 then newvar=1)</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;0&nbsp;</SPAN></P><P><SPAN>0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; d&nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;0</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN></P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;b&nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;</SPAN></P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>thanks</P> Wed, 20 Jul 2016 17:09:08 GMT https://communities.sas.com/t5/SAS-Programming/Create-new-var-using-if-statement/m-p/285883#M58560 AZIQ1 2016-07-20T17:09:08Z https://communities.sas.com/t5/SAS-Programming/Create-new-var-using-if-statement/m-p/285890#M58543 <P>Your stated logic:</P> <P><SPAN>(if var4 or var5 =a and var1 or var2 =1 then newvar=1)</SPAN></P> <P>&nbsp;</P> <P><SPAN>SAS code:</SPAN></P> <PRE><CODE class=" language-sas">if (var4='a' or var5 ='a') and (var1=1 or var2 =1) then newvar=1;</CODE></PRE> Wed, 20 Jul 2016 17:13:02 GMT https://communities.sas.com/t5/SAS-Programming/Create-new-var-using-if-statement/m-p/285890#M58543 Reeza 2016-07-20T17:13:02Z