Review ask

As a clinical trial statistician or programmer, answer three short questions in Your review: the task, the inputs and outputs, and the AI-assisted review. Agreeing with all three approves this benchmark; disagreeing with any 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

Lifecycle: reviewedEditUnder review
What this benchmark means
README.md

Public entries: Python and R. Passing coverage requires an installed inventory.

Goal: build one supplemental record per collected qualifier, carrying IDVARVAL, QLABEL, QVAL, QORIG, and QEVAL, with each record pointing back at its parent medical history (MH) record.

Input: a medical history extract with one record per condition, carrying the parent record sequence and the two collected qualifiers.

Variables:

  • IDVARVAL is the parent record sequence, written as text; a parent record with no sequence number stops the run.
  • QLABEL is the qualifier label: Family History for MHFAMHX, Confirmed by Medical Records for MHCONF.
  • QVAL is the collected qualifier value, Y or N.
  • QORIG records the collected origin as Collected (Define-XML 2.1).
  • QEVAL is blank, since a collected value is not an assessment.

Note: each parent record contributes one supplemental record per qualifier actually collected, so a record with only one of the two collected contributes only one. Records are ordered by study, then subject, then parent record sequence compared as text (so 10 sorts before 2), then qualifier name.

Inputs

Under review
1 source file

input/mh_raw.csv

Edit
4 rows
input/mh_raw.csv
STUDYIDUSUBJIDMHSEQMHTERMMHFAMHXMHCONF
CATH1ASTHMAYY
CATH2ECZEMAN—
CATH1HYPERTENSIONNN
CATH2MIGRAINEYY

Expected output

Under review
7 expected rows

expected/suppmh.csv

Edit
7 rows
expected/suppmh.csv
STUDYIDRDOMAINUSUBJIDIDVARIDVARVALQNAMQLABELQVALQORIGQEVAL
CATHMHMHSEQ1MHCONFConfirmed by Medical RecordsYCollected—
CATHMHMHSEQ1MHFAMHXFamily HistoryYCollected—
CATHMHMHSEQ2MHFAMHXFamily HistoryNCollected—
CATHMHMHSEQ1MHCONFConfirmed by Medical RecordsNCollected—
CATHMHMHSEQ1MHFAMHXFamily HistoryNCollected—
CATHMHMHSEQ2MHCONFConfirmed by Medical RecordsYCollected—
CATHMHMHSEQ2MHFAMHXFamily HistoryYCollected—
Shaded columns are derived— = missing value

Human review and assessment

Your review

3 questions and your comments · View benchmark discussions

Mapping spec

Generated from the benchmark YAML; do not edit by hand

Variable NameVariable LabelTypeLengthControlled Terms or FormatOriginCoreConversion DefinitionVariable TypeVariable OrderComments for Define
STUDYIDStudy IdentifierCharCollectedCopy value from MH_RAW.STUDYID.SUPP1
RDOMAINRelated Domain AbbreviationCharAssignedSet constant value "MH".SUPP2
USUBJIDUnique Subject IdentifierCharCollectedCopy value from MH_RAW.USUBJID.SUPP3
IDVARIdentifying VariableCharAssignedSet constant value "MHSEQ".SUPP4
IDVARVALIdentifying Variable ValueCharCollectedCopy value from MH_RAW.MHSEQ.SUPP5
QNAMQualifier Variable NameCharMHFAMHX, MHCONFDerivedSet per constructed row; see the Row construction sheet.SUPP6
QLABELQualifier LabelCharDerivedSet per constructed row; see the Row construction sheet.SUPP7
QVALData ValueCharY, NDerivedSet per constructed row; see the Row construction sheet.SUPP8
QORIGOriginCharAssignedSet constant value "Collected".SUPP9
QEVALEvaluatorCharAssignedSet constant value "None".SUPP10
TemplateInclude whenQNAMQLABELQVAL
family_historyMH_RAW.MHFAMHX IS NOT NULLConstant "MHFAMHX"Constant "Family History"Copy MH_RAW.MHFAMHX
medical_record_confirmationMH_RAW.MHCONF IS NOT NULLConstant "MHCONF"Constant "Confirmed by Medical Records"Copy MH_RAW.MHCONF
VariablePermitted values
QNAMMHFAMHX, MHCONF
QVALY, N
VersionDateAuthorDescriptionReviewerSign-off
1.72026-10-20yamaa docs buildRead 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.62026-10-17yamaa docs buildDescribe collected date parts written as ISO 8601 date text and times of day counted in seconds since midnight
1.52026-10-17yamaa docs buildName 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.42026-10-15yamaa docs buildState datetime precision codes through the hour and minute, and complete only the time parts a collected datetime lacks
1.32026-09-29yamaa docs buildShow study codelist names, external dictionaries, and ISO 8601 formats in variable rows; list the document's codelist values and metadata
1.22026-09-29yamaa docs buildClassify ADaM copies from a declared input as Predecessor and recodes as Derived, and SDTM recodes of locally derived columns as Derived
1.12026-09-29yamaa docs buildResolve lookups into the donor record they select, and give every derivation shape a plain-language rule instead of its raw YAML
1.0yamaa docs buildInitial generation from spec.yaml

