Reject a subject-wide count inside a one-race row

Goal: attempt one supplemental Demographics (SUPPDM) record per reported race (QVAL) for each subject who marked more than one race, deciding "more than one" by counting the subject's race rows.

Input: EDC output in long form, one row per collected item; each race option a subject marks contributes one race row.

Variables:

• QVAL: would be one race the subject marked, kept only for a subject with several.

Each record being built stands for one subject and one race, so a count taken while building it sees only that race's rows: a subject with two different races would count one for each and be dropped, while a race marked twice would count two and be kept. Asking the count to span the whole subject does not widen it, so the run is rejected before any data is read.

How to fix

Decide which record already says that a subject marked several races, and read it instead of recounting inside the record being built. When the same run builds DM, its RACE is MULTIPLE exactly then: read DM through an input with schema: and filter on DMRACE = 'MULTIPLE', as sdtm-dm-race-ethnicity does.

Without DM, select the subject's lowest and highest race with keyed lookups and keep the record when they differ. Unlike a row count, this does not mistake a race marked twice for two races:

intermediates:
  - id: RACELOW
    dataset: ODM
    key: {StudyOID: STUDYID, SubjectKey: USUBJID}
    filter: "ODM.ItemOID = 'IT.DM.RACE' AND ODM.Value IS NOT NULL"
    order_by: [ODM.Value]
    keep: first
  # RACEHIGH: the same lookup with keep: last
rows:
  - id: reported_race
    group_by: [ODM.StudyOID, ODM.SubjectKey, ODM.ItemOID, ODM.Value]
    filter: "ITEMOID = 'IT.DM.RACE' AND RACELOWV < RACEHIGHV"
    derivations:
      # STUDYID, USUBJID, ITEMOID and QVAL as before
      RACELOWV: RACELOW.Value
      RACEHIGHV: RACEHIGH.Value

Declare RACELOWV and RACEHIGHV as text columns in place of RACECOUNT, and leave them out of the output.