topic Re: Date Differences in SAS Visual Analytics

Date Differences

vtsit — Fri, 23 Jan 2015 12:00:02 GMT

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.

TejaSurapaneni — Fri, 23 Jan 2015 12:47:19 GMT

Hi,

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

vtsit — Fri, 23 Jan 2015 12:55:17 GMT

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

I could not find an appropriate function to implement this.

Thanks

TejaSurapaneni — Fri, 23 Jan 2015 13:02:19 GMT

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

PeterWijers — Fri, 23 Jan 2015 18:33:30 GMT

Teja, vtsit

correct, that works well

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

greeting

vtsit — Wed, 28 Jan 2015 11:27:07 GMT

Hi all,

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

Thank you so much.

Best regards

Vangelis

TejaSurapaneni — Wed, 28 Jan 2015 13:30:04 GMT

Hi Vangelis,

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

Thanks,

Teja Surapaneni