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 the per-record bindings of an aggregation:
convert each record's date to an integer day count with to_epoch_day,
then summarize the integers.
Input: exposure records with sequence numbers (EXSEQ) and
start dates (EXSTDT). Only the record with sequence number 1 becomes
an output row.
Variables:
EXSEQ: the exposure sequence number, carried through.EXSTDY: the exposure start date as a count of days since 1970-01-01 (zero on that day, negative before it), blank when the start date is missing. It is not a day counted from a reference start.
Note: each matching exposure record's date is turned into its day
count first, so the summary works on plain integers and never on dates.
The summary then keeps the value of the one record with the row's
subject and sequence number (ONLY); a second matching record would
stop the run.
Inputs
Under review1 source fileinput/ex.csv
Edit3 rows| STUDYID | USUBJID | EXSEQ | EXSTDT |
|---|---|---|---|
| PILOT7 | 1 | 2024-01-15 | |
| PILOT7 | 2 | 2024-01-16 | |
| PILOT7 | 3 | 2024-01-17 |
Expected output
Under review1 expected rowexpected/adex.csv
Edit1 row| STUDYID | USUBJID | EXSEQ | EXSTDY |
|---|---|---|---|
| PILOT7 | 1 | 19737 |
Human review and assessment
| Dataset Name | Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Computational Method | Origin |
|---|---|---|---|---|---|---|---|
| ADEX | STUDYID | Study Identifier | character | Copy value from EX.STUDYID. | Predecessor | ||
| ADEX | USUBJID | Unique Subject Identifier | character | Copy value from EX.USUBJID. | Predecessor | ||
| ADEX | EXSEQ | Sequence Number | numeric | Copy value from EX.EXSEQ. | Predecessor | ||
| ADEX | EXSTDY | Epoch Day of Exposure Start | numeric | Aggregate ONLY(EPOCHDAY) over records matching on STUDYID, USUBJID and EXSEQ, with EPOCHDAY as days since 1970-01-01 for EX.EXSTDT. | Derived |
| Template | Include when |
|---|---|
| exposure | EX.EXSEQ = 1 |
| 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 |