https://communities.sas.com/t5/New-SAS-User/NOT-IN-in-PROC-FEDSQL/m-p/786682#M32228 <P>Not sure what you are asking.</P> <P>Did you try just spelling it out.</P> <PRE><CODE class=" language-sas">where not (varname in ('a','b','c'))</CODE></PRE> Mon, 20 Dec 2021 02:07:34 GMT Tom 2021-12-20T02:07:34Z https://communities.sas.com/t5/New-SAS-User/NOT-IN-in-PROC-FEDSQL/m-p/786633#M32226 <P>Hi, I am a new SAS VIYA user. Is there any alternative method in proc fedsql that performs the same operation as 'not in' method in SQL? Thank you!</P> Mon, 20 Dec 2021 07:35:44 GMT https://communities.sas.com/t5/New-SAS-User/NOT-IN-in-PROC-FEDSQL/m-p/786633#M32226 jayvisw11 2021-12-20T07:35:44Z https://communities.sas.com/t5/New-SAS-User/NOT-IN-in-PROC-FEDSQL/m-p/786636#M32227 Can you post your SQL code ? Sun, 19 Dec 2021 10:11:05 GMT https://communities.sas.com/t5/New-SAS-User/NOT-IN-in-PROC-FEDSQL/m-p/786636#M32227 Ksharp 2021-12-19T10:11:05Z https://communities.sas.com/t5/New-SAS-User/NOT-IN-in-PROC-FEDSQL/m-p/786682#M32228 <P>Not sure what you are asking.</P> <P>Did you try just spelling it out.</P> <PRE><CODE class=" language-sas">where not (varname in ('a','b','c'))</CODE></PRE> Mon, 20 Dec 2021 02:07:34 GMT https://communities.sas.com/t5/New-SAS-User/NOT-IN-in-PROC-FEDSQL/m-p/786682#M32228 Tom 2021-12-20T02:07:34Z