topic Re: Difference between day program runs and variable date in dataset. in SAS Programming

Difference between day program runs and variable date in dataset.

Sotarkadin — Mon, 11 Apr 2016 02:24:35 GMT

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.

Re: Difference between day program runs and variable date in dataset.

ChrisNZ — Mon, 11 Apr 2016 02:59:34 GMT

Like this?

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

Re: Difference between day program runs and variable date in dataset.

Sotarkadin — Mon, 11 Apr 2016 03:02:32 GMT

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

Re: Difference between day program runs and variable date in dataset.

Reeza — Mon, 11 Apr 2016 03:39:07 GMT

Did you get an error?

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

Re: Difference between day program runs and variable date in dataset.

ChrisNZ — Mon, 11 Apr 2016 03:53:10 GMT

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

Re: Difference between day program runs and variable date in dataset.

Kurt_Bremser — Mon, 11 Apr 2016 06:08:39 GMT

Which type (numeric, character) is

lwsi_dt

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