SAS filtering using where statement

Art001_SASst004.sas

/* Filter on one condition */
data my_new_ds;
  set my_ds;
where Col_A>=6;
run;

/* Filter on multiple conditions using AND */
data my_ds;
  set my_ds;
where Col_A>=6 and Col_B=5;
run;

/* Filter on multiple conditions using OR */
data my_ds;
  set my_ds;
where Col_A>=6 or Col_B=1;
run;

/* Filter on multiple conditions */
data my_ds;
  set my_ds;
where fruit in ('1.apple', '3.pear');
run;