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: give each analysis record the visit (AVISIT) of the one
window whose first and last analysis days surround the record's
analysis day (ADY).
Input: analysis records carrying the analysis day (ADY), and
one study-wide window table giving each visit its first (AWLO)
and last (AWHI) analysis day.
Variables:
ADY: the record's analysis day, carried through as given.AVISITwould be the visit of the window whose first and last days, both included, surround the analysis day; missing when no window holds the day or the day is missing.
Note: a day that falls in two windows has no single visit, and choosing either would depend on a rule the study did not state, so the whole run fails and no dataset is produced.
How to fix
First correct unintended overlap in the window table, so that each
analysis day falls in at most one window (here, end WEEK 2 on day
14). If overlap is intentional, state and justify a deterministic
selection policy with order_by and keep on the window lookup; do
not rely on source-row order. For example, to give a shared day to
the window that starts later:
intermediates:
- id: AWIN
dataset: AWINDOW
key: [STUDYID]
between: {value: ADY, lower: AWLO, upper: AWHI}
order_by: [AWINDOW.AWLO]
keep: last
Expected failure
Editthe run is rejected; no artifact is acceptedexpected/error.yaml- phase
- join
- condition
- multiple_matches
- rule
- LOOKUP-10
expected/error.yaml
phase: join
condition: multiple_matches
spec_paths:
- intermediates.AWIN
rule: LOOKUP-10
context:
intermediate: AWIN
dataset: AWINDOW
key:
- STUDYID
intermediate_key:
STUDYID: CATH
match_count: 2
keys:
- STUDYID: CATH
USUBJID: CATH-UCSD-0099
PARAMCD: SYSBP
VSSEQ: 1
Inputs
Under review2 source filesUnexpected Output
Under reviewNo artifact is producedNo fixture files in this directory.
Human review and assessment
| Dataset Name | Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Computational Method | Origin |
|---|---|---|---|---|---|---|---|
| ADVS | STUDYID | Study Identifier | character | Copy value from ADVS_RAW.STUDYID. | Predecessor | ||
| ADVS | USUBJID | Unique Subject Identifier | character | Copy value from ADVS_RAW.USUBJID. | Predecessor | ||
| ADVS | PARAMCD | Parameter Code | character | Copy value from ADVS_RAW.PARAMCD. | Predecessor | ||
| ADVS | VSSEQ | Sequence Number | numeric | Copy value from ADVS_RAW.VSSEQ. | Predecessor | ||
| ADVS | ADY | Analysis Relative Day | numeric | Copy value from ADVS_RAW.ADY. | Predecessor | ||
| ADVS | AVISIT | Analysis Visit | character | Take AVISIT from the AWINDOW record matching on STUDYID, where ADY falls within AWLO to AWHI, and a row with no match is an error. | Derived |
| 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 |