BookmarkSubscribeRSS Feed
Kenmar
Calcite | Level 5

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?

2 REPLIES 2
Tom
Super User Tom
Super User

Dates are stored as number of days.  So just subtract the values.

diff = date_event - date0 ;

PGStats
Opal | Level 21

Or, if you want to free yourself of the underlying date representation,

diff = intck("DAY", date0, date_event);

PG

PG

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 770 views
  • 0 likes
  • 3 in conversation