Subject-Level Analysis Data Submitted in SAS Transport with ADaMIG 1.2

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

EditUnder reviewWhat this benchmark means

README.md

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

Goal: carry TRT01A, AGE, HEIGHTBL, TRTSDT and TRTSDTM into ADSL and submit it as the SAS transport file adsl.xpt, with the dates as SAS numeric dates.

Input: one pre-analysis row per subject carrying the actual treatment, age, baseline height and the collected date and time of first exposure.

Variables:

TRT01A is the actual treatment.
AGE is the age in years, shown in three positions.
HEIGHTBL is the baseline height in centimetres, shown with one decimal; missing when not measured.
TRTSDT is the date part of TRTSDTM; missing when the subject was never treated.
TRTSDTM is the date and time of first exposure; missing when the subject was never treated.

Note: in the transport file TRTSDT counts days and TRTSDTM seconds from 1 January 1960, shown as DATE9. and DATETIME20., and the data-definition document describes both as eight-byte integers with those formats. Each text variable is exactly as wide as its longest value.

The project.yaml guide declaration is ADaMIG 1.2; the data-definition document records it and points to the SAS Transport version 5 dataset.

YAML specification

1 spec file

spec.yaml

Edit105 lines

1yamaa: "1.0"2type: spec3model: ADaM4domain: ADSL5keys: [STUDYID, USUBJID]6input:7  ADSL_RAW: input/adsl_raw.csv89output:10  path: adsl.csv11  columns: [STUDYID, USUBJID, TRT01A, AGE, HEIGHTBL, TRTSDT, TRTSDTM]1213columns:14  - name: STUDYID15    type: str16    label: Study Identifier17    derivation: ADSL_RAW.STUDYID18    submission:19      core: Req20      mandatory: true21      length: 2022      origins:23        - type: Predecessor24          description: ADSL_RAW.STUDYID2526  - name: USUBJID27    type: str28    label: Unique Subject Identifier29    derivation: ADSL_RAW.USUBJID30    submission:31      core: Req32      mandatory: true33      length: 3034      origins:35        - type: Predecessor36          description: ADSL_RAW.USUBJID3738  - name: TRT01A39    type: str40    label: Actual Treatment for Period 0141    derivation: ADSL_RAW.TRT01A42    submission:43      core: Cond44      mandatory: true45      length: 2046      origins:47        - type: Predecessor48          description: ADSL_RAW.TRT01A4950  - name: AGE51    type: int52    label: Age53    derivation: ADSL_RAW.AGE54    submission:55      core: Req56      mandatory: true57      length: 358      display_format: "3."59      origins:60        - type: Predecessor61          description: ADSL_RAW.AGE6263  - name: HEIGHTBL64    type: float65    label: Baseline Height (cm)66    derivation: ADSL_RAW.HEIGHTBL67    submission:68      core: Perm69      mandatory: false70      length: 571      significant_digits: 172      display_format: "5.1"73      origins:74        - type: Predecessor75          description: ADSL_RAW.HEIGHTBL7677  - name: TRTSDTM78    type: datetime79    label: Datetime of First Exposure to Treatment80    derivation: ADSL_RAW.TRTSDTC81    submission:82      core: Perm83      mandatory: false84      origins:85        - type: Predecessor86          description: ADSL_RAW.TRTSDTC8788  - name: TRTSDT89    type: date90    label: Date of First Exposure to Treatment91    derivation:92      to_date:93        source: TRTSDTM94    submission:95      core: Cond96      mandatory: false97      origins:98        - type: Derived99      method: Date part of TRTSDTM.100101submission:102  label: Subject-Level Analysis Dataset103  class: SUBJECT LEVEL ANALYSIS DATASET104  structure: One record per subject105  repeating: false

Inputs

Under review1 source file

input/adsl_raw.csv

Edit3 rows

input/adsl_raw.csv
STUDYID	TRT01A	AGE	HEIGHTBL	TRTSDTC
CATH	VITAMIN D3	34	172.5	2025-01-08T08:30
CATH	PLACEBO	67	—	2025-01-15T09:05:30
CATH	NOT TREATED	52	165.2	—

Expected output

Under review3 expected rows

expected/adsl.csv

Edit3 rows

