How to use where if in data step?

[afiqcjohari]

	data want1;
		set have;
		where cPOSMode in ('07','90');
	run;
	data want2;
		set have;
		where cPOSMode in ('02') 
			and cToken is not null
			and cPvder is not null
			and idTReq is not null;
	run;
       
        data want1; set want1 want2;run;

How do I simplify above 3 data steps into 1?

[Reeza]

Combine WHERE clauses into 1 step using an OR

[afiqcjohari]

data want;
set have;
where cPOSMode in ('07','90') or (cPOSMode in ('02') and cToken is not null and cPvder is not null and idTReq is not null);
;run;

[Reeza]

---

@afiqcjohari wrote:
data want;
set have;
where cPOSMode in ('07','90') or (cPOSMode in ('02') and cToken is not null and cPvder is not null and idTReq is not null);
;run;

---

? 

[RW9]

data want;
  set have;
  if cposmode in ('07','90') or
     cposmode='02 and (ctoken ne "" and cpvder ne "" and idtreq ne "") then output;
run; 

Note, I assume the three varaibles are character as you don't say.  Also, use one casing for your code, mixing casing makes code harder to read.