Date Range SAS

[This widget could not be displayed.]

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]

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

or

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

[This widget could not be displayed.]

Im trying to replicate what is in excel as a formula

R3 = TPR

K3 = Deal_Int_Rate_pc

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

[RW9]

So:

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

              else k3_variable end as RESULT

[PGStats]

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

PG

[This widget could not be displayed.]

Thanks, works fine now.