topic Re: Calculating the duration between dates in SAS Visual Analytics

Calculating the duration between dates

znhnm — Thu, 22 Jun 2023 16:15:39 GMT

Hi, I have two date variables on my dateset on Quater Year format. I would like to make a calculation substracting the two dates and see how many quarters have past between two dates. For example, if my Date2 is q3 2022, and Date1 is q1 2021, the new calculated value number_of_quarters should give me 6. How would I make such calculation on VA?

Re: Calculating the duration between dates

MarkusWeick — Thu, 22 Jun 2023 16:46:13 GMT

Hi @znhnm ,

it should be possible in a calculated item with a combination of Operators (SAS Help Center: Reference: Operators for Data Expressions), like

Parse, substring, ....

Unfortunately my SAS server is down, so I can't show you a complete example, but the 13th reply to the post character to numeric conversion - SAS Support Communities points towards a solution.