expected/adsl.csv
STUDYID	TRT01A	AGE	HEIGHTBL	TRTSDT	TRTSDTM
CATH	VITAMIN D3	34	172.5	2025-01-08	2025-01-08T08:30:00
CATH	PLACEBO	67	—	2025-01-15	2025-01-15T09:05:30
CATH	NOT TREATED	52	165.2	—	—

expected/define.xml

EditDefine-XML

Define-XML 2.1.11: CATH

Example study submitting subject-level analysis data in SAS transport; CATH-01; ADaMIG 1.2

Datasets
Dataset	Description	Class	Structure	Purpose	Keys	Documentation	Location
ADSL	Subject-Level Analysis Dataset	SUBJECT LEVEL ANALYSIS DATASET	One record per subject	Analysis	STUDYID, USUBJID		adsl.xpt

ADSL

ADSL variables
Variable	Label / Description	Type	Length or Display Format	Origin / Source / Method / Comment
STUDYID	Study Identifier	text	4	Predecessor; ADSL_RAW.STUDYID
USUBJID	Unique Subject Identifier	text	16	Predecessor; ADSL_RAW.USUBJID
TRT01A	Actual Treatment for Period 01	text	11	Predecessor; ADSL_RAW.TRT01A
AGE	Age	integer	3.	Predecessor; ADSL_RAW.AGE
HEIGHTBL	Baseline Height (cm)	float	5.1	Predecessor; ADSL_RAW.HEIGHTBL
TRTSDT	Date of First Exposure to Treatment	integer	DATE9.	Derived; Sponsor Date part of TRTSDTM.
TRTSDTM	Datetime of First Exposure to Treatment	integer	DATETIME20.	Predecessor; ADSL_RAW.TRTSDTC

Original source

