Review ask

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

Lifecycle: draftEditUnder review
What this benchmark means
README.md

Public entries: Python and R. Passing coverage requires an installed inventory.

Goal: derive each subject's date of first exposure to treatment (TRTSDT), where every subject must have received a dose.

Input: demographics, and exposure records carrying each administration's start date and dose.

Variables:

  • TRTSDT would be the start date of the subject's earliest administration with a dose above zero. Every subject is required to have one, so a subject whose administrations all have a zero dose, or who has none, rejects the run with no artifact accepted, instead of leaving the date blank.

How to fix

Correct the exposure data when subject YAMAA-01-103 was dosed: its only administration records a zero dose. If a subject without a dosed administration is acceptable, drop require_match: true:

derivation:
  source:
    variable: EX.EXSTDTC
    filter: "EX.EXDOSE > 0"
    order_by: [EX.EXSTDTC]
    keep: first

The date is then missing for such a subject, and the run counts each one under absent. Declaring absent beside require_match: true is refused as a contradiction.

Expected failure

Edit
the run is rejected; no artifact is accepted
expected/error.yaml
phase
join
condition
unmatched_key
rule
LOOKUP-24
expected/error.yaml
phase: join
condition: unmatched_key
spec_paths:
  - columns.TRTSDT.derivation.source
rule: LOOKUP-24
context:
  intermediate: intermediate(EX)
  dataset: EX
  key: [STUDYID, USUBJID]
  intermediate_key:
    STUDYID: YAMAA-01
    USUBJID: YAMAA-01-103
  keys:
    - STUDYID: YAMAA-01
      USUBJID: YAMAA-01-103

Inputs

Under review
2 source files

input/dm.csv

Edit
3 rows
input/dm.csv
STUDYIDUSUBJID
YAMAA-01
YAMAA-01
YAMAA-01

input/ex.csv

Edit
4 rows
input/ex.csv
STUDYIDUSUBJIDEXSEQEXSTDTCEXDOSE
YAMAA-0112025-01-0650
YAMAA-0122025-01-1350
YAMAA-0112025-01-0825
YAMAA-0112025-01-090

Unexpected Output

Under review
No artifact is produced

No fixture files in this directory.

Shaded columns are derived— = missing value

Human review and assessment

Your review

2 questions and your comments · View benchmark discussions

Mapping spec

Generated from the benchmark YAML; do not edit by hand

Dataset NameVariable NameVariable LabelTypeCodelist/Controlled TermsCoreComputational MethodOrigin
ADSLSTUDYIDStudy IdentifiercharacterCopy value from DM.STUDYID.Predecessor
ADSLUSUBJIDUnique Subject IdentifiercharacterCopy value from DM.USUBJID.Predecessor
ADSLTRTSDTDate of First Exposure to TreatmentnumericISO 8601Copy value from EX.EXSTDTC where EX.EXDOSE > 0, keeping the first ordered by EX.EXSTDTC; a row with no matching record is an error.Predecessor
VersionDateAuthorDescriptionReviewerSign-off
1.72026-10-20yamaa docs buildRead 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.62026-10-17yamaa docs buildDescribe collected date parts written as ISO 8601 date text and times of day counted in seconds since midnight
1.52026-10-17yamaa docs buildName 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.42026-10-15yamaa docs buildState datetime precision codes through the hour and minute, and complete only the time parts a collected datetime lacks
1.32026-09-29yamaa docs buildShow study codelist names, external dictionaries, and ISO 8601 formats in variable rows; list the document's codelist values and metadata
1.22026-09-29yamaa docs buildClassify ADaM copies from a declared input as Predecessor and recodes as Derived, and SDTM recodes of locally derived columns as Derived
1.12026-09-29yamaa docs buildResolve lookups into the donor record they select, and give every derivation shape a plain-language rule instead of its raw YAML
1.0yamaa docs buildInitial generation from spec.yaml