Agent prompt

The request an agent receives with the input files; each tier states no more than the one above

prompts/sdtm-suppmh-qualifiers/full.md

Edit
19 lines

Following CDISC SDTM standards, use the provided MH_RAW dataset to create a SUPPMH dataset with one record per collected qualifier.

The output dataset should contain the following columns in this order: STUDYID, RDOMAIN, USUBJID, IDVAR, IDVARVAL, QNAM, QLABEL, QVAL, QORIG, QEVAL

RDOMAIN is "MH" on every record. IDVAR is "MHSEQ" on every record. IDVARVAL is the parent record's sequence number, written as text. A parent record gives one record for each of its two qualifiers that was collected, so a parent record with only one qualifier collected gives only one record. On a record for the family history qualifier, QNAM is "MHFAMHX" and QLABEL is "Family History". On a record for the medical record confirmation qualifier, QNAM is "MHCONF" and QLABEL is "Confirmed by Medical Records". QVAL is the qualifier value collected on the parent record, "Y" or "N". QORIG is "Collected" on every record. QEVAL has no value on any record, since a collected value is not an assessment.

Read the source datasets from /app/input and save the completed dataset as /app/output/suppmh.csv.

prompts/sdtm-suppmh-qualifiers/conventions.md

Edit
16 lines

Following CDISC SDTM standards, use the provided MH_RAW dataset to create a SUPPMH dataset with one record per collected qualifier.

The output dataset should contain the following columns in this order: STUDYID, RDOMAIN, USUBJID, IDVAR, IDVARVAL, QNAM, QLABEL, QVAL, QORIG, QEVAL

RDOMAIN is "MH" on every record. IDVAR is "MHSEQ" on every record. IDVARVAL is the parent record's sequence number, written as text. On a record for the family history qualifier, QNAM is "MHFAMHX" and QLABEL is "Family History". On a record for the medical record confirmation qualifier, QNAM is "MHCONF" and QLABEL is "Confirmed by Medical Records". QVAL is "Y" or "N". QORIG is "Collected" on every record. QEVAL has no value on any record.

Read the source datasets from /app/input and save the completed dataset as /app/output/suppmh.csv.

prompts/sdtm-suppmh-qualifiers/brief.md

Edit
8 lines

Following CDISC SDTM standards, use the provided MH_RAW dataset to create a SUPPMH dataset with one record per collected qualifier.

The output dataset should contain the following columns in this order: STUDYID, RDOMAIN, USUBJID, IDVAR, IDVARVAL, QNAM, QLABEL, QVAL, QORIG, QEVAL

Read the source datasets from /app/input and save the completed dataset as /app/output/suppmh.csv.

yamaa code

Public calls generated from benchmark.yaml; results must match the expected output

R

Edit
3 lines
library(yamaa)yamaa_spec("spec.yaml")$run()$output

Python

Edit
3 lines
import yamaayamaa.spec("spec.yaml").run().output

Solution without yamaa

Written from the full prompt and the inputs alone; CI checks it reproduces the expected output

solutions/sdtm-suppmh-qualifiers/result.R

Edit
40 lines
# Reference solution for the yamaa benchmark sdtm-suppmh-qualifiers (R track).## Written from the benchmark's full prompt and its inputs alone, as an agent# would write it. Harbor's oracle agent runs it to check that the prompt can# be solved and that the grader scores a correct answer 1.library(dplyr, warn.conflicts = FALSE)library(readr)library(tidyr)mh <- read_csv(  "/app/input/mh_raw.csv",  col_types = cols(.default = col_character()))suppmh <- mh |>  pivot_longer(    cols = c(MHFAMHX, MHCONF),    names_to = "QNAM",    values_to = "QVAL"  ) |>  filter(!is.na(QVAL) & QVAL != "") |>  mutate(    RDOMAIN = "MH",    IDVAR = "MHSEQ",    IDVARVAL = MHSEQ,    QLABEL = case_when(      QNAM == "MHFAMHX" ~ "Family History",      QNAM == "MHCONF" ~ "Confirmed by Medical Records"    ),    QORIG = "Collected",    QEVAL = NA_character_  ) |>  arrange(USUBJID, suppressWarnings(as.integer(MHSEQ)), QNAM) |>  select(    STUDYID, RDOMAIN, USUBJID, IDVAR, IDVARVAL, QNAM, QLABEL, QVAL, QORIG, QEVAL  )dir.create("/app/output", showWarnings = FALSE)write_csv(suppmh, "/app/output/suppmh.csv", na = "")