<?xml version="1.0" encoding="UTF-8"?>
<ODM xmlns="http://www.cdisc.org/ns/odm/v1.3" xmlns:def="http://www.cdisc.org/ns/def/v2.1" xmlns:xlink="http://www.w3.org/1999/xlink" ODMVersion="1.3.2" FileType="Snapshot" FileOID="CATH.adam.Define-XML_2.1" CreationDateTime="2026-09-11T00:00:00" SourceSystem="yamaa" SourceSystemVersion="1.0" def:Context="Submission">
  <Study OID="STDY.CATH">
    <GlobalVariables>
      <StudyName>CATH</StudyName>
      <StudyDescription>Example study submitting subject-level analysis data in SAS transport</StudyDescription>
      <ProtocolName>CATH-01</ProtocolName>
    </GlobalVariables>
    <MetaDataVersion OID="MDV.CATH.adam" Name="CATH adam metadata" def:DefineVersion="2.1.11">
      <def:Standards>
        <def:Standard OID="STD.ADaMIG" Name="ADaMIG" Type="IG" Version="1.2" Status="Final"/>
      </def:Standards>
      <ItemGroupDef OID="IG.ADSL" Name="ADSL" Purpose="Analysis" SASDatasetName="ADSL" Repeating="No" IsReferenceData="No" def:Structure="One record per subject" def:ArchiveLocationID="LF.ADSL" def:StandardOID="STD.ADaMIG">
        <Description>
          <TranslatedText xml:lang="en">Subject-Level Analysis Dataset</TranslatedText>
        </Description>
        <ItemRef ItemOID="IT.ADSL.STUDYID" OrderNumber="1" Mandatory="Yes" KeySequence="1"/>
        <ItemRef ItemOID="IT.ADSL.USUBJID" OrderNumber="2" Mandatory="Yes" KeySequence="2"/>
        <ItemRef ItemOID="IT.ADSL.TRT01A" OrderNumber="3" Mandatory="Yes"/>
        <ItemRef ItemOID="IT.ADSL.AGE" OrderNumber="4" Mandatory="Yes"/>
        <ItemRef ItemOID="IT.ADSL.HEIGHTBL" OrderNumber="5" Mandatory="No"/>
        <ItemRef ItemOID="IT.ADSL.TRTSDT" OrderNumber="6" Mandatory="No" MethodOID="MT.ADSL.TRTSDT"/>
        <ItemRef ItemOID="IT.ADSL.TRTSDTM" OrderNumber="7" Mandatory="No"/>
        <def:Class Name="SUBJECT LEVEL ANALYSIS DATASET"/>
        <def:leaf ID="LF.ADSL" xlink:href="adsl.xpt">
          <def:title>adsl.xpt</def:title>
        </def:leaf>
      </ItemGroupDef>
      <ItemDef OID="IT.ADSL.STUDYID" Name="STUDYID" DataType="text" Length="4" SASFieldName="STUDYID">
        <Description>
          <TranslatedText xml:lang="en">Study Identifier</TranslatedText>
        </Description>
        <def:Origin Type="Predecessor">
          <Description>
            <TranslatedText xml:lang="en">ADSL_RAW.STUDYID</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.ADSL.USUBJID" Name="USUBJID" DataType="text" Length="16" SASFieldName="USUBJID">
        <Description>
          <TranslatedText xml:lang="en">Unique Subject Identifier</TranslatedText>
        </Description>
        <def:Origin Type="Predecessor">
          <Description>
            <TranslatedText xml:lang="en">ADSL_RAW.USUBJID</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.ADSL.TRT01A" Name="TRT01A" DataType="text" Length="11" SASFieldName="TRT01A">
        <Description>
          <TranslatedText xml:lang="en">Actual Treatment for Period 01</TranslatedText>
        </Description>
        <def:Origin Type="Predecessor">
          <Description>
            <TranslatedText xml:lang="en">ADSL_RAW.TRT01A</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.ADSL.AGE" Name="AGE" DataType="integer" Length="3" SASFieldName="AGE" def:DisplayFormat="3.">
        <Description>
          <TranslatedText xml:lang="en">Age</TranslatedText>
        </Description>
        <def:Origin Type="Predecessor">
          <Description>
            <TranslatedText xml:lang="en">ADSL_RAW.AGE</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.ADSL.HEIGHTBL" Name="HEIGHTBL" DataType="float" Length="5" SignificantDigits="1" SASFieldName="HEIGHTBL" def:DisplayFormat="5.1">
        <Description>
          <TranslatedText xml:lang="en">Baseline Height (cm)</TranslatedText>
        </Description>
        <def:Origin Type="Predecessor">
          <Description>
            <TranslatedText xml:lang="en">ADSL_RAW.HEIGHTBL</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.ADSL.TRTSDT" Name="TRTSDT" DataType="integer" Length="8" SASFieldName="TRTSDT" def:DisplayFormat="DATE9.">
        <Description>
          <TranslatedText xml:lang="en">Date of First Exposure to Treatment</TranslatedText>
        </Description>
        <def:Origin Type="Derived" Source="Sponsor"/>
      </ItemDef>
      <ItemDef OID="IT.ADSL.TRTSDTM" Name="TRTSDTM" DataType="integer" Length="8" SASFieldName="TRTSDTM" def:DisplayFormat="DATETIME20.">
        <Description>
          <TranslatedText xml:lang="en">Datetime of First Exposure to Treatment</TranslatedText>
        </Description>
        <def:Origin Type="Predecessor">
          <Description>
            <TranslatedText xml:lang="en">ADSL_RAW.TRTSDTC</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <MethodDef OID="MT.ADSL.TRTSDT" Name="ADSL.TRTSDT" Type="Computation">
        <Description>
          <TranslatedText xml:lang="en">Date part of TRTSDTM.</TranslatedText>
        </Description>
      </MethodDef>
    </MetaDataVersion>
  </Study>
</ODM>

Shaded columns are derived— = missing value

Human review and assessment

Dataset Name	Variable Name	Variable Label	Type	Codelist/Controlled Terms	Core	Computational Method	Origin
ADSL	STUDYID	Study Identifier	character		Req	Copy value from ADSL_RAW.STUDYID.	Predecessor
ADSL	USUBJID	Unique Subject Identifier	character		Req	Copy value from ADSL_RAW.USUBJID.	Predecessor
ADSL	TRT01A	Actual Treatment for Period 01	character		Cond	Copy value from ADSL_RAW.TRT01A.	Predecessor
ADSL	AGE	Age	numeric		Req	Copy value from ADSL_RAW.AGE.	Predecessor
ADSL	HEIGHTBL	Baseline Height (cm)	numeric		Perm	Copy value from ADSL_RAW.HEIGHTBL.	Predecessor
ADSL	TRTSDTM	Datetime of First Exposure to Treatment	numeric	ISO 8601	Perm	Copy value from ADSL_RAW.TRTSDTC.	Predecessor
ADSL	TRTSDT	Date of First Exposure to Treatment	numeric	ISO 8601	Cond	Date part of TRTSDTM.	Derived

