Demographics Submitted in SAS Transport with SDTMIG 3.3

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: build one DM record per subject carrying RFSTDTC, SITEID, AGE, AGEU, SEX, RACE and COUNTRY, and submit it as the SAS transport file dm.xpt beside its data-definition document.

Input: one row per subject carrying the site, reference start date, age, sex, race and country.

Variables:

RFSTDTC is the subject's reference start date; empty when the subject has none.
SITEID is the collected site identifier.
AGE is the collected age in whole years.
AGEU is fixed to YEARS.
SEX, RACE and COUNTRY are as collected.

Note: in the transport file each text variable is exactly as wide as its longest value, and the data-definition document reports that width as the variable's length instead of the largest length the study allows. A date travels as YYYY-MM-DD text, and an empty value is blanks.

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

YAML specification

1 spec file

spec.yaml

Edit171 lines

1yamaa: "1.0"2type: spec3model: SDTM4domain: DM5keys: [STUDYID, USUBJID]6input:7  DM_RAW: input/dm_raw.csv89output:10  path: dm.csv11  columns: [DOMAIN, STUDYID, USUBJID, SUBJID, RFSTDTC, SITEID, AGE, AGEU,12    SEX, RACE, COUNTRY]1314columns:15  - name: DOMAIN16    type: str17    label: Domain Abbreviation18    derivation: "'DM'"19    submission:20      core: Req21      role: Identifier22      length: 223      origins:24        - type: Assigned25          source: Sponsor2627  - name: STUDYID28    type: str29    label: Study Identifier30    derivation: DM_RAW.STUDYID31    submission:32      core: Req33      role: Identifier34      length: 2035      origins:36        - type: Protocol37          source: Sponsor3839  - name: USUBJID40    type: str41    label: Unique Subject Identifier42    derivation: DM_RAW.USUBJID43    submission:44      core: Req45      role: Identifier46      length: 3047      origins:48        - type: Assigned49          source: Sponsor5051  - name: SUBJID52    type: str53    label: Subject Identifier for the Study54    derivation: DM_RAW.SUBJID55    submission:56      core: Req57      role: Topic58      length: 1059      origins:60        - type: Collected61          source: Investigator62          documents:63            - document: acrf64              pages: {type: PhysicalRef, refs: "1"}6566  - name: RFSTDTC67    type: date68    label: Subject Reference Start Date/Time69    derivation: DM_RAW.RFSTDTC70    submission:71      core: Exp72      role: Record Qualifier73      origins:74        - type: Collected75          source: Investigator76          documents:77            - document: acrf78              pages: {type: PhysicalRef, refs: "1"}7980  - name: SITEID81    type: str82    label: Study Site Identifier83    derivation: DM_RAW.SITEID84    submission:85      core: Req86      role: Record Qualifier87      length: 1088      origins:89        - type: Collected90          source: Investigator91          documents:92            - document: acrf93              pages: {type: PhysicalRef, refs: "1"}9495  - name: AGE96    type: int97    label: Age98    derivation: DM_RAW.AGE99    submission:100      core: Exp101      role: Record Qualifier102      length: 3103      origins:104        - type: Collected105          source: Investigator106          documents:107            - document: acrf108              pages: {type: PhysicalRef, refs: "1"}109110  - name: AGEU111    type: str112    label: Age Units113    derivation: "'YEARS'"114    submission:115      core: Exp116      role: Variable Qualifier117      length: 6118      origins:119        - type: Assigned120          source: Sponsor121122  - name: SEX123    type: str124    label: Sex125    derivation: DM_RAW.SEX126    submission:127      core: Req128      role: Record Qualifier129      length: 1130      origins:131        - type: Collected132          source: Investigator133          documents:134            - document: acrf135              pages: {type: PhysicalRef, refs: "1"}136137  - name: RACE138    type: str139    label: Race140    derivation: DM_RAW.RACE141    submission:142      core: Exp143      role: Record Qualifier144      length: 40145      origins:146        - type: Collected147          source: Investigator148          documents:149            - document: acrf150              pages: {type: PhysicalRef, refs: "1"}151152  - name: COUNTRY153    type: str154    label: Country155    derivation: DM_RAW.COUNTRY156    submission:157      core: Req158      role: Record Qualifier159      length: 3160      origins:161        - type: Collected162          source: Investigator163          documents:164            - document: acrf165              pages: {type: PhysicalRef, refs: "1"}166167submission:168  label: Demographics169  class: SPECIAL PURPOSE170  structure: One record per subject171  repeating: false

