Difference between day program runs and variable date in dataset.

[Sotarkadin]

I currently have a data set that shows dates different actions have happened.  I am trying to figure out the number of days since that date based on the day the program is ran.

open_dt, ocfr_dt, lwsi_dt, pcse_dt, pcna_dt, close_dt

I have a column that has the status based on which date is filled in.  Based on the status I need it to subtract that subsequent column from the date the pgroam is run.

I delcare the variable today at the top.

data _null_;
today=today();
call symput('today', put(today,date9.));
run;

and I wrote it like this but get a syntax error.

data fraud_ovrvw4;
set fraud_ovrvw3;
if frd_status = 'Support Requested' then updt_tm = (lwsi_dt - &today.);
run;

I am not sure the syntax to get updt_tm to tell me how many days between the column_name I want it to look and the day its ran.

[ChrisNZ]

Like this?

data fraud_ovrvw4;
  set fraud_ovrvw3;
  if frd_status = 'Support Requested' then updt_tm = (lwsi_dt - today() );
run;

[Sotarkadin]

That is what I tried the first time and the column updt_tm comes back blank.  Does it matter the format, as the date in the data set is ddmmmyyyy

[Reeza]

Did you get an error?

Format shouldn't matter, but the type does, is it a character or numeric variable?

[ChrisNZ]

The format doesn't matter. If it comes back missing then the input value is missing too.

[Kurt_Bremser]

Which type (numeric, character) is

lwsi_dt

and what values do you find when you inspect your input dataset?