DATA Step, Macro, Functions and more

Difference between day program runs and variable date in dataset.

Reply
Contributor
Posts: 21

Difference between day program runs and variable date in dataset.

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.

PROC Star
Posts: 1,555

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

Like this?

 

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

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

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

Super User
Posts: 17,737

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

Did you get an error?

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

PROC Star
Posts: 1,555

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

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

Super User
Posts: 6,927

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

Which type (numeric, character) is

lwsi_dt

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 5 replies
  • 244 views
  • 0 likes
  • 4 in conversation