Very good article Renato, at least there is some way to calculate PMPM. However this is still in a sense of 'hard code' so really limit the flexibility, e.g. adding another dimension in the future need to reconstruct the source table again. To be honest I think the good practice here is to treat claim and membership as two different table and then blend two SUM calculation on YEARMONTH, AGE, GENDER. It is a pity that data blending is still not available even on SAS Viya.
... View more