Delete observations based on multiple conditions

monsterpie — Wed, 17 Feb 2021 02:08:47 GMT

Hi all,

I have a dataset with 100 binary variables (var1 - var100). I am trying to delete observations that meet the following criteria: were coded as 1 for var1 AND were coded as 0 across all other variables (var2-var100). I.e., if an observation was coded as 1 for var1 and for var2 it would NOT be deleted. if it was coded as 1 for var1 and 0 for all other variables, it would be deleted.

The following is the code I have tried thus far:

data winterd.wintert4B;
set winterd.winter_t4;
if var1=1 and (var2--var100)=0 then delete;
run;

Also please note, my variables are not actually sequentially named/ordered, "var1-100" is just for the purposes of this post.

Re: Delete observations based on multiple conditions

SASKiwi — Wed, 17 Feb 2021 02:10:52 GMT

Try this:

data winterd.wintert4B;
set winterd.winter_t4;
if var1=1 and sum(of var2-var100)=0 then delete;
run;

Re: Delete observations based on multiple conditions

monsterpie — Wed, 17 Feb 2021 03:00:51 GMT

Thank you!!

topic Re: Delete observations based on multiple conditions in SAS Programming

Delete observations based on multiple conditions

Re: Delete observations based on multiple conditions

Re: Delete observations based on multiple conditions