Version	Date	Author	Description
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

prompts/adam-adsl-adamig12/full.md

Edit13 lines

Following CDISC ADaM standards, use the provided ADSL_RAW dataset to create an ADSL dataset with one record per subject.

The output dataset should contain the following columns in this order: STUDYID, USUBJID, TRT01A, AGE, HEIGHTBL, TRTSDT, TRTSDTM

Use ADaMIG 1.2. TRTSDTM is the first-exposure date and time in ADSL_RAW.TRTSDTC, shown as "YYYY-MM-DDThh:mm:ss", with seconds "00" when the source omits seconds. TRTSDT is the calendar date part of TRTSDTM. TRTSDT and TRTSDTM have no value when the subject was never treated.

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

prompts/adam-adsl-adamig12/conventions.md

Edit11 lines

Following CDISC ADaM standards, use the provided ADSL_RAW dataset to create an ADSL dataset with one record per subject.

The output dataset should contain the following columns in this order: STUDYID, USUBJID, TRT01A, AGE, HEIGHTBL, TRTSDT, TRTSDTM

Use ADaMIG 1.2. TRTSDTM is shown as "YYYY-MM-DDThh:mm:ss". TRTSDT and TRTSDTM can have no value.

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

prompts/adam-adsl-adamig12/brief.md

Edit8 lines

Following CDISC ADaM standards, use the provided ADSL_RAW dataset to create an ADSL dataset with one record per subject.

The output dataset should contain the following columns in this order: STUDYID, USUBJID, TRT01A, AGE, HEIGHTBL, TRTSDT, TRTSDTM

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

R

Edit3 lines

1library(yamaa)23yamaa_project("project.yaml")$spec("ADSL")$run()$output

Python

Edit3 lines

1import yamaa23yamaa.project("project.yaml").spec("ADSL").run().output

solutions/adam-adsl-adamig12/result.R

Edit38 lines

1# Derive ADSL from ADSL_RAW using the requested ADaMIG 1.2 variables.2raw <- read.csv("/app/input/adsl_raw.csv", stringsAsFactors = FALSE,3                check.names = FALSE, na.strings = "")4required <- c("STUDYID", "USUBJID", "TRT01A", "AGE", "HEIGHTBL", "TRTSDTC")5stopifnot(all(required %in% names(raw)))6stopifnot(!anyNA(raw$USUBJID), !anyDuplicated(raw$USUBJID))78source_datetime <- trimws(as.character(raw$TRTSDTC))9never_treated <- !is.na(raw$TRT01A) &10  toupper(trimws(raw$TRT01A)) == "NOT TREATED"11has_exposure <- !never_treated & !is.na(source_datetime) &12  nzchar(source_datetime)13trtsdtm <- rep(NA_character_, nrow(raw))1415if (any(has_exposure)) {16  values <- source_datetime[has_exposure]17  valid_shape <- grepl(18    "^[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}(:[0-9]{2})?$",19    values20  )21  if (!all(valid_shape)) stop("Exposure datetime has an unsupported format")22  values[nchar(values) == 16L] <- paste0(values[nchar(values) == 16L], ":00")23  parsed <- as.POSIXct(values, format = "%Y-%m-%dT%H:%M:%S", tz = "UTC")24  normalized <- format(parsed, "%Y-%m-%dT%H:%M:%S", tz = "UTC")25  if (anyNA(parsed) || !all(normalized == values)) {26    stop("Invalid exposure date or time")27  }28  trtsdtm[has_exposure] <- normalized29}3031adsl <- raw[c("STUDYID", "USUBJID", "TRT01A", "AGE", "HEIGHTBL")]32adsl$TRTSDT <- substr(trtsdtm, 1L, 10L)33adsl$TRTSDTM <- trtsdtm34stopifnot(nrow(adsl) == nrow(raw), !anyDuplicated(adsl$USUBJID))35stopifnot(all(is.na(adsl$TRTSDT[never_treated])),36          all(is.na(adsl$TRTSDTM[never_treated])))37dir.create("/app/output", showWarnings = FALSE)38write.csv(adsl, "/app/output/adsl.csv", row.names = FALSE, na = "")

