As a clinical trial statistician or programmer, challenge anything in this benchmark: describe a problem in Comments, or propose a fix with the Edit button on any source file.
- Task: Would a real study need this derivation, specified this way? Does it follow CDISC SDTM: variable names, controlled terms, record structure? Flag any rule that is ambiguous or that a sponsor would handle differently.
- Inputs: Do they look like data collected in a real trial, and do they include the situations you would expect to meet in one?
- Expected output: Would independent QC programming reproduce every value from these inputs and rules?
The other tabs beside Comments are background for assessment, not under review.
Summary
README.mdGoal: derive SEX and AGE for one record per subject, each from the
one record that holds the subject's answer.
Input: long-form Operational Data Model (ODM) data with one row per
collected item, carrying the visit (StudyEventOID), the form, the item
(ItemOID), and the stored value (Value).
Variables:
SEXis the sex answered at screening. A subject who is asked again at a later visit keeps the screening answer.AGEis the age collected for the subject; a subject with no age record keeps a missing age.
Note: an answer is read only when exactly one record holds it, so two records of one question at one visit stop the run even when they agree. Items the record does not read, such as a weight, play no part.
Inputs
Under review1 source fileinput/odm.csv
Edit5 rows| StudyOID | MetaDataVersionOID | SubjectKey | StudyEventOID | StudyEventRepeatKey | FormOID | FormRepeatKey | ItemGroupOID | ItemGroupRepeatKey | ItemOID | Value |
|---|---|---|---|---|---|---|---|---|---|---|
| STUDY01 | MDV.1 | 001 | SCREENING | 1 | FO.DM | 1 | IG.DM | 1 | IT.DM.SEX | F |
| STUDY01 | MDV.1 | 001 | SCREENING | 1 | FO.DM | 1 | IG.DM | 1 | IT.DM.AGE | 34 |
| STUDY01 | MDV.1 | 001 | SCREENING | 1 | FO.VS | 1 | IG.VS | 1 | IT.VS.WEIGHT | 61 |
| STUDY01 | MDV.1 | 001 | BASELINE | 1 | FO.DM | 1 | IG.DM | 1 | IT.DM.SEX | F |
| STUDY01 | MDV.1 | 002 | SCREENING | 1 | FO.DM | 1 | IG.DM | 1 | IT.DM.SEX | M |
Expected output
Under review2 expected rowsexpected/dm.csv
Edit2 rows| STUDYID | USUBJID | SEX | AGE |
|---|---|---|---|
| STUDY01 | F | 34 | |
| STUDY01 | M | — |
Comments and assessment materials
| Variable Name | Variable Label | Type | Length | Controlled Terms or Format | Origin | Core | Conversion Definition | Variable Type | Variable Order | Comments for Define |
|---|---|---|---|---|---|---|---|---|---|---|
| STUDYID | Study Identifier | Char | Collected | Copy value from ODM.StudyOID. | SDTM | 1 | ||||
| USUBJID | Unique Subject Identifier | Char | Collected | Copy value from ODM.SubjectKey. | SDTM | 2 | ||||
| SEX | Sex | Char | Collected | Read collected ODM item IT.DM.SEX in event SCREENING; no identified record yields blank. | SDTM | 3 | ||||
| AGE | Age | Num | Collected | Read collected ODM item IT.DM.AGE; no identified record yields blank. | SDTM | 4 |
| Version | Date | Author | Description | Reviewer | Sign-off |
|---|---|---|---|---|---|
| 1.3 | 2026-09-29 | yamaa docs build | Show study codelist names, external dictionaries, and ISO 8601 formats in variable rows; list the document's codelist values and metadata | ||
| 1.2 | 2026-09-29 | yamaa docs build | Classify ADaM copies from a declared input as Predecessor and recodes as Derived, and SDTM recodes of locally derived columns as Derived | ||
| 1.1 | 2026-09-29 | yamaa docs build | Resolve lookups into the donor record they select, and give every derivation shape a plain-language rule instead of its raw YAML | ||
| 1.0 | yamaa docs build | Initial generation from spec.yaml |
yamaa
Comments
Signed in with GitHub; saved in repository Discussions