Where Statement Subsetting Issue

[MikeXue]

Hello, 

I have an issue with my data sub setting. I want to keep records of subjects who are not Black or African American Screen Failures subjects. 

I used the following code: 

data adsl2;
set adsl;
where RACE ne "BLACK OR AFRICAN AMERICAN" and ARM ne "Screen Failure";
run;

However, for when I use this code it will only keep subjects who are not Black or African American and subjects who are not Screen Failures. How do I modify the code so that only Black Screen Failure subjects are dropped from the dataset? 

Thanks,

Michael 

[ballardw]

Perhaps

data adsl2;
   set adsl;
   where not( RACE = "BLACK OR AFRICAN AMERICAN" and ARM = "Screen Failure");
run;

no data example means code cannot be tested.

Another way

data adsl2;
   set adsl;
   IF  RACE = "BLACK OR AFRICAN AMERICAN" and ARM = "Screen Failure" then delete;
run;

---

@MikeXue wrote:

Hello, 

I have an issue with my data sub setting. I want to keep records of subjects who are not Black or African American Screen Failures subjects. 

I used the following code: 

data adsl2;
set adsl;
where RACE ne "BLACK OR AFRICAN AMERICAN" and ARM ne "Screen Failure";
run;

However, for when I use this code it will only keep subjects who are not Black or African American and subjects who are not Screen Failures. How do I modify the code so that only Black Screen Failure subjects are dropped from the dataset? 

Thanks,

Michael 

---