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.
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 )
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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.