Closed maggiesu0725 closed 6 years ago
@maggiesu0725 - can you actually reverse your changes? to be clear we want the rates to calculate as they were.
we just want to output a new numerator so that the math works in the .csv you output. new numerator that is the denominator * the weighted rate.
does that make sense?
@lhendey I didnt change the calculation of the premature death rate, I just changed the numerator to denominator * the weighted rate. My rate calculation is directly from the death and population counts instead of numerator/denominator so it won't affect the rate. Are you saying I should keep the old numerator?
@maggiesu0725 i see, sorry.
we're still not getting the right new numerator though. i think for simplicity's sake (and transparency), please reverse your changes.
to that data step create a new variable = to the denominatorequityvar (1000).
@lhendey changes made
@maggiesu0725 i think you need to put the numerator after the equityvariable calculation.
@maggiesu0725 sorry - wrong one!
@lhendey @ptatian I'm not totally sure if we need the 1000 in the new formula of numerator