Inputs

Under review1 source file

input/dm_raw.csv

Edit3 rows

input/dm_raw.csv
STUDYID	SUBJID	SITEID	RFSTDTC	AGE	SEX	RACE	COUNTRY
CATH	0001	UCSD	2025-01-08	34	F	WHITE	USA
CATH	0002	UCSD	2025-01-15	67	M	BLACK OR AFRICAN AMERICAN	USA
CATH	0003	MCGILL	—	52	F	ASIAN	CAN

Expected output

Under review3 expected rows

expected/define.xml

EditDefine-XML

Define-XML 2.1.11: CATH

Example study submitting demographics in SAS transport; CATH-01; SDTMIG 3.3

Datasets
Dataset	Description	Class	Structure	Purpose	Keys	Documentation	Location
DM	Demographics	SPECIAL PURPOSE	One record per subject	Tabulation	STUDYID, USUBJID		dm.xpt

DM

DM variables
Variable	Label / Description	Type	Role	Length or Display Format	Controlled Terms or ISO Format	Origin / Source / Method / Comment
DOMAIN	Domain Abbreviation	text	Identifier	2		Assigned; Sponsor
STUDYID	Study Identifier	text	Identifier	4		Protocol; Sponsor
USUBJID	Unique Subject Identifier	text	Identifier	16		Assigned; Sponsor
SUBJID	Subject Identifier for the Study	text	Topic	4		Collected; Investigator; Annotated Case Report Form (acrf.pdf); pages 1
RFSTDTC	Subject Reference Start Date/Time	date	Record Qualifier		ISO 8601	Collected; Investigator; Annotated Case Report Form (acrf.pdf); pages 1
SITEID	Study Site Identifier	text	Record Qualifier	6		Collected; Investigator; Annotated Case Report Form (acrf.pdf); pages 1
AGE	Age	integer	Record Qualifier	3		Collected; Investigator; Annotated Case Report Form (acrf.pdf); pages 1
AGEU	Age Units	text	Variable Qualifier	5		Assigned; Sponsor
SEX	Sex	text	Record Qualifier	1		Collected; Investigator; Annotated Case Report Form (acrf.pdf); pages 1
RACE	Race	text	Record Qualifier	25		Collected; Investigator; Annotated Case Report Form (acrf.pdf); pages 1
COUNTRY	Country	text	Record Qualifier	3		Collected; Investigator; Annotated Case Report Form (acrf.pdf); pages 1

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.sdtm.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 demographics in SAS transport</StudyDescription>
      <ProtocolName>CATH-01</ProtocolName>
    </GlobalVariables>
    <MetaDataVersion OID="MDV.CATH.sdtm" Name="CATH sdtm metadata" def:DefineVersion="2.1.11">
      <def:Standards>
        <def:Standard OID="STD.SDTMIG" Name="SDTMIG" Type="IG" Version="3.3" Status="Final"/>
      </def:Standards>
      <def:AnnotatedCRF>
        <def:DocumentRef leafID="LF.acrf"/>
      </def:AnnotatedCRF>
      <ItemGroupDef OID="IG.DM" Name="DM" Domain="DM" Purpose="Tabulation" SASDatasetName="DM" Repeating="No" IsReferenceData="No" def:Structure="One record per subject" def:ArchiveLocationID="LF.DM" def:StandardOID="STD.SDTMIG">
        <Description>
          <TranslatedText xml:lang="en">Demographics</TranslatedText>
        </Description>
        <ItemRef ItemOID="IT.DM.DOMAIN" OrderNumber="1" Mandatory="Yes" Role="Identifier"/>
        <ItemRef ItemOID="IT.DM.STUDYID" OrderNumber="2" Mandatory="Yes" KeySequence="1" Role="Identifier"/>
        <ItemRef ItemOID="IT.DM.USUBJID" OrderNumber="3" Mandatory="Yes" KeySequence="2" Role="Identifier"/>
        <ItemRef ItemOID="IT.DM.SUBJID" OrderNumber="4" Mandatory="Yes" Role="Topic"/>
        <ItemRef ItemOID="IT.DM.RFSTDTC" OrderNumber="5" Mandatory="No" Role="Record Qualifier"/>
        <ItemRef ItemOID="IT.DM.SITEID" OrderNumber="6" Mandatory="Yes" Role="Record Qualifier"/>
        <ItemRef ItemOID="IT.DM.AGE" OrderNumber="7" Mandatory="No" Role="Record Qualifier"/>
        <ItemRef ItemOID="IT.DM.AGEU" OrderNumber="8" Mandatory="No" Role="Variable Qualifier"/>
        <ItemRef ItemOID="IT.DM.SEX" OrderNumber="9" Mandatory="Yes" Role="Record Qualifier"/>
        <ItemRef ItemOID="IT.DM.RACE" OrderNumber="10" Mandatory="No" Role="Record Qualifier"/>
        <ItemRef ItemOID="IT.DM.COUNTRY" OrderNumber="11" Mandatory="Yes" Role="Record Qualifier"/>
        <def:Class Name="SPECIAL PURPOSE"/>
        <def:leaf ID="LF.DM" xlink:href="dm.xpt">
          <def:title>dm.xpt</def:title>
        </def:leaf>
      </ItemGroupDef>
      <ItemDef OID="IT.DM.DOMAIN" Name="DOMAIN" DataType="text" Length="2" SASFieldName="DOMAIN">
        <Description>
          <TranslatedText xml:lang="en">Domain Abbreviation</TranslatedText>
        </Description>
        <def:Origin Type="Assigned" Source="Sponsor"/>
      </ItemDef>
      <ItemDef OID="IT.DM.STUDYID" Name="STUDYID" DataType="text" Length="4" SASFieldName="STUDYID">
        <Description>
          <TranslatedText xml:lang="en">Study Identifier</TranslatedText>
        </Description>
        <def:Origin Type="Protocol" Source="Sponsor"/>
      </ItemDef>
      <ItemDef OID="IT.DM.USUBJID" Name="USUBJID" DataType="text" Length="16" SASFieldName="USUBJID">
        <Description>
          <TranslatedText xml:lang="en">Unique Subject Identifier</TranslatedText>
        </Description>
        <def:Origin Type="Assigned" Source="Sponsor"/>
      </ItemDef>
      <ItemDef OID="IT.DM.SUBJID" Name="SUBJID" DataType="text" Length="4" SASFieldName="SUBJID">
        <Description>
          <TranslatedText xml:lang="en">Subject Identifier for the Study</TranslatedText>
        </Description>
        <def:Origin Type="Collected" Source="Investigator">
          <def:DocumentRef leafID="LF.acrf">
            <def:PDFPageRef PageRefs="1" Type="PhysicalRef"/>
          </def:DocumentRef>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.DM.RFSTDTC" Name="RFSTDTC" DataType="date" SASFieldName="RFSTDTC">
        <Description>
          <TranslatedText xml:lang="en">Subject Reference Start Date/Time</TranslatedText>
        </Description>
        <def:Origin Type="Collected" Source="Investigator">
          <def:DocumentRef leafID="LF.acrf">
            <def:PDFPageRef PageRefs="1" Type="PhysicalRef"/>
          </def:DocumentRef>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.DM.SITEID" Name="SITEID" DataType="text" Length="6" SASFieldName="SITEID">
        <Description>
          <TranslatedText xml:lang="en">Study Site Identifier</TranslatedText>
        </Description>
        <def:Origin Type="Collected" Source="Investigator">
          <def:DocumentRef leafID="LF.acrf">
            <def:PDFPageRef PageRefs="1" Type="PhysicalRef"/>
          </def:DocumentRef>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.DM.AGE" Name="AGE" DataType="integer" Length="3" SASFieldName="AGE">
        <Description>
          <TranslatedText xml:lang="en">Age</TranslatedText>
        </Description>
        <def:Origin Type="Collected" Source="Investigator">
          <def:DocumentRef leafID="LF.acrf">
            <def:PDFPageRef PageRefs="1" Type="PhysicalRef"/>
          </def:DocumentRef>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.DM.AGEU" Name="AGEU" DataType="text" Length="5" SASFieldName="AGEU">
        <Description>
          <TranslatedText xml:lang="en">Age Units</TranslatedText>
        </Description>
        <def:Origin Type="Assigned" Source="Sponsor"/>
      </ItemDef>
      <ItemDef OID="IT.DM.SEX" Name="SEX" DataType="text" Length="1" SASFieldName="SEX">
        <Description>
          <TranslatedText xml:lang="en">Sex</TranslatedText>
        </Description>
        <def:Origin Type="Collected" Source="Investigator">
          <def:DocumentRef leafID="LF.acrf">
            <def:PDFPageRef PageRefs="1" Type="PhysicalRef"/>
          </def:DocumentRef>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.DM.RACE" Name="RACE" DataType="text" Length="25" SASFieldName="RACE">
        <Description>
          <TranslatedText xml:lang="en">Race</TranslatedText>
        </Description>
        <def:Origin Type="Collected" Source="Investigator">
          <def:DocumentRef leafID="LF.acrf">
            <def:PDFPageRef PageRefs="1" Type="PhysicalRef"/>
          </def:DocumentRef>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.DM.COUNTRY" Name="COUNTRY" DataType="text" Length="3" SASFieldName="COUNTRY">
        <Description>
          <TranslatedText xml:lang="en">Country</TranslatedText>
        </Description>
        <def:Origin Type="Collected" Source="Investigator">
          <def:DocumentRef leafID="LF.acrf">
            <def:PDFPageRef PageRefs="1" Type="PhysicalRef"/>
          </def:DocumentRef>
        </def:Origin>
      </ItemDef>
      <def:leaf ID="LF.acrf" xlink:href="acrf.pdf">
        <def:title>Annotated Case Report Form</def:title>
      </def:leaf>
    </MetaDataVersion>
  </Study>
