Where Statement Subsetting Issue

MikeXue — Mon, 13 Dec 2021 15:52:22 GMT

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

Re: Where Statement Subsetting Issue

ballardw — Mon, 13 Dec 2021 16:30:33 GMT

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

topic Where Statement Subsetting Issue in SAS Programming

Where Statement Subsetting Issue

Re: Where Statement Subsetting Issue