If DSFC is the time since that customer's first claim, then I would expect evey MemberID in the Claims file to have a "0- 1 month" entry. And 77,118 of them do, but there are 171 members with (much) later first claims.
Question: Are these errors, or patients with a scrubbed earlier claim?
> table(claims.Y1[, list(first.claim = min(dsfs)), by = list(MemberID)][, first.claim])
0- 1 month 1- 2 months 2- 3 months 3- 4 months 4- 5 months 5- 6 months
77118 102 33 19 8 4
6- 7 months 7- 8 months 8- 9 months 9-10 months 10-11 months 11-12 months
5 0 0 0 0 0
> head(claims.Y1[, list(first.claim = min(dsfs)), by = list(MemberID)][first.claim != "0- 1 month", MemberID])
[1] 100932559 113011586 113190879 124180853 130424132 130896244
77289 Levels: 100021596 10005398 100059282 100063319 100074925 ... 999999313
OT: What happened to preview on this forum?
Flagging is a way of notifying administrators that this message contents inappropriate or abusive content. Are you sure this forum post qualifies?

with —