Selection des Lignes sauf ?(HELP)

Bonjour a tous,

J'essaye de selectionner tous le contenu d'une table sauf ceux qui sont inclus dans le condition mais je recois tjr la meme erreur

Des conseilles SVP ?

Mon Code :
proc sql;
CREATE TABLE Metropole_zero AS SELECT *
from ref2015.Rca_v5_geoloc
WHERE (amz_dep,amz_com) NOT IN (SELECT * from ref2015.Rca_v5_geoloc WHERE amz_dep="97" and (amz_com between "1%" and "5%") and amz_num="0000");
quit;

Erreur:
300 proc sql;
301 CREATE TABLE Metropole_zero AS SELECT *
302 from ref2015.Rca_v5_geoloc
303 WHERE (amz_dep,amz_com) NOT IN (SELECT * from ref2015.Rca_v5_geoloc WHERE amz_dep="97" and (amz_com between "1%" and
-
79
ERROR 79-322: Expecting a (.

303! WHERE (amz_dep,amz_com) NOT IN (SELECT * from ref2015.Rca_v5_geoloc WHERE amz_dep="97" and (amz_com between "1%" and
303! "5%") and amz_num="0000");
-
79
ERROR 79-322: Expecting a ).

304 quit;

Bonjour,

Pourquoi pas simplement :

Code:

---

1 2 3 4

proc sql; CREATE TABLE Metropole_zero AS SELECT * from Rca_v5_geoloc WHERE NOT (amz_dep="97" and (amz_com between "1%" and "5%") and amz_num="0000");

---

Cordialement,