topic Re: Exclude using a combination of variables in SAS Procedures

Exclude using a combination of variables

markjc — Mon, 22 Nov 2010 17:13:49 GMT

I’m trying to select records based on a variable (Style) but I also want to exclude some of those records based on 2 other variables.
From my test data, I would like all style 104 except those with CD = ‘A’ and Num = 12.
Desired results ID 4,5,6,7

data LIST;
input ID Style CD $ NUM;
datalines;
1 102 A 12
2 102 C 14
3 104 A 12
4 104 A 13
5 104 B 14
6 104 B 12
7 104 C 12
;
run;

PROC PRINT DATA = LIST noobs;
where style = 104 and (cd ne 'A' and num ne 12);
RUN;
/* only returning ID 5 */

Re: Exclude using a combination of variables

Reeza — Mon, 22 Nov 2010 17:17:36 GMT

Need an "OR" not "AND" in the where statement.

data LIST;
input ID Style CD $ NUM;
datalines;
1 102 A 12
2 102 C 14
3 104 A 12
4 104 A 13
5 104 B 14
6 104 B 12
7 104 C 12
;
run;

PROC PRINT DATA = LIST noobs;
where style = 104 and (cd ne 'A' OR num ne 12);
RUN;

Re: Exclude using a combination of variables

markjc — Mon, 22 Nov 2010 17:54:25 GMT

Thank you!
Using the OR with a not equal makes sense but I wasn't seeing it because I kept thinking you need to be 'A' and 12.