yamaa As a clinical trial statistician or programmer, answer two short questions in Your review: the task and the inputs and outputs. Agreeing with both approves this benchmark; disagreeing with either needs a comment. Propose a fix with the Edit button on any source file, or add it to your comments.
We suggest spending no more than 5 minutes on a review. The other tabs beside Your review are background for assessment, not under review.
Summary
EditUnder reviewWhat this benchmark meansREADME.mdPublic entries: Python and R. Passing coverage requires an installed inventory.
Goal: give each clinic and home measurement its analysis window
(WINDOW), next to where it was taken (SOURCE), its sequence number
(SEQ), and its study day (DAY).
Input: one spec.yaml over clinic measurements, which carry the visit
they were collected at; home measurements, which carry no visit and store
their fields in a different order; and a window table giving each analysis
window of the study its first and last study day.
Variables:
SOURCEisCLINICfor a clinic measurement andHOMEfor a home one.WINDOWis the collected visit for a clinic measurement. For a home measurement it is the window whose days, both ends inclusive, hold the study day of that home record; blank when no window does.
Note: a home row's window is chosen by the day of the home record that
built the row, never by a clinic value. Window edges are inclusive, so day
21 closes WEEK 2 and day 22 opens WEEK 4.
Inputs
Under review3 source filesinput/clinic.csv
Edit2 rows| STUDYID | USUBJID | SEQ | VISIT | DAY |
|---|---|---|---|---|
| YAMAA-01 | 1 | BASELINE | 1 | |
| YAMAA-01 | 2 | WEEK 2 | 15 |
input/home.csv
Edit3 rows| STUDYID | USUBJID | DAY | SEQ |
|---|---|---|---|
| YAMAA-01 | 21 | 1 | |
| YAMAA-01 | 22 | 2 | |
| YAMAA-01 | 50 | 3 |
input/windows.csv
Edit3 rows| STUDYID | NAME | LO | HI |
|---|---|---|---|
| YAMAA-01 | BASELINE | 1 | 1 |
| YAMAA-01 | WEEK 2 | 2 | 21 |
| YAMAA-01 | WEEK 4 | 22 | 42 |
Expected output
Under review5 expected rowsexpected/out.csv
Edit5 rows| STUDYID | USUBJID | SOURCE | SEQ | DAY | WINDOW |
|---|---|---|---|---|---|
| YAMAA-01 | CLINIC | 1 | 1 | BASELINE | |
| YAMAA-01 | CLINIC | 2 | 15 | WEEK 2 | |
| YAMAA-01 | HOME | 1 | 21 | WEEK 2 | |
| YAMAA-01 | HOME | 2 | 22 | WEEK 4 | |
| YAMAA-01 | HOME | 3 | 50 | — |
Human review and assessment
| 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 | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 1 | ||||
| USUBJID | Unique Subject Identifier | Char | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 2 | ||||
| SOURCE | Measurement Source | Char | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 3 | ||||
| SEQ | Sequence Number | Num | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 4 | ||||
| DAY | Study Day | Num | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 5 | ||||
| WINDOW | Analysis Window | Char | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 6 |
| Template | Include when | STUDYID | USUBJID | SOURCE | SEQ | DAY | WINDOW |
|---|---|---|---|---|---|---|---|
| clinic | Copy CLINIC.STUDYID | Copy CLINIC.USUBJID | Constant "CLINIC" | Copy CLINIC.SEQ | Copy CLINIC.DAY | Copy CLINIC.VISIT | |
| home | Copy HOME.STUDYID | Copy HOME.USUBJID | Constant "HOME" | Copy HOME.SEQ | Copy HOME.DAY | Copy NAME from the WINDOWS record matching on STUDYID, where HOME.DAY falls within LO to HI, and no match yields blank |
| Version | Date | Author | Description | Reviewer | Sign-off |
|---|---|---|---|---|---|
| 1.7 | 2026-10-20 | yamaa docs build | Read a specification in the 1.0 surface as its 0.5 counterpart; state that missing values stay missing where a mapping declares no missing handler, and leave out a declared missing answer that restates a handler's default | ||
| 1.6 | 2026-10-17 | yamaa docs build | Describe collected date parts written as ISO 8601 date text and times of day counted in seconds since midnight | ||
| 1.5 | 2026-10-17 | yamaa docs build | Name collected precision in words instead of letter codes; state imputation fallbacks, minimum source precision, bounds ignored outside the collected period, and invalid text with no handler as an error; describe date and datetime shifts, imputation flag codes, and partial text giving no date part | ||
| 1.4 | 2026-10-15 | yamaa docs build | State datetime precision codes through the hour and minute, and complete only the time parts a collected datetime lacks | ||
| 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 |