topic Re: How to use where if in data step? in SAS Programming

How to use where if in data step?

afiqcjohari — Thu, 16 Mar 2017 07:24:34 GMT

	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?

Re: How to use where if in data step?

Reeza — Thu, 16 Mar 2017 07:28:16 GMT

Combine WHERE clauses into 1 step using an OR

Re: How to use where if in data step?

afiqcjohari — Thu, 16 Mar 2017 07:31:34 GMT

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;

Re: How to use where if in data step?

Reeza — Thu, 16 Mar 2017 07:47:32 GMT

@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;

Re: How to use where if in data step?

RW9 — Thu, 16 Mar 2017 09:27:55 GMT

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.