To be clear, I DO NOT want to store these as strings. I wanted to create variable that where 01/07/2020 is for the Date variable, another variable is created, called ReportingMonth and this has the value of July2020, as date. I am aware I can then format as these in other products like SAS VA, Excel etc. But I was hoping avoid any sort of additional work on (such as formating etc) in other products. Especially given I have to create the same report in 3 different products. While not time consuming for one report, it does add up over time. But I guess this is not possible.
... View more