</ODM>

expected/dm.csv

Edit3 rows

expected/dm.csv
DOMAIN	STUDYID	SUBJID	RFSTDTC	SITEID	AGE	AGEU	SEX	RACE	COUNTRY
DM	CATH	0001	2025-01-08	UCSD	34	YEARS	F	WHITE	USA
DM	CATH	0002	2025-01-15	UCSD	67	YEARS	M	BLACK OR AFRICAN AMERICAN	USA
DM	CATH	0003	—	MCGILL	52	YEARS	F	ASIAN	CAN

Shaded columns are derived— = missing value

Human review and assessment

Variable Name	Variable Label	Type	Length	Controlled Terms or Format	Origin	Core	Conversion Definition	Variable Type	Variable Order
DOMAIN	Domain Abbreviation	Char	2		Assigned	Req	Set constant value "DM".	SDTM	1
STUDYID	Study Identifier	Char	20		Protocol	Req	Copy value from DM_RAW.STUDYID.	SDTM	2
USUBJID	Unique Subject Identifier	Char	30		Assigned	Req	Copy value from DM_RAW.USUBJID.	SDTM	3
SUBJID	Subject Identifier for the Study	Char	10		Collected	Req	Copy value from DM_RAW.SUBJID.	SDTM	4
RFSTDTC	Subject Reference Start Date/Time	Char		ISO 8601	Collected	Exp	Copy value from DM_RAW.RFSTDTC.	SDTM	5
SITEID	Study Site Identifier	Char	10		Collected	Req	Copy value from DM_RAW.SITEID.	SDTM	6
AGE	Age	Num	3		Collected	Exp	Copy value from DM_RAW.AGE.	SDTM	7
AGEU	Age Units	Char	6		Assigned	Exp	Set constant value "YEARS".	SDTM	8
SEX	Sex	Char	1		Collected	Req	Copy value from DM_RAW.SEX.	SDTM	9
RACE	Race	Char	40		Collected	Exp	Copy value from DM_RAW.RACE.	SDTM	10
COUNTRY	Country	Char	3		Collected	Req	Copy value from DM_RAW.COUNTRY.	SDTM	11

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/sdtm-dm-sdtmig33/full.md

