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: demonstrate a qualified aggregate whose between bound and
filter read a value one of its per-record bindings computes (#4309):
NPRE, MEANPRE and NDATED.
Input: one specification, spec.yaml, over demographics (DM), whose
reference start date (RFSTDTC) is each subject's anchor date, and vital
signs (VS), whose collection dates (VSDTC) are text.
Variables:
ANCHDT: the subject's anchor date, read fromRFSTDTC.NPRE: the number of the subject's weight records collected on or before the anchor date, the anchor date itself included. A weight with no collection date is not counted, and a subject with no such weight has a missing count.MEANPRE: the mean of the same weights, missing when there are none.NDATED: the number of the subject's weight records that have a collection date, missing for a subject with none.
Note: each aggregate derives the record date MEASDT from VSDTC for
every vital-signs record of the subject, then keeps the records its range
and filter hold for, reading MEASDT beside the stored fields, and reduces
those. Subject 001's height record is not a weight; subject 002's second
weight has no date; subject 003's weights all fall after the anchor date;
subject 004 has no vital signs.
Inputs
Under review2 source filesinput/dm.csv
Edit4 rows| STUDYID | USUBJID | RFSTDTC |
|---|---|---|
| XYZ-01 | 2020-03-10 | |
| XYZ-01 | 2020-03-12 | |
| XYZ-01 | 2020-03-15 | |
| XYZ-01 | 2020-03-20 |
input/vs.csv
Edit8 rows| STUDYID | USUBJID | VSTESTCD | VSSTRESN | VSDTC |
|---|---|---|---|---|
| XYZ-01 | WEIGHT | 70.5 | 2020-03-01 | |
| XYZ-01 | WEIGHT | 71.0 | 2020-03-10 | |
| XYZ-01 | WEIGHT | 72.0 | 2020-04-07 | |
| XYZ-01 | HEIGHT | 170 | 2020-03-01 | |
| XYZ-01 | WEIGHT | 80.0 | 2020-03-12 | |
| XYZ-01 | WEIGHT | 81.0 | — | |
| XYZ-01 | WEIGHT | 64.0 | 2020-03-20 | |
| XYZ-01 | WEIGHT | 65.0 | 2020-04-01 |
Expected output
Under review4 expected rowsexpected/adsl.csv
Edit4 rows| STUDYID | USUBJID | ANCHDT | NPRE | MEANPRE | NDATED |
|---|---|---|---|---|---|
| XYZ-01 | 2020-03-10 | 2 | 70.75 | 3 | |
| XYZ-01 | 2020-03-12 | 1 | 80 | 1 | |
| XYZ-01 | 2020-03-15 | — | — | 2 | |
| XYZ-01 | 2020-03-20 | — | — | — |
Human review and assessment
| Dataset Name | Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Computational Method | Origin |
|---|---|---|---|---|---|---|---|
| ADSL | STUDYID | Study Identifier | character | Copy value from DM.STUDYID. | Predecessor | ||
| ADSL | USUBJID | Unique Subject Identifier | character | Copy value from DM.USUBJID. | Predecessor | ||
| ADSL | ANCHDT | Anchor Date | numeric | ISO 8601 | Take the date part of DM.RFSTDTC, blank for a year or a year and month alone. | Derived | |
| ADSL | NPRE | Number of Weights on or Before the Anchor Date | numeric | Aggregate COUNT(VS.*) over records matching on STUDYID and USUBJID, where ANCHDT is MEASDT or more, where VS.VSTESTCD = 'WEIGHT', with MEASDT as take the date part of VS.VSDTC, blank for a year or a year and month alone. | Derived | ||
| ADSL | MEANPRE | Mean Weight on or Before the Anchor Date | numeric | Aggregate MEAN(WEIGHT) over records matching on STUDYID and USUBJID, where ANCHDT is MEASDT or more, where VS.VSTESTCD = 'WEIGHT', with MEASDT as take the date part of VS.VSDTC, blank for a year or a year and month alone, with WEIGHT as VS.VSSTRESN. | Derived | ||
| ADSL | NDATED | Number of Dated Weights | numeric | Aggregate COUNT(VS.*) over records matching on STUDYID and USUBJID, where VS.VSTESTCD = 'WEIGHT' AND MEASDT IS NOT NULL, with MEASDT as take the date part of VS.VSDTC, blank for a year or a year and month alone. | 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 |