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 text questionnaire responses to numbers, then sum them.
Input: questionnaire responses with text results (QSORRES)
for the physical functioning scale. Each subject and visit with a
record for the first item (PF01) gets one score record.
Variables:
PARAMCD:PFSCOREon the score record.PARAM: the subscale name.AVAL: the sum of the visit's physical functioning responses, each read as a number. A blank response is left out of the sum; a response that is not a number stops the run.
Note: there is no separate text-to-number step. Declaring each record's response as a decimal number is what converts it, one record at a time, before the sum runs.
Inputs
Under review1 source fileinput/qs.csv
Edit4 rows| STUDYID | USUBJID | VISIT | QSSEQ | QSCAT | QSTESTCD | QSTEST | QSORRES |
|---|---|---|---|---|---|---|---|
| PILOT7 | BASELINE | 1 | PHYSICAL FUNCTIONING SCALE | PF01 | Trouble with strenuous activity | 2 | |
| PILOT7 | BASELINE | 2 | PHYSICAL FUNCTIONING SCALE | PF02 | Trouble with a long walk | 1 | |
| PILOT7 | BASELINE | 3 | PHYSICAL FUNCTIONING SCALE | PF03 | Trouble with a short walk | 2 | |
| PILOT7 | BASELINE | 4 | PHYSICAL FUNCTIONING SCALE | PF04 | Needs to stay in bed or a chair | 1 |
Expected output
Under review1 expected rowexpected/adqs.csv
Edit1 row| STUDYID | USUBJID | VISIT | PARAMCD | PARAM | AVAL |
|---|---|---|---|---|---|
| PILOT7 | BASELINE | PFSCORE | Physical Functioning Subscale Score | 6 |
Human review and assessment
| Dataset Name | Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Computational Method | Origin |
|---|---|---|---|---|---|---|---|
| ADQS | STUDYID | Study Identifier | character | Copy value from QS.STUDYID. | Predecessor | ||
| ADQS | USUBJID | Unique Subject Identifier | character | Copy value from QS.USUBJID. | Predecessor | ||
| ADQS | VISIT | Visit Name | character | Copy value from QS.VISIT. | Predecessor | ||
| ADQS | PARAMCD | Parameter Code | character | Set per constructed row; see the Row construction sheet. | Derived | ||
| ADQS | PARAM | Parameter | character | Set per constructed row; see the Row construction sheet. | Derived | ||
| ADQS | AVAL | Analysis Value | numeric | Aggregate SUM(QSNUM) over records matching on STUDYID, USUBJID and VISIT, where QS.QSCAT = 'PHYSICAL FUNCTIONING SCALE', with QSNUM as QS.QSORRES. | Derived |
| Template | Include when | PARAMCD | PARAM |
|---|---|---|---|
| subscale | QS.QSCAT = 'PHYSICAL FUNCTIONING SCALE' AND QS.QSTESTCD = 'PF01' | Constant "PFSCORE" | Constant "Physical Functioning Subscale Score" |
| 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 |