Edit13 lines

Following CDISC SDTM standards, use the provided DM_RAW dataset to create a DM dataset with one record per subject.

The output dataset should contain the following columns in this order: DOMAIN, STUDYID, USUBJID, SUBJID, RFSTDTC, SITEID, AGE, AGEU, SEX, RACE, COUNTRY

DOMAIN is "DM" and AGEU is "YEARS". RFSTDTC is the subject's reference start date and has no value when the subject has no reference start date.

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

prompts/sdtm-dm-sdtmig33/conventions.md

Edit11 lines

Following CDISC SDTM standards, use the provided DM_RAW dataset to create a DM dataset with one record per subject.

The output dataset should contain the following columns in this order: DOMAIN, STUDYID, USUBJID, SUBJID, RFSTDTC, SITEID, AGE, AGEU, SEX, RACE, COUNTRY

DOMAIN is "DM".

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

prompts/sdtm-dm-sdtmig33/brief.md

Edit9 lines

Following CDISC SDTM standards, use the provided DM_RAW dataset to create a DM dataset with one record per subject.

The output dataset should contain the following columns in this order: DOMAIN, STUDYID, USUBJID, SUBJID, RFSTDTC, SITEID, AGE, AGEU, SEX, RACE, COUNTRY

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

R

Edit3 lines

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

Python

Edit3 lines

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

solutions/sdtm-dm-sdtmig33/result.R

Edit29 lines

1# Create the SDTM Demographics domain from the supplied subject data.2source_path <- file.path("/app/input", "dm_raw.csv")3output_path <- file.path("/app/output", "dm.csv")45DM_RAW <- read.csv(source_path, colClasses = "character",6                   stringsAsFactors = FALSE, na.strings = "",7                   check.names = FALSE)8required <- c("STUDYID", "USUBJID", "SUBJID", "RFSTDTC", "SITEID",9              "AGE", "SEX", "RACE", "COUNTRY")10stopifnot(all(required %in% names(DM_RAW)),11          !anyNA(DM_RAW$USUBJID), !anyDuplicated(DM_RAW$USUBJID))1213DM <- data.frame(14  DOMAIN = rep("DM", nrow(DM_RAW)),15  STUDYID = DM_RAW$STUDYID,16  USUBJID = DM_RAW$USUBJID,17  SUBJID = DM_RAW$SUBJID,18  RFSTDTC = DM_RAW$RFSTDTC,19  SITEID = DM_RAW$SITEID,20  AGE = as.numeric(DM_RAW$AGE),21  AGEU = rep("YEARS", nrow(DM_RAW)),22  SEX = DM_RAW$SEX,23  RACE = DM_RAW$RACE,24  COUNTRY = DM_RAW$COUNTRY,25  stringsAsFactors = FALSE26)2728dir.create("/app/output", showWarnings = FALSE)29write.csv(DM, output_path, row.names = FALSE, na = "")

solutions/sdtm-dm-sdtmig33/result.py

Edit35 lines

1from pathlib import Path23import pandas as pd456def main():7    source = pd.read_csv(8        Path("/app/input/dm_raw.csv"), dtype=str, keep_default_na=False9    )10    dm = source.copy()11    dm["DOMAIN"] = "DM"12    dm["AGEU"] = "YEARS"13    columns = [14        "DOMAIN",15        "STUDYID",16        "USUBJID",17        "SUBJID",18        "RFSTDTC",19        "SITEID",20        "AGE",21        "AGEU",22        "SEX",23        "RACE",24        "COUNTRY",25    ]26    dm = dm.loc[:, columns].drop_duplicates()27    if dm["USUBJID"].duplicated().any():28        raise ValueError("Conflicting source records for a subject")29    output = Path("/app/output")30    output.mkdir(exist_ok=True)31    dm.to_csv(output / "dm.csv", index=False, na_rep="")323334if __name__ == "__main__":35    main()

solutions/sdtm-dm-sdtmig33/result.sas

Edit15 lines

1/* SDTM DM: preserve character identifiers and ISO 8601 reference dates. */2data dm;3    length DOMAIN $2 STUDYID $40 USUBJID $80 SUBJID $204           RFSTDTC $10 SITEID $20 AGE 8 AGEU $5 SEX $15           RACE $80 COUNTRY $3;6    infile '/app/input/dm_raw.csv' dsd dlm=',' firstobs=2 truncover;7    input STUDYID :$40. USUBJID :$80. SUBJID :$20.8          SITEID :$20. RFSTDTC :$10. AGE9          SEX :$1. RACE :$80. COUNTRY :$3.;10    DOMAIN = 'DM';11    AGEU = 'YEARS';12run;1314proc export data=dm outfile='/app/output/dm.csv' dbms=csv replace;15run;

input/dm_raw.csv

expected/define.xml

Define-XML 2.1.11: CATH

DM

expected/dm.csv

Your review

Mapping spec

Agent prompt

prompts/sdtm-dm-sdtmig33/full.md

prompts/sdtm-dm-sdtmig33/conventions.md

prompts/sdtm-dm-sdtmig33/brief.md

yamaa code

R

Python

Solution without yamaa

solutions/sdtm-dm-sdtmig33/result.R

solutions/sdtm-dm-sdtmig33/result.py

solutions/sdtm-dm-sdtmig33/result.sas