Calculating the duration between dates

[znhnm]

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?

[MarkusWeick]

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.