topic Re: Multiple conditions in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-conditions/m-p/355277#M23385 <PRE>data want; set have; if (status eq 1 and flag eq 0) or (status eq 2 and flag eq 1); run; </PRE> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Tue, 02 May 2017 15:06:26 GMT art297 2017-05-02T15:06:26Z Multiple conditions https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-conditions/m-p/355274#M23384 <P>Hi everyone,</P><P>&nbsp;</P><P>I've the following dataset which i would like to subset. I want to only keep observations with Status 1 and Flag 0 &amp; Status 2 and Flag 1.</P><P>The questions sounds quite easy but i'm quite new in sas programming. Any kind of help will be welcomed; <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Status</TD><TD>flag</TD><TD>Code</TD><TD>Prog</TD></TR><TR><TD>1</TD><TD>0</TD><TD>B1</TD><TD>P1</TD></TR><TR><TD>1</TD><TD>0</TD><TD>B2</TD><TD>P2</TD></TR><TR><TD>1</TD><TD>0</TD><TD>B2</TD><TD>P2</TD></TR><TR><TD>1</TD><TD>0</TD><TD>A1</TD><TD>Q1</TD></TR><TR><TD>1</TD><TD>2</TD><TD>A2</TD><TD>Q2</TD></TR><TR><TD>1</TD><TD>2</TD><TD>A3</TD><TD>Q3</TD></TR><TR><TD>2</TD><TD>0</TD><TD>D1</TD><TD>P3</TD></TR><TR><TD>2</TD><TD>0</TD><TD>D1</TD><TD>P3</TD></TR><TR><TD>2</TD><TD>1</TD><TD>C1</TD><TD>Q4</TD></TR><TR><TD>2</TD><TD>1</TD><TD>C1</TD><TD>Q4</TD></TR></TBODY></TABLE> Tue, 02 May 2017 15:00:09 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-conditions/m-p/355274#M23384 adil256 2017-05-02T15:00:09Z Re: Multiple conditions https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-conditions/m-p/355277#M23385 <PRE>data want; set have; if (status eq 1 and flag eq 0) or (status eq 2 and flag eq 1); run; </PRE> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Tue, 02 May 2017 15:06:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-conditions/m-p/355277#M23385 art297 2017-05-02T15:06:26Z Re: Multiple conditions https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-conditions/m-p/355499#M23407 <P>Thank you very much. Have a good day.</P> Wed, 03 May 2017 07:24:09 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Multiple-conditions/m-p/355499#M23407 adil256 2017-05-03T07:24:09Z