yamaa As a clinical trial statistician or programmer, answer two short questions in Your review: the task and the inputs. 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: combine blood pressure measured at clinic visits with blood pressure
read at home, with the study day in VSDY, where the blood pressure was
measured in VSCAT, the systolic blood pressure in VSSTRESN, and each
subject's records numbered in order of study day in VSSEQ.
Input: clinic measurements, one per visit, and home readings, one per day.
Both carry the study day (VSDY) and the systolic blood pressure (SYSBP).
Variables:
VSCATwould beCLINICfor a clinic measurement andHOMEfor a home reading.VSSTRESNwould be the systolic blood pressure of the measurement or the reading.VSSEQwould number each subject's records from 1, the earliest study day first, whether a record is a clinic measurement or a home reading.
Note: the numbering takes each record's day from the clinic measurement it was built from. A record built from a home reading has no clinic measurement, so that day is not a value of the record. The run is rejected before any data is read, and no artifact is accepted.
How to fix
Number the records by a day that every record carries. VSDY already holds
it, taken from the clinic measurement or the home reading that built the
record, so order by that column:
VSSEQ:
row_number:
window:
group_by: [USUBJID]
order_by: [VSDY]
When the order needs a value that only one source holds, such as the time of a clinic visit, first bring it onto every record as its own column, filled from each record's own source, and order by that column.
Expected failure
Editthe run is rejected; no artifact is acceptedexpected/error.yaml- phase
- validation
- condition
- unknown_field
- rule
- WINDOW-11
expected/error.yaml
phase: validation
condition: unknown_field
spec_paths:
- columns.VSSEQ.derivation.row_number.window.order_by[0]
rule: WINDOW-11
context:
identifier: CLINIC.VSDY
drivers: [CLINIC, HOME]
operation: row_number
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| USUBJID | Unique Subject Identifier | Char | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 1 | ||||
| VSCAT | Category for Vital Signs | Char | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 2 | ||||
| VSDY | Study Day of Vital Signs | Num | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 3 | ||||
| VSSTRESN | Numeric Result/Finding in Standard Units | Num | Derived | Set per constructed row; see the Row construction sheet. | SDTM | 4 | ||||
| VSSEQ | Sequence Number | Num | Derived | Row number within each group of USUBJID, ordered by CLINIC.VSDY. | SDTM | 5 |
| Template | Include when | USUBJID | VSCAT | VSDY | VSSTRESN |
|---|---|---|---|---|---|
| clinic | Copy CLINIC.USUBJID | Constant "CLINIC" | Copy CLINIC.VSDY | Copy CLINIC.SYSBP | |
| home | Copy HOME.USUBJID | Constant "HOME" | Copy HOME.VSDY | Copy HOME.SYSBP |
| 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 |