topic Re: Another way to reflect "Between" in dataset? in SAS Procedures

Another way to reflect "Between" in dataset?

omega1983 — Mon, 29 Apr 2013 14:27:19 GMT

data DSM2;

set DSM1;

Orig = &pbd_date-LN_FST_DUE_DT;

DPD = &pbd_date-LN_NXT_PMT_DUE_DT;

if DPD >=90 and DPD <=720;

if Orig >365;

run;

notice the

if DPD >=90 and DPD <=720;

I believe there is another way to reflect in between? Something like 90<=DPD<=720

Re: Another way to reflect "Between" in dataset?

Anotherdream — Mon, 29 Apr 2013 14:45:33 GMT

proc sql;

create table DSM2 as

select &pbd_date-LN_FST_DUE_DT as Orig

,&pbd_date-LN_NXT_PMT_DUE_DT as DPD

from DSM1

where (&pbd_date-LN_NXT_PMT_DUE_DT) between 90 and 720 AND

(&pbd_date-LN_FST_DUE_DT) > 365;

quit;

run;

There ya go

Re: Another way to reflect "Between" in dataset?

Haikuo — Mon, 29 Apr 2013 14:47:50 GMT

Exactly, have you tried it:

if 90<=DPD<=720;

Haikuo

Re: Another way to reflect "Between" in dataset?

Reeza — Mon, 29 Apr 2013 16:15:40 GMT

Except that won't work in macro code in certain circumstances, so be careful where you use it.

Re: Another way to reflect "Between" in dataset?

Anotherdream — Mon, 29 Apr 2013 16:18:05 GMT

I actually had this exact issue Reeze, and that is why I moved to running the proc sql version that I originally suggested. I have not run into the proc sql having any issues in any of the macro coding that I have used thus far.

IF anyone thinks it would cause problems please say so!

Brandon

Re: Another way to reflect "Between" in dataset?

Haikuo — Mon, 29 Apr 2013 16:23:25 GMT

Thanks, Fareeza, good to know. It would be helpful if someone could elaborate more details on the errors when using this in Macro.

Haikuo

Re: Another way to reflect "Between" in dataset?

Haikuo — Wed, 01 May 2013 13:37:10 GMT

FWIW, Finally I bumped into something from SAS-L regarding this matter:

Quote from one of Lassen's recent posts:

as the macro language interpreter evaluates it like this

1<0<2 -> (1<0)<2 -> 0<2 -> 1

Which means macro language evaluates expressions in a segmental pattern, not as a whole. It is not necessarily causing error message, it just interprets it differently, therefore leads to unexpected results. So as long as you know know how exactly it works, you can still use it in Macro language.

Haikuo