How to show observations based on a variables answer

[sammydouglas]

Wow I had a really hard time describing my question but basically I have a variable called Order_type_label which can either be Web, Instore, or Catalogue and I need to create a data set that only contains records where Order_type_label is either Web or Catalogue.

Here's what i have for now: 

data quick;

set orders;
where Order_Type_Label eq "Web" OR "Catalogue";
run;

I keep getting this note and the output just shows all the observations. 

NOTE: There were 490 observations read from the data set WORK.ORDERS.
WHERE 1 /* an obviously TRUE WHERE clause */ ;

What am I doing wrong? When I use AND instead of OR it also obviously doesnt work... 

[art297 · Accepted solution]

use:

where Order_Type_Label in ("Web", "Catalogue");

Art, CEO, AnalystFinder.com

[sammydouglas]

Thank you so much it worked! 🙂

[Jagadishkatam]

Please try

data quick;
set orders;
where Order_Type_Label in ( "Web" "Catalogue");
run;

[sammydouglas]

thank you that worked! 🙂