topic Re: Date Range SAS in SAS Programming

Date Range SAS

anonymous_user — Tue, 28 Jul 2015 14:17:10 GMT

Hi I need to write some code in order to create the logic below within the case statement.

Im not sure how the date coding works so any help would be appreciated?

proc sql;

create table rate as

select *,

case

when Value_Date < today()-365 then tpr, Deal_Int_Rate_pc else 0 end as rate

from adjusted_movement;

quit;

RW9 — Tue, 28 Jul 2015 14:35:35 GMT

Hi,

You might want to investigate base SAS coding, these are fundamental questions you will need for most coding efforts:

proc sql;

create table rate as

select *,

case when Value_Date < today()-365 then Deal_Int_Rate_pc

else 0 end as rate

from adjusted_movement;

quit;

DOnt know what your trying to acheive with the tpr bit? Maybe you need another when clause. Case is:

case <condition> when <result> then <value> else <value> end

case when <condition> then <value> else <value> end

anonymous_user — Tue, 28 Jul 2015 14:51:05 GMT

Im trying to replicate what is in excel as a formula

R3 = TPR

K3 = Deal_Int_Rate_pc

=IF(H2<(TODAY()-365),R3,K3)

PGStats — Tue, 28 Jul 2015 14:55:02 GMT

There should be a single name or expression in each clause of the case expression

case

when Value_Date < today()-365 then tpr else Deal_Int_Rate_pc end as rate

anonymous_user — Tue, 28 Jul 2015 15:07:03 GMT

Thanks, works fine now.

RW9 — Tue, 28 Jul 2015 15:20:25 GMT

So:

case when h2_variable < (today()-365) then r3_variable

else k3_variable end as RESULT