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: carry the date and time of first and last exposure (TRTSDTM,
TRTEDTM) and the baseline weight (WEIGHTBL) into ADSL from a Parquet
export, each value as the stored data means it.
Input: one Parquet file, input/adsl_raw.parquet, with one record per
subject, as pyarrow writes a data frame by default: the first exposure
counted in nanoseconds, the last exposure in milliseconds, and the weight as
a single-precision number.
Variables:
TRTSDTMandTRTEDTMare the date and time of first and last exposure, to the second; missing when the subject was never treated, or, for the last exposure, while treatment continues.WEIGHTBLis the baseline weight in kilograms, the exact number stored; missing when not measured.
Note: a time stored to the millisecond or the nanosecond reads as the same date and time as one stored to the microsecond, as long as it falls on a whole second. A single-precision number holds fewer digits than an ordinary one, so a weight typed as 81.3 is stored as exactly 81.3000030517578125 and arrives as that number, not rounded back to 81.3; the saved table writes it as 81.30000305175781, the shortest text that reads back as the same number.
Inputs
Under review1 source fileinput/adsl_raw.parquet
EditBinary fixture; inspect it in the benchmark source.
Expected output
Under review4 expected rowsexpected/adsl.csv
Edit4 rows| STUDYID | USUBJID | TRTSDTM | TRTEDTM | WEIGHTBL |
|---|---|---|---|---|
| YAMAA-01 | 2024-03-04T10:30:00 | 2024-06-01T08:00:00 | 72.5 | |
| YAMAA-01 | 2024-05-10T08:05:33 | 2024-08-02T17:45:10 | 81.30000305175781 | |
| YAMAA-01 | — | — | 64.25 | |
| YAMAA-01 | 2024-07-10T23:59:59 | — | — |
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 RAW.STUDYID. | Predecessor | ||
| ADSL | USUBJID | Unique Subject Identifier | character | Copy value from RAW.USUBJID. | Predecessor | ||
| ADSL | TRTSDTM | Datetime of First Exposure to Treatment | numeric | ISO 8601 | Copy value from RAW.TRTSDTM. | Predecessor | |
| ADSL | TRTEDTM | Datetime of Last Exposure to Treatment | numeric | ISO 8601 | Copy value from RAW.TRTEDTM. | Predecessor | |
| ADSL | WEIGHTBL | Baseline Weight (kg) | numeric | Copy value from RAW.WEIGHTBL. | Predecessor |
| 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 |