https://communities.sas.com/t5/SAS-Programming/Deleting-observations/m-p/568729#M160160 <PRE><CODE class=" language-sas">where variable not in ('Admin','Unknown');</CODE></PRE> <P>or as a dataset where condition, in a subsetting if, or as a SQL where condition.</P> Tue, 25 Jun 2019 13:03:51 GMT Kurt_Bremser 2019-06-25T13:03:51Z https://communities.sas.com/t5/SAS-Programming/Deleting-observations/m-p/568725#M160158 <P>Hi,</P><P>&nbsp;</P><P>One of the variable I am using in my analysis have the following values; Admin, Unknown, GP, Nurse.</P><P>&nbsp;</P><P>I want to delete observations where the values for this variable are 'Admin' and 'Unknown' and keep the other two.</P><P>&nbsp;</P><P>How do I write the code please?</P><P>&nbsp;</P><P>Thanks</P><P>S</P> Tue, 25 Jun 2019 12:39:54 GMT https://communities.sas.com/t5/SAS-Programming/Deleting-observations/m-p/568725#M160158 sks521 2019-06-25T12:39:54Z https://communities.sas.com/t5/SAS-Programming/Deleting-observations/m-p/568729#M160160 <PRE><CODE class=" language-sas">where variable not in ('Admin','Unknown');</CODE></PRE> <P>or as a dataset where condition, in a subsetting if, or as a SQL where condition.</P> Tue, 25 Jun 2019 13:03:51 GMT https://communities.sas.com/t5/SAS-Programming/Deleting-observations/m-p/568729#M160160 Kurt_Bremser 2019-06-25T13:03:51Z