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: attach the reference-range limits (LBSTNRLO, LBSTNRHI) to each
collected result, by its test code (LBTESTCD) and the subject's sex.
Input: collected results carrying the test code and the numeric result
(LBSTRESN), the subjects' demographics carrying their sex, and a
reference-limit table by test code and sex.
Variables:
LBSTNRLOandLBSTNRHIwould be the lower and upper limits of the reference range for the result's test and the subject's sex.
Note: a reference range is matched on values the result row carries. The sex is taken from another look-up while the range is matched, and a match never reads one look-up through another, so the run is rejected before any data is read and no artifact is accepted.
How to fix
Bring the subject's sex onto the row as a column first, then match the range on that column:
columns:
- {name: SEX, type: str, derivation: SUBJECT.SEX}
intermediates:
- id: RANGE
dataset: LBRANGE
key: [LBTESTCD, SEX]
A column that only carries the value for the match can stay out of the output.
Expected failure
Editthe run is rejected; no artifact is acceptedexpected/error.yaml- phase
- validation
- condition
- unknown_field
- rule
- LOOKUP-5
expected/error.yaml
phase: validation
condition: unknown_field
spec_paths:
- intermediates.RANGE.key
rule: LOOKUP-5
context:
identifier: SUBJECT.SEX
intermediate: RANGE
Inputs
Under review3 source filesUnexpected Output
Under reviewNo artifact is producedNo fixture files in this directory.
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 | Collected | Copy value from LB_RAW.STUDYID. | SDTM | 1 | ||||
| USUBJID | Unique Subject Identifier | Char | Collected | Copy value from LB_RAW.USUBJID. | SDTM | 2 | ||||
| LBSEQ | Sequence Number | Num | Collected | Copy value from LB_RAW.LBSEQ. | SDTM | 3 | ||||
| LBTESTCD | Lab Test or Examination Short Name | Char | Collected | Copy value from LB_RAW.LBTESTCD. | SDTM | 4 | ||||
| LBSTRESN | Numeric Result/Finding in Standard Units | Num | Collected | Copy value from LB_RAW.LBSTRESN. | SDTM | 5 | ||||
| LBSTNRLO | Reference Range Lower Limit-Std Units | Num | Derived | Take NRLO from the LBRANGE record whose LBTESTCD equals LBTESTCD and SEX equals SEX from the DM record matching on STUDYID and USUBJID, blank when unmatched, and a row with no match is an error. | SDTM | 6 | ||||
| LBSTNRHI | Reference Range Upper Limit-Std Units | Num | Derived | Take NRHI from the LBRANGE record whose LBTESTCD equals LBTESTCD and SEX equals SEX from the DM record matching on STUDYID and USUBJID, blank when unmatched, and a row with no match is an error. | SDTM | 7 |
| 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 |