topic Re: How to show observations based on a variables answer in SAS Procedures

How to show observations based on a variables answer

sammydouglas — Fri, 21 Apr 2017 03:40:21 GMT

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...

Re: How to show observations based on a variables answer

art297 — Fri, 21 Apr 2017 03:45:22 GMT

use:

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

Art, CEO, AnalystFinder.com

Re: How to show observations based on a variables answer

Jagadishkatam — Fri, 21 Apr 2017 03:46:50 GMT

Please try

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

Re: How to show observations based on a variables answer

sammydouglas — Fri, 21 Apr 2017 03:47:48 GMT

Thank you so much it worked! 🙂

Re: How to show observations based on a variables answer

sammydouglas — Fri, 21 Apr 2017 03:48:10 GMT

thank you that worked! 🙂