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