topic Re: How to change the date expression to numeric after creating 'New Calculated Item' in SAS VA in SAS Visual Analytics

How to change the date expression to numeric after creating 'New Calculated Item' in SAS VA

c4th1 — Tue, 19 Jun 2018 01:18:52 GMT

Hi, I am trying to do new calculated item in the Report Designer to calculate 'now() - timestamp' to give a total number of days. Can someone please advise how do I do the calculation. And how to show the result in numeric?

Thank you.

Re: How to change the date expression to numeric after creating 'New Calculated Item' in SAS VA

MikeJenista — Tue, 26 Jun 2018 15:14:16 GMT

It is a little cumbersome, but you can use the DayOfYear and Year functions to return numeric values from the two dates ('now' and 'timestamp'). Also you have to wrap 'Now()' in a DatePart() function:

365*( Year(DatePart( Now() )) - Year( timestamp ) + DayOfYear( DatePart( Now() )) - DayOfYear( timestamp )

Re: How to change the date expression to numeric after creating 'New Calculated Item' in SAS VA

MikeJenista — Tue, 26 Jun 2018 15:16:13 GMT

I checked if a simpler calculation would work:

DatePart( Now() ) - timestamp

But it did not. I think this is because the underlying SAS date value is not a supported format for VA content, but I can check on it with some folks I know in development.