topic Re: How to factor the conditions with and or? in SAS Programming

How to factor the conditions with and or?

afiqcjohari — Fri, 17 Mar 2017 03:04:49 GMT

data want;
	set have;
	where dTran >= '01JAN2017'd
		and dTran <= '31JAN2017'd 
		and cPOSMode in ('07') 
	    or (dTran >= '01JAN2017'd
	        and dTran <= '31JAN2017'd 
                and cPOSMode in ('90','02') 
	        and cToken is not null 
		and cPvder is not null 
		and idTReq is not null);
run;

Is it possible to simplify the conditions by factoring out the dates?

Re: How to factor the conditions with and or?

PGStats — Fri, 17 Mar 2017 03:14:36 GMT

Logical algebra:

A and B or A and C is equivalent to A and (B or C)

Re: How to factor the conditions with and or?

afiqcjohari — Fri, 17 Mar 2017 03:54:33 GMT

data want;
	set have;
	where dTran >= '01JAN2017'd and dTran <= '31JAN2017'd 
		and (cPOSMode in ('07') 
		     or (cPOSMode in ('90','02') 
	             and cToken is not null 
		         and cPvder is not null 
		         and idTReq is not null));
run;

Hurm not sure whether it looks more readable.

Re: How to factor the conditions with and or?

PGStats — Fri, 17 Mar 2017 04:08:59 GMT

Maybe

data want;
	set have;
	where dTran between '01JAN2017'd and '31JAN2017'd 
		and ( cPOSMode in ('07') 
		     or (cPOSMode in ('90','02') 
	             and cmiss(cToken, cPvder, idTReq) = 0) );
run;

/* Or */

data want;
	set have;
	where year(dTran) = 2017 
		and ( cPOSMode in ('07') 
		     or (cPOSMode in ('90','02') 
	             and cmiss(cToken, cPvder, idTReq) = 0) );
run;

Re: How to factor the conditions with and or?

afiqcjohari — Fri, 17 Mar 2017 07:32:36 GMT

That cmiss function does help! Thank you PG!

Re: How to factor the conditions with and or?

afiqcjohari — Tue, 21 Mar 2017 02:04:29 GMT

cmiss routine not found. Is it not part of SAS base or something?

Re: How to factor the conditions with and or?

PGStats — Tue, 21 Mar 2017 02:29:29 GMT

Looking at historical doc, cmiss was introduced in base SAS in version 9.2

In what context and with what version of SAS are you calling cmiss?

Re: How to factor the conditions with and or?

afiqcjohari — Tue, 21 Mar 2017 06:15:38 GMT

I just figured out that the server is running a 9.1 version while my desktop is on 9.3

This explains why I can run the function previously.