solutions/sdtm-suppmh-qualifiers/result.py

Edit
73 lines
# Reference solution for the yamaa benchmark sdtm-suppmh-qualifiers (Python track).## Written from the benchmark's full prompt and its inputs alone, as an agent# would write it. Harbor's oracle agent runs it to check that the prompt can# be solved and that the grader scores a correct answer 1."""Build the SUPPMH dataset from MH_RAW.One SUPPMH record per collected qualifier on each parent MH record.The two qualifiers are family history (MHFAMHX) and confirmation bymedical records (MHCONF). A qualifier that was not collected on theparent record (empty value) gives no SUPPMH record."""import csvimport osINPUT_DIR = "/app/input"OUTPUT_DIR = "/app/output"QUALIFIERS = [    ("MHFAMHX", "MHFAMHX", "Family History"),    ("MHCONF", "MHCONF", "Confirmed by Medical Records"),]COLUMNS = [    "STUDYID",    "RDOMAIN",    "USUBJID",    "IDVAR",    "IDVARVAL",    "QNAM",    "QLABEL",    "QVAL",    "QORIG",    "QEVAL",]def main():    with open(os.path.join(INPUT_DIR, "mh_raw.csv"), newline="") as f:        parents = list(csv.DictReader(f))    rows = []    for parent in parents:        for source_col, qnam, qlabel in QUALIFIERS:            qval = (parent.get(source_col) or "").strip()            if qval == "":                continue            rows.append(                {                    "STUDYID": parent["STUDYID"],                    "RDOMAIN": "MH",                    "USUBJID": parent["USUBJID"],                    "IDVAR": "MHSEQ",                    "IDVARVAL": str(parent["MHSEQ"]),                    "QNAM": qnam,                    "QLABEL": qlabel,                    "QVAL": qval,                    "QORIG": "Collected",                    "QEVAL": "",                }            )    os.makedirs(OUTPUT_DIR, exist_ok=True)    with open(os.path.join(OUTPUT_DIR, "suppmh.csv"), "w", newline="") as f:        writer = csv.DictWriter(f, fieldnames=COLUMNS)        writer.writeheader()        writer.writerows(rows)if __name__ == "__main__":    main()

solutions/sdtm-suppmh-qualifiers/result.sas

Edit
18 lines
/* opensas reference solution for the yamaa benchmark sdtm-suppmh-qualifiers.   Reads the benchmark inputs and derives the requested output.   Execute with the existing opensas runtime: opensas /app/output/result.sas. */data mh_raw;  length STUDYID USUBJID MHTERM MHFAMHX MHCONF $1024;  infile "/app/input/mh_raw.csv" dsd dlm="," firstobs=2 truncover lrecl=32767;  input STUDYID : $char1024. USUBJID : $char1024. MHSEQ MHTERM : $char1024. MHFAMHX : $char1024. MHCONF : $char1024.;run;data qualified; set mh_raw; run;data result; set qualified; length RDOMAIN IDVAR IDVARVAL QNAM QLABEL QVAL QORIG QEVAL $1024; RDOMAIN='MH'; IDVAR='MHSEQ'; IDVARVAL=strip(put(MHSEQ,best32.)); QORIG='Collected'; QEVAL='';if not missing(MHFAMHX) then do; QNAM='MHFAMHX'; QLABEL='Family History'; QVAL=MHFAMHX; output; end;if not missing(MHCONF) then do; QNAM='MHCONF'; QLABEL='Confirmed by Medical Records'; QVAL=MHCONF; output; end; run;proc sql;  create table final as select STUDYID, RDOMAIN, USUBJID, IDVAR, IDVARVAL, QNAM, QLABEL, QVAL, QORIG, QEVAL from result;quit;proc export data=final outfile="/app/output/suppmh.csv" dbms=csv replace; run;