Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Date Differences

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Date Differences

Hi to all,

I am trying to calculate the difference in days between two date fields. Is there any way to do this on report level ?

Thanks in advance.


Accepted Solutions
Solution
‎01-28-2015 08:30 AM
Regular Contributor
Posts: 208

Re: Date Differences

Hi Vangelis,

Happy to hear that, please mark the question as answered.

Thanks,

Teja Surapaneni

View solution in original post


All Replies
Regular Contributor
Posts: 208

Re: Date Differences

Hi,

Can pls tell me bit more u want no.of days or DOD growth

New Contributor
Posts: 3

Re: Date Differences

Posted in reply to TejaSurapaneni

No, I just want the difference in days just like in excel.

I could not find an appropriate function to implement this.

Thanks

Regular Contributor
Posts: 208

Re: Date Differences

Just convert the date fields to numeric (using treatas function), after that u can easily get solution.

Regular Contributor
Posts: 191

Re: Date Differences

Posted in reply to TejaSurapaneni

Teja, vtsit

correct, that works well  Smiley Wink

pic1.png

This also covers the year skip, that would not have been solved while using days(Del.Date)-Days(entry.Date)

greeting

New Contributor
Posts: 3

Re: Date Differences

Posted in reply to PeterWijers

Hi all,

thanks for the replies, I finally managed to solve the problem due to your suggestions.

Thank you so much.

Best regards

Vangelis

Solution
‎01-28-2015 08:30 AM
Regular Contributor
Posts: 208

Re: Date Differences

Hi Vangelis,

Happy to hear that, please mark the question as answered.

Thanks,

Teja Surapaneni

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 677 views
  • 1 like
  • 3 in conversation