topic Re: Case when for if clause in SAS Data Management

Case when for if clause

Babloo — Wed, 19 Sep 2018 11:35:51 GMT

Could you please guide me with the 'case when....' statement or other equivalents in order to align in expression in DI Studio for the following if clauses? I was advised not to use user written transformation. Objective is to create a new variable 'PODVER'

data have;
input renewal_date $ KNKATD;
datalines;
15jun 1
21sep 2
19sep 7
08jan 7
;
run;

data want (drop=current_date);
set have;
current_date=today();
format current_date date9.;
format new_renewal_date date9.;
if (input(cats(renewal_date,"2018"),date9.)<current_date) then new_renewal_date=input(cats(renewal_date,"2019"),date9.);
else new_renewal_date=input(cats(renewal_date,"2018"),date9.);
run;

data want_new;
set want;
format PODVER date9.;
if new_renewal_date='19sep2018'd and KNKATD=7 then PODVER=new_renewal_date+365;
else PODVER=new_renewal_date;
run;

Re: Case when for if clause

RW9 — Wed, 19 Sep 2018 11:48:48 GMT

Just going by the if statments, something like this should work:

case when renewal_date="19sep" then "19sep2019"d
     when input(cats(renewal_date,"2018"),date9.) < today() then input(cats(renewal_date,"2018"),date9.)
     else input(cats(renewal_date,"2019"),date9.) end

Its quite hard to tell however, as you use today() in a comparison which will obviously change from day to day, not sure what bearing that has on the code

Re: Case when for if clause

Babloo — Wed, 19 Sep 2018 12:49:58 GMT

You've not checked the condition for KNKATD=7.

Re: Case when for if clause

RW9 — Wed, 19 Sep 2018 12:57:28 GMT

Add it in then, you can copy paste directly the and.