Convert from VBA function to SAS

[raphaelchaves]

Hello all, I have tried to use the m2cgen package in order to translate 3 specific VBA functions to SAS or R scripts. I'm sending as an attached file an Excel spreasheet that illustrates what I'e tried to accomplish. There are 3 different functions available over this Excel spreadsheet, for instance: a) COHORT: Function used to calculated a transition matrix through Cohort approach b) GENERATOR: Function used to calculated the generator matrix through Aalen-Johansen Estimator c) MEXPGENERATOR: Function used to translate the generator matrix in probabilities

I'd be so grateful if you are able to help me on that.

Thanks in advance. Best Regards, Raphael

Transition Matrix_VBA Functions.zip