Help using Base SAS procedures

Exclude using a combination of variables

Reply
Occasional Contributor
Posts: 5

Exclude using a combination of variables

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 */
Super User
Posts: 19,772

Re: Exclude using a combination of variables

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;
Occasional Contributor
Posts: 5

Re: Exclude using a combination of variables

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.
Ask a Question
Discussion stats
  • 2 replies
  • 86 views
  • 0 likes
  • 2 in conversation