solutions/adam-adsl-adamig12/result.py

Edit44 lines

1"""Create the requested ADaMIG 1.2 ADSL extract from ADSL_RAW."""23import csv4from datetime import datetime5from pathlib import Path678INPUT = Path("/app/input/adsl_raw.csv")9OUTPUT = Path("/app/output/adsl.csv")10COLUMNS = ["STUDYID", "USUBJID", "TRT01A", "AGE", "HEIGHTBL", "TRTSDT", "TRTSDTM"]111213def main():14    records = []15    subjects = set()16    with INPUT.open(newline="", encoding="utf-8-sig") as source:17        for raw in csv.DictReader(source):18            subject = (raw["STUDYID"], raw["USUBJID"])19            if subject in subjects:20                raise ValueError(21                    f"ADSL_RAW contains multiple records for subject {subject!r}"22                )23            subjects.add(subject)2425            record = {column: raw[column] for column in COLUMNS[:5]}26            treatment_start = raw["TRTSDTC"].strip()27            if treatment_start:28                timestamp = datetime.fromisoformat(treatment_start)29                record["TRTSDTM"] = timestamp.strftime("%Y-%m-%dT%H:%M:%S")30                record["TRTSDT"] = timestamp.date().isoformat()31            else:32                record["TRTSDT"] = ""33                record["TRTSDTM"] = ""34            records.append(record)3536    OUTPUT.parent.mkdir(parents=True, exist_ok=True)37    with OUTPUT.open("w", newline="", encoding="utf-8") as destination:38        writer = csv.DictWriter(destination, fieldnames=COLUMNS, lineterminator="\n")39        writer.writeheader()40        writer.writerows(records)414243if __name__ == "__main__":44    main()

solutions/adam-adsl-adamig12/result.sas

Edit41 lines

1/* Derive numeric ADaM treatment date and datetime values. */2proc import datafile='/app/input/adsl_raw.csv' out=adsl_raw dbms=csv replace;3    getnames=yes;4run;56data adsl;7    retain STUDYID USUBJID TRT01A AGE HEIGHTBL TRTSDT TRTSDTM;8    set adsl_raw;9    length _trtsdtc $19;10    format TRTSDT yymmdd10. TRTSDTM e8601dt19.;11    if not missing(TRTSDTC) then do;12        _trtsdtc=strip(TRTSDTC);13        if lengthn(_trtsdtc)=16 then _trtsdtc=cats(_trtsdtc,':00');14        TRTSDTM=input(_trtsdtc,e8601dt.);15        TRTSDT=datepart(TRTSDTM);16    end;17    else do;18        TRTSDT=.;19        TRTSDTM=.;20    end;21    keep STUDYID USUBJID TRT01A AGE HEIGHTBL TRTSDT TRTSDTM;22run;2324/* CSV export requires explicit formatted character representations. */25data adsl_csv;26    retain STUDYID USUBJID TRT01A AGE HEIGHTBL TRTSDT TRTSDTM;27    length STUDYID $200 USUBJID $200 TRT01A $200 AGE 8 HEIGHTBL 8 TRTSDT $10 TRTSDTM $19;28    set adsl(rename=(TRTSDT=_date TRTSDTM=_datetime));29    if not missing(_datetime) then do;30        TRTSDT=put(_date,yymmdd10.);31        TRTSDTM=put(_datetime,e8601dt19.);32    end;33    else do;34        TRTSDT='';35        TRTSDTM='';36    end;37    keep STUDYID USUBJID TRT01A AGE HEIGHTBL TRTSDT TRTSDTM;38run;3940proc export data=adsl_csv outfile='/app/output/adsl.csv' dbms=csv replace;41run;

input/adsl_raw.csv

expected/adsl.csv

expected/define.xml

Define-XML 2.1.11: CATH

ADSL

Your review

Mapping spec

Agent prompt

prompts/adam-adsl-adamig12/full.md

prompts/adam-adsl-adamig12/conventions.md

prompts/adam-adsl-adamig12/brief.md

yamaa code

R

Python

Solution without yamaa

solutions/adam-adsl-adamig12/result.R

solutions/adam-adsl-adamig12/result.py

solutions/adam-adsl-adamig12/result.sas