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: one row per subject carrying the last measured height (HEIGHT)
and the last measured weight (WEIGHT).
Input: one spec.yaml over demographics records and vital signs
records, each naming its test, its date and its numeric result.
Variables:
HEIGHTis the result of the subject's latest height measurement; empty for a subject with none.WEIGHTis the result of the subject's latest weight measurement, the later record of two on one date; empty for a subject with none.
Note: one declaration names the two tests, and the choice of the latest record is made for each test alone, so a subject's later weight never displaces an earlier height. Measurements of other tests take no part.
Inputs
Under review2 source filesinput/dm.csv
Edit3 rows| STUDYID | USUBJID |
|---|---|
| YAMAA-01 | |
| YAMAA-01 | |
| YAMAA-01 |
input/vs.csv
Edit7 rows| STUDYID | USUBJID | VSSEQ | VSTESTCD | VSDTC | VSSTRESN |
|---|---|---|---|---|---|
| YAMAA-01 | 1 | HEIGHT | 2024-01-02 | 170.5 | |
| YAMAA-01 | 2 | WEIGHT | 2024-01-02 | 70 | |
| YAMAA-01 | 3 | TEMP | 2024-01-02 | 36.8 | |
| YAMAA-01 | 4 | WEIGHT | 2024-02-06 | 72.5 | |
| YAMAA-01 | 1 | HEIGHT | 2024-01-09 | 160 | |
| YAMAA-01 | 2 | WEIGHT | 2024-01-09 | 60 | |
| YAMAA-01 | 3 | WEIGHT | 2024-01-09 | 61 |
Expected output
Under review3 expected rowsexpected/adsl.csv
Edit3 rows| STUDYID | USUBJID | HEIGHT | WEIGHT |
|---|---|---|---|
| YAMAA-01 | 170.5 | 72.5 | |
| YAMAA-01 | 160 | 61 | |
| YAMAA-01 | — | — |
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 | HEIGHT | Height (cm) | numeric | Take HEIGHT from the last VS record whose STUDYID equals DM.STUDYID and USUBJID equals DM.USUBJID, where VS.VSTESTCD IN ('HEIGHT', 'WEIGHT'), ordered by VS.VSDTC, and no match yields blank. | Derived | ||
| ADSL | WEIGHT | Weight (kg) | numeric | Take WEIGHT from the last VS record whose STUDYID equals DM.STUDYID and USUBJID equals DM.USUBJID, where VS.VSTESTCD IN ('HEIGHT', 'WEIGHT'), ordered by VS.VSDTC, and no match yields blank. | 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 |