04-10-2016 10:24 PM
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.
04-10-2016 10:59 PM
data fraud_ovrvw4; set fraud_ovrvw3; if frd_status = 'Support Requested' then updt_tm = (lwsi_dt - today() ); run;
04-10-2016 11:02 PM
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
04-10-2016 11:39 PM
Did you get an error?
Format shouldn't matter, but the type does, is it a character or numeric variable?
04-10-2016 11:53 PM
The format doesn't matter. If it comes back missing then the input value is missing too.
04-11-2016 02:08 AM
Which type (numeric, character) is
and what values do you find when you inspect your input dataset?