Help using Base SAS procedures

Converting Dates

Reply
New Contributor
Posts: 4

Converting Dates

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?

Super User
Super User
Posts: 7,060

Re: Converting Dates

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

diff = date_event - date0 ;

Respected Advisor
Posts: 4,927

Re: Converting Dates

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

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

PG

PG
Ask a Question
Discussion stats
  • 2 replies
  • 201 views
  • 0 likes
  • 3 in conversation