https://communities.sas.com/t5/SAS-Programming/filtering-output-data/m-p/618029#M181233 <PRE>where not (user_type = 'user' and amount &gt; 0);</PRE> Fri, 17 Jan 2020 09:41:10 GMT SASKiwi 2020-01-17T09:41:10Z https://communities.sas.com/t5/SAS-Programming/filtering-output-data/m-p/618024#M181230 <P>Hi I need help with below, i need to use proc sql to exclude rows where ('user_type' =user AND amount &gt; 0 )</P><P>&nbsp;</P><P>DATA HAVE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATA WANT</P><P>&nbsp;</P><P>user_type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; amount&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;user_type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;amount</P><P>&nbsp;</P><P><FONT color="#FF0000">user&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500&nbsp; &nbsp; &nbsp; &nbsp;</FONT> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;system&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200</P><P>system&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;user&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-300</P><P>user&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; system&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -300</P><P>system&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-300</P><P><FONT color="#FF0000">user&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000</FONT></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 17 Jan 2020 09:05:37 GMT https://communities.sas.com/t5/SAS-Programming/filtering-output-data/m-p/618024#M181230 Solly7 2020-01-17T09:05:37Z https://communities.sas.com/t5/SAS-Programming/filtering-output-data/m-p/618029#M181233 <PRE>where not (user_type = 'user' and amount &gt; 0);</PRE> Fri, 17 Jan 2020 09:41:10 GMT https://communities.sas.com/t5/SAS-Programming/filtering-output-data/m-p/618029#M181233 SASKiwi 2020-01-17T09:41:10Z https://communities.sas.com/t5/SAS-Programming/filtering-output-data/m-p/618050#M181243 <P>Thank you</P> Fri, 17 Jan 2020 11:10:35 GMT https://communities.sas.com/t5/SAS-Programming/filtering-output-data/m-p/618050#M181243 Solly7 2020-01-17T11:10:35Z