I need to find the number of days to event. I was given a sas data set with variables date0 and date_event. The dates are already formatted as ddmmmyyyy. I need to calculate the difference between Date0 and Date_event. I wanted to unformat the dates and then take the difference of the unfomatted dates to find the number of days to event. Is this the best way to approach this question? Is there a way to just take the difference between the formatted dates?
Dates are stored as number of days. So just subtract the values.
diff = date_event - date0 ;
Or, if you want to free yourself of the underlying date representation,
diff = intck("DAY", date0, date_event);
PG
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.