I'm working on NPCR data on cancer incidence. It turned out I accidentally count more cancer events than what CDC/SEER rules would. After some extensive search, what happened is that sequence 00 is correct for the person’s only primary, however, sequence 01 could, for example, include both a first lung primary and also the first colon primary for the same person, which CDC sometimes excludes or combines under site-specific rules. In other words, by including all “01” in cancer count, I double-(or triple-) charging a personal who got two separate primaries, whereas CDC’s rule set may only one of those two as an “incident” for the site/time window selected. For example, if a person had a lung primary in 2015 and a colon primary in 2017, my code will add 2 to cancer count, but CDC’s “2015-2020 lung + colon rate” might only count 1 (only the first lung, for example) depending on the site-specific multiple primary rules. I am trying to identify a table referred to as “Multiple Primary (MP)” decision table, which will help decide whether to count as a primary cancer occurrence. So far hasn't been able to. Anyone knows how to identify this table and incorporate it as a Marco in SAS programming?
... View more
