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: give each electrocardiogram (ECG) the plasma concentration
measured nearest in time to it, before or after: the sample's sequence
number (PCSEQ), date/time (PCDTM) and concentration (PCCONC).
Input: one spec.yaml over ECG records, each with its sequence number
(EGSEQ) and its date and time, and pharmacokinetic (PK) concentration
records, each with its sequence number, date/time and result.
Variables:
ADTM: the ECG date and time.PCSEQ: the sequence number of the subject's sample nearest in time to the ECG. Of two samples equally far from it, the one taken earlier is chosen, so a sample before the ECG wins over one as far after it; of two taken at the same time, the one recorded first, whatever their sequence numbers.PCDTM: the date and time of that sample.PCCONC: the concentration of that sample.
Note: the distance is the time between the sample and the ECG in either direction, measured to the second, so a sample 45 minutes before an ECG is nearer than one 90 minutes after it.
Inputs
Under review2 source filesinput/eg.csv
Edit3 rows| STUDYID | USUBJID | EGSEQ | EGDTC |
|---|---|---|---|
| YAMAA-01 | 1 | 2024-05-02T08:00 | |
| YAMAA-01 | 2 | 2024-05-02T12:00 | |
| YAMAA-01 | 1 | 2024-05-02T09:30 |
input/pc.csv
Edit7 rows| STUDYID | USUBJID | PCSEQ | PCDTM | PCSTRESN |
|---|---|---|---|---|
| YAMAA-01 | 1 | 2024-05-02T07:00 | 11.2 | |
| YAMAA-01 | 2 | 2024-05-02T09:00 | 35.6 | |
| YAMAA-01 | 3 | 2024-05-02T11:15 | 28.4 | |
| YAMAA-01 | 4 | 2024-05-02T13:30 | 19.9 | |
| YAMAA-01 | 2 | 2024-05-02T10:00 | 22.1 | |
| YAMAA-01 | 1 | 2024-05-02T10:00 | 21.7 | |
| YAMAA-01 | 3 | 2024-05-02T08:30 | 14.0 |
Expected output
Under review3 expected rowsexpected/adeg.csv
Edit3 rows| STUDYID | USUBJID | EGSEQ | ADTM | PCSEQ | PCDTM | PCCONC |
|---|---|---|---|---|---|---|
| YAMAA-01 | 1 | 2024-05-02T08:00:00 | 1 | 2024-05-02T07:00:00 | 11.2 | |
| YAMAA-01 | 2 | 2024-05-02T12:00:00 | 3 | 2024-05-02T11:15:00 | 28.4 | |
| YAMAA-01 | 1 | 2024-05-02T09:30:00 | 2 | 2024-05-02T10:00:00 | 22.1 |
Human review and assessment
| Dataset Name | Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Computational Method | Origin |
|---|---|---|---|---|---|---|---|
| ADEG | STUDYID | Study Identifier | character | Copy value from EG.STUDYID. | Predecessor | ||
| ADEG | USUBJID | Unique Subject Identifier | character | Copy value from EG.USUBJID. | Predecessor | ||
| ADEG | EGSEQ | Sequence Number | numeric | Copy value from EG.EGSEQ. | Predecessor | ||
| ADEG | ADTM | Analysis Date/Time | numeric | ISO 8601 | Copy value from EG.EGDTC. | Predecessor | |
| ADEG | PCSEQ | Sequence Number of the Nearest Sample | numeric | Take PCSEQ from the PC record matching on STUDYID and USUBJID, and no match yields blank. | Derived | ||
| ADEG | PCDTM | Date/Time of the Nearest Sample | numeric | ISO 8601 | Take PCDTM from the PC record matching on STUDYID and USUBJID, and no match yields blank. | Derived | |
| ADEG | PCCONC | Concentration of the Nearest Sample | numeric | Take PCSTRESN from the PC record matching on STUDYID and USUBJID, 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 |