Analysis Start Time of an Adverse Event

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: derive each adverse event's analysis start date and time (ASTDTM), its date (ASTDT), its time of day (ASTTM) and the time imputation flag (ASTTMF), and submit them in a Dataset-JSON file with the data-definition document.

Input: SDTM adverse event (AE) records with the collected start (AESTDTC) as ISO 8601 text, collected to the second, the minute, the hour, the day or the month.

Variables:

AETERM is the adverse event as reported.
ASTDTM is the start date and time: a start collected to the hour or the minute takes zero for the rest of its time, and a start collected as a date alone takes midnight; missing when the start was not collected to the day.
ASTDT is the date part of ASTDTM; missing when ASTDTM is.
ASTTM is the time of day of ASTDTM counted in seconds since midnight, so 08:30:15 is 30615, and it is shown as hh:mm:ss; missing when ASTDTM is.
ASTTMF says which part of the start time was imputed: H when the start was collected without a time, M when it stops at the hour and S when it stops at the minute; blank when the time was collected to the second or there is no start.

Note: in the Dataset-JSON file and the data-definition document ASTTM is an eight-byte integer shown with the SAS format TIME8., beside ASTDT with DATE9. and ASTDTM with DATETIME20.. A time of zero flagged H is an imputed midnight rather than a collected one.

YAML specification

1 spec file

spec.yaml

Edit142 lines

1yamaa: "1.0"2type: spec3model: ADaM4domain: ADAE5keys: [STUDYID, USUBJID, AESEQ]6input:7  AE: {path: input/ae.csv, types: {AESEQ: int}}89output:10  path: adae.csv11  columns: [STUDYID, USUBJID, AESEQ, AETERM, ASTDTM, ASTDT, ASTTM, ASTTMF]1213columns:14  - name: STUDYID15    type: str16    label: Study Identifier17    derivation: AE.STUDYID18    submission:19      core: Req20      mandatory: true21      length: 2022      origins:23        - type: Predecessor24          description: AE.STUDYID2526  - name: USUBJID27    type: str28    label: Unique Subject Identifier29    derivation: AE.USUBJID30    submission:31      core: Req32      mandatory: true33      length: 3034      origins:35        - type: Predecessor36          description: AE.USUBJID3738  - name: AESEQ39    type: int40    label: Sequence Number41    derivation: AE.AESEQ42    submission:43      core: Req44      mandatory: true45      length: 846      origins:47        - type: Predecessor48          description: AE.AESEQ4950  - name: AETERM51    type: str52    label: Reported Term for the Adverse Event53    derivation: AE.AETERM54    submission:55      core: Req56      mandatory: true57      length: 20058      origins:59        - type: Predecessor60          description: AE.AETERM6162  # A start collected to the hour or minute takes zero for the rest of its63  # time, and a date alone takes midnight; a start without its day gives64  # none.65  - name: ASTDTM66    type: datetime67    label: Analysis Start Date/Time68    derivation:69      impute:70        type: datetime71        source: AE.AESTDTC72        time: first73    submission:74      core: Perm75      mandatory: false76      origins:77        - type: Derived78      method: AESTDTC completed with the earliest time its collected parts79        admit; missing when AESTDTC carries no complete date.8081  - name: ASTDT82    type: date83    label: Analysis Start Date84    derivation:85      to_date:86        source: ASTDTM87    submission:88      core: Cond89      mandatory: false90      origins:91        - type: Derived92      method: Date part of ASTDTM.9394  # The time of day of the start in seconds since midnight, shown as95  # hh:mm:ss.96  - name: ASTTM97    type: int98    label: Analysis Start Time99    derivation:100      time_of_day:101        source: ASTDTM102    submission:103      core: Perm104      mandatory: false105      length: 8106      display_format: TIME8.107      origins:108        - type: Derived109      method: Time part of ASTDTM as seconds since midnight.110111  - name: ASTTMF112    type: str113    label: Analysis Start Time Imputation Flag114    derivation:115      imputation_flag:116        source: ASTDTM117        part: time118    verifications:119      - allowed_values:120          values: [H, M, S]121    submission:122      core: Cond123      mandatory: false124      length: 1125      origins:126        - type: Derived127      method: H when the start was collected without a time, M when it stops128        at the hour and S when it stops at the minute.129130verifications:131  - row_count:132      min: 5133      max: 5134  - all_or_none:135      id: analysis-start-completeness136      columns: [ASTDTM, ASTDT, ASTTM]137138submission:139  label: Adverse Events Analysis Dataset140  class: OCCURRENCE DATA STRUCTURE141  structure: One record per adverse event142  repeating: true

Inputs

Under review1 source file

input/ae.csv

Edit5 rows

input/ae.csv
STUDYID	AESEQ	AETERM	AESTDTC
CATH	1	HEADACHE	2025-03-04T08:30:15
CATH	2	NAUSEA	2025-03-06T14:05
CATH	1	RASH	2025-03-10
CATH	2	DIZZINESS	2025-03
CATH	1	FATIGUE	2025-03-12T21

Expected output

Under review5 expected rows

expected/adae.csv

Edit5 rows

expected/adae.csv
STUDYID	AESEQ	AETERM	ASTDTM	ASTDT	ASTTM	ASTTMF
CATH	1	HEADACHE	2025-03-04T08:30:15	2025-03-04	30615	—
CATH	2	NAUSEA	2025-03-06T14:05:00	2025-03-06	50700	S
CATH	1	RASH	2025-03-10T00:00:00	2025-03-10	0	H
CATH	2	DIZZINESS	—	—	—	—
CATH	1	FATIGUE	2025-03-12T21:00:00	2025-03-12	75600	M

expected/adae.json

Edit

{
  "datasetJSONCreationDateTime": "2026-09-11T00:00:00",
  "datasetJSONVersion": "1.1.0",
  "fileOID": "CATH.adam.Define-XML_2.1.ADAE",
  "sourceSystem": {"name": "yamaa", "version": "1.0"},
  "studyOID": "STDY.CATH",
  "metaDataVersionOID": "MDV.CATH.adam",
  "metaDataRef": "define.xml",
  "itemGroupOID": "IG.ADAE",
  "records": 5,
  "name": "ADAE",
  "label": "Adverse Events Analysis Dataset",
  "columns": [
    {"itemOID": "IT.ADAE.STUDYID", "name": "STUDYID", "label": "Study Identifier", "dataType": "string", "length": 4, "keySequence": 1},
    {"itemOID": "IT.ADAE.USUBJID", "name": "USUBJID", "label": "Unique Subject Identifier", "dataType": "string", "length": 16, "keySequence": 2},
    {"itemOID": "IT.ADAE.AESEQ", "name": "AESEQ", "label": "Sequence Number", "dataType": "integer", "length": 8, "keySequence": 3},
    {"itemOID": "IT.ADAE.AETERM", "name": "AETERM", "label": "Reported Term for the Adverse Event", "dataType": "string", "length": 9},
    {"itemOID": "IT.ADAE.ASTDTM", "name": "ASTDTM", "label": "Analysis Start Date/Time", "dataType": "datetime", "targetDataType": "integer", "length": 8, "displayFormat": "DATETIME20."},
    {"itemOID": "IT.ADAE.ASTDT", "name": "ASTDT", "label": "Analysis Start Date", "dataType": "date", "targetDataType": "integer", "length": 8, "displayFormat": "DATE9."},
    {"itemOID": "IT.ADAE.ASTTM", "name": "ASTTM", "label": "Analysis Start Time", "dataType": "integer", "length": 8, "displayFormat": "TIME8."},
    {"itemOID": "IT.ADAE.ASTTMF", "name": "ASTTMF", "label": "Analysis Start Time Imputation Flag", "dataType": "string", "length": 1}
  ],
  "rows": [
    ["CATH", "CATH-UCSD-0001", 1, "HEADACHE", "2025-03-04T08:30:15", "2025-03-04", 30615, null],
    ["CATH", "CATH-UCSD-0001", 2, "NAUSEA", "2025-03-06T14:05:00", "2025-03-06", 50700, "S"],
    ["CATH", "CATH-UCSD-0002", 1, "RASH", "2025-03-10T00:00:00", "2025-03-10", 0, "H"],
    ["CATH", "CATH-UCSD-0002", 2, "DIZZINESS", null, null, null, null],
    ["CATH", "CATH-MCGILL-0003", 1, "FATIGUE", "2025-03-12T21:00:00", "2025-03-12", 75600, "M"]
  ]
}

expected/define.xml

EditDefine-XML

Define-XML 2.1.11: CATH

Example study submitting adverse event onset times in Dataset-JSON; CATH-01; ADaMIG 1.3

Datasets
Dataset	Description	Class	Structure	Purpose	Keys	Documentation	Location
ADAE	Adverse Events Analysis Dataset	OCCURRENCE DATA STRUCTURE	One record per adverse event	Analysis	STUDYID, USUBJID, AESEQ		adae.json

ADAE

ADAE variables
Variable	Label / Description	Type	Length or Display Format	Origin / Source / Method / Comment
STUDYID	Study Identifier	text	4	Predecessor; AE.STUDYID
USUBJID	Unique Subject Identifier	text	16	Predecessor; AE.USUBJID
AESEQ	Sequence Number	integer	8	Predecessor; AE.AESEQ
AETERM	Reported Term for the Adverse Event	text	9	Predecessor; AE.AETERM
ASTDTM	Analysis Start Date/Time	integer	DATETIME20.	Derived; Sponsor AESTDTC completed with the earliest time its collected parts admit; missing when AESTDTC carries no complete date.
ASTDT	Analysis Start Date	integer	DATE9.	Derived; Sponsor Date part of ASTDTM.
ASTTM	Analysis Start Time	integer	TIME8.	Derived; Sponsor Time part of ASTDTM as seconds since midnight.
ASTTMF	Analysis Start Time Imputation Flag	text	1	Derived; Sponsor H when the start was collected without a time, M when it stops at the hour and S when it stops at the minute.

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 adverse event onset times in Dataset-JSON</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.3" Status="Final"/>
      </def:Standards>
      <ItemGroupDef OID="IG.ADAE" Name="ADAE" Purpose="Analysis" SASDatasetName="ADAE" Repeating="Yes" IsReferenceData="No" def:Structure="One record per adverse event" def:ArchiveLocationID="LF.ADAE" def:StandardOID="STD.ADaMIG">
        <Description>
          <TranslatedText xml:lang="en">Adverse Events Analysis Dataset</TranslatedText>
        </Description>
        <ItemRef ItemOID="IT.ADAE.STUDYID" OrderNumber="1" Mandatory="Yes" KeySequence="1"/>
        <ItemRef ItemOID="IT.ADAE.USUBJID" OrderNumber="2" Mandatory="Yes" KeySequence="2"/>
        <ItemRef ItemOID="IT.ADAE.AESEQ" OrderNumber="3" Mandatory="Yes" KeySequence="3"/>
        <ItemRef ItemOID="IT.ADAE.AETERM" OrderNumber="4" Mandatory="Yes"/>
        <ItemRef ItemOID="IT.ADAE.ASTDTM" OrderNumber="5" Mandatory="No" MethodOID="MT.ADAE.ASTDTM"/>
        <ItemRef ItemOID="IT.ADAE.ASTDT" OrderNumber="6" Mandatory="No" MethodOID="MT.ADAE.ASTDT"/>
        <ItemRef ItemOID="IT.ADAE.ASTTM" OrderNumber="7" Mandatory="No" MethodOID="MT.ADAE.ASTTM"/>
        <ItemRef ItemOID="IT.ADAE.ASTTMF" OrderNumber="8" Mandatory="No" MethodOID="MT.ADAE.ASTTMF"/>
        <def:Class Name="OCCURRENCE DATA STRUCTURE"/>
        <def:leaf ID="LF.ADAE" xlink:href="adae.json">
          <def:title>adae.json</def:title>
        </def:leaf>
      </ItemGroupDef>
      <ItemDef OID="IT.ADAE.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">AE.STUDYID</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.ADAE.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">AE.USUBJID</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.ADAE.AESEQ" Name="AESEQ" DataType="integer" Length="8" SASFieldName="AESEQ">
        <Description>
          <TranslatedText xml:lang="en">Sequence Number</TranslatedText>
        </Description>
        <def:Origin Type="Predecessor">
          <Description>
            <TranslatedText xml:lang="en">AE.AESEQ</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.ADAE.AETERM" Name="AETERM" DataType="text" Length="9" SASFieldName="AETERM">
        <Description>
          <TranslatedText xml:lang="en">Reported Term for the Adverse Event</TranslatedText>
        </Description>
        <def:Origin Type="Predecessor">
          <Description>
            <TranslatedText xml:lang="en">AE.AETERM</TranslatedText>
          </Description>
        </def:Origin>
      </ItemDef>
      <ItemDef OID="IT.ADAE.ASTDTM" Name="ASTDTM" DataType="integer" Length="8" SASFieldName="ASTDTM" def:DisplayFormat="DATETIME20.">
        <Description>
          <TranslatedText xml:lang="en">Analysis Start Date/Time</TranslatedText>
        </Description>
        <def:Origin Type="Derived" Source="Sponsor"/>
      </ItemDef>
      <ItemDef OID="IT.ADAE.ASTDT" Name="ASTDT" DataType="integer" Length="8" SASFieldName="ASTDT" def:DisplayFormat="DATE9.">
        <Description>
          <TranslatedText xml:lang="en">Analysis Start Date</TranslatedText>
        </Description>
        <def:Origin Type="Derived" Source="Sponsor"/>
      </ItemDef>
      <ItemDef OID="IT.ADAE.ASTTM" Name="ASTTM" DataType="integer" Length="8" SASFieldName="ASTTM" def:DisplayFormat="TIME8.">
        <Description>
          <TranslatedText xml:lang="en">Analysis Start Time</TranslatedText>
        </Description>
        <def:Origin Type="Derived" Source="Sponsor"/>
      </ItemDef>
      <ItemDef OID="IT.ADAE.ASTTMF" Name="ASTTMF" DataType="text" Length="1" SASFieldName="ASTTMF">
        <Description>
          <TranslatedText xml:lang="en">Analysis Start Time Imputation Flag</TranslatedText>
        </Description>
        <def:Origin Type="Derived" Source="Sponsor"/>
      </ItemDef>
      <MethodDef OID="MT.ADAE.ASTDTM" Name="ADAE.ASTDTM" Type="Computation">
        <Description>
          <TranslatedText xml:lang="en">AESTDTC completed with the earliest time its collected parts admit; missing when AESTDTC carries no complete date.</TranslatedText>
        </Description>
      </MethodDef>
      <MethodDef OID="MT.ADAE.ASTDT" Name="ADAE.ASTDT" Type="Computation">
        <Description>
          <TranslatedText xml:lang="en">Date part of ASTDTM.</TranslatedText>
        </Description>
      </MethodDef>
      <MethodDef OID="MT.ADAE.ASTTM" Name="ADAE.ASTTM" Type="Computation">
        <Description>
          <TranslatedText xml:lang="en">Time part of ASTDTM as seconds since midnight.</TranslatedText>
        </Description>
      </MethodDef>
      <MethodDef OID="MT.ADAE.ASTTMF" Name="ADAE.ASTTMF" Type="Computation">
        <Description>
          <TranslatedText xml:lang="en">H when the start was collected without a time, M when it stops at the hour and S when it stops at the minute.</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
ADAE	STUDYID	Study Identifier	character		Req	Copy value from AE.STUDYID.	Predecessor
ADAE	USUBJID	Unique Subject Identifier	character		Req	Copy value from AE.USUBJID.	Predecessor
ADAE	AESEQ	Sequence Number	numeric		Req	Copy value from AE.AESEQ.	Predecessor
ADAE	AETERM	Reported Term for the Adverse Event	character		Req	Copy value from AE.AETERM.	Predecessor
ADAE	ASTDTM	Analysis Start Date/Time	numeric	ISO 8601	Perm	AESTDTC completed with the earliest time its collected parts admit; missing when AESTDTC carries no complete date.	Derived
ADAE	ASTDT	Analysis Start Date	numeric	ISO 8601	Cond	Date part of ASTDTM.	Derived
ADAE	ASTTM	Analysis Start Time	numeric		Perm	Time part of ASTDTM as seconds since midnight.	Derived
ADAE	ASTTMF	Analysis Start Time Imputation Flag	character	H, M, S	Cond	H when the start was collected without a time, M when it stops at the hour and S when it stops at the minute.	Derived

Variable	Permitted values
ASTTMF	H, M, S

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-adae-analysis-time/full.md

Edit22 lines

Following CDISC ADaM standards, use the provided AE dataset to create an ADAE dataset with one record per adverse event.

The output dataset should contain the following columns in this order: STUDYID, USUBJID, AESEQ, AETERM, ASTDTM, ASTDT, ASTTM, ASTTMF

ASTDTM is the analysis start date and time from AESTDTC, written as YYYY-MM-DDThh:mm:ss. A time collected to the second is used as collected. Each part of the time that was not collected takes its earliest value: a time collected to the minute gets second 00, a time collected to the hour gets minute and second 00, and a date alone starts at 00:00:00. A start collected without its day gives no ASTDTM. ASTDT is the date part of ASTDTM. ASTTM is the time of day of ASTDTM as a whole number of seconds since midnight, so 08:30:15 is 30615 and midnight is 0. ASTTMF names the first part of the time that was not collected and had to be imputed: H when the start was collected without a time, M when it stops at the hour, and S when it stops at the minute. ASTDT, ASTTM and ASTTMF have no value when there is no ASTDTM, and ASTTMF also has no value when the time was collected to the second.

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

prompts/adam-adae-analysis-time/conventions.md

Edit12 lines

Following CDISC ADaM standards, use the provided AE dataset to create an ADAE dataset with one record per adverse event.

The output dataset should contain the following columns in this order: STUDYID, USUBJID, AESEQ, AETERM, ASTDTM, ASTDT, ASTTM, ASTTMF

ASTTMF is H, M or S, or has no value. ASTDTM is written as YYYY-MM-DDThh:mm:ss, and ASTTM is a whole number of seconds since midnight.

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

prompts/adam-adae-analysis-time/brief.md

Edit8 lines

Following CDISC ADaM standards, use the provided AE dataset to create an ADAE dataset with one record per adverse event.

The output dataset should contain the following columns in this order: STUDYID, USUBJID, AESEQ, AETERM, ASTDTM, ASTDT, ASTTM, ASTTMF

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

R

Edit3 lines

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

Python

Edit3 lines

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

solutions/adam-adae-analysis-time/result.R

Edit52 lines

1# Reference solution for the yamaa benchmark adam-adae-analysis-time (R track).2#3# Written from the benchmark's full prompt and its inputs alone, as an agent4# would write it. Harbor's oracle agent runs it to check that the prompt can5# be solved and that the grader scores a correct answer 1.67library(dplyr, warn.conflicts = FALSE)8library(readr)910ae <- read_csv(11  "/app/input/ae.csv",12  col_types = cols(AESEQ = col_integer(), .default = col_character())13)1415# Complete a collected start by its length: the missing parts of the time16# take their earliest values. A start without its day, or no start at all,17# gives no analysis time.18complete_start <- function(x) {19  n <- nchar(x)20  case_when(21    n == 19 ~ x,22    n == 16 ~ paste0(x, ":00"),23    n == 13 ~ paste0(x, ":00:00"),24    n == 10 ~ paste0(x, "T00:00:00"),25    TRUE ~ NA_character_26  )27}2829# The flag names the coarsest part of the time that was supplied.30time_flag <- function(x) {31  n <- nchar(x)32  case_when(33    n == 16 ~ "S",34    n == 13 ~ "M",35    n == 10 ~ "H",36    TRUE ~ NA_character_37  )38}3940adae <- ae |>41  mutate(42    ASTDTM = complete_start(AESTDTC),43    ASTDT = substr(ASTDTM, 1, 10),44    ASTTM = as.integer(substr(ASTDTM, 12, 13)) * 3600L +45      as.integer(substr(ASTDTM, 15, 16)) * 60L +46      as.integer(substr(ASTDTM, 18, 19)),47    ASTTMF = time_flag(AESTDTC)48  ) |>49  select(STUDYID, USUBJID, AESEQ, AETERM, ASTDTM, ASTDT, ASTTM, ASTTMF)5051dir.create("/app/output", showWarnings = FALSE)52write_csv(adae, "/app/output/adae.csv", na = "")

solutions/adam-adae-analysis-time/result.py

Edit58 lines

1# Reference solution for the yamaa benchmark adam-adae-analysis-time (Python track).2#3# Written from the benchmark's full prompt and its inputs alone, as an agent4# would write it. Harbor's oracle agent runs it to check that the prompt can5# be solved and that the grader scores a correct answer 1.67from pathlib import Path89import polars as pl1011ae = pl.read_csv("/app/input/ae.csv", infer_schema=False).with_columns(12    pl.col("AESEQ").cast(pl.Int64)13)1415# What a collected start is missing, by its length, with the flag that names16# the coarsest part supplied. A time to the second needs nothing.17FIRST = {19: ("", None), 16: (":00", "S"), 13: (":00:00", "M"), 10: ("T00:00:00", "H")}1819rows = []20for record in ae.iter_rows(named=True):21    collected = record["AESTDTC"]22    astdtm = astdt = asttm = asttmf = None23    # A start without its day, or no start at all, gives no analysis time.24    if collected is not None and len(collected) in FIRST:25        suffix, asttmf = FIRST[len(collected)]26        astdtm = collected + suffix27        astdt = astdtm[:10]28        hours, minutes, seconds = (int(part) for part in astdtm[11:].split(":"))29        asttm = hours * 3600 + minutes * 60 + seconds30    rows.append(31        {32            "STUDYID": record["STUDYID"],33            "USUBJID": record["USUBJID"],34            "AESEQ": record["AESEQ"],35            "AETERM": record["AETERM"],36            "ASTDTM": astdtm,37            "ASTDT": astdt,38            "ASTTM": asttm,39            "ASTTMF": asttmf,40        }41    )4243adae = pl.DataFrame(44    rows,45    schema={46        "STUDYID": pl.String,47        "USUBJID": pl.String,48        "AESEQ": pl.Int64,49        "AETERM": pl.String,50        "ASTDTM": pl.String,51        "ASTDT": pl.String,52        "ASTTM": pl.Int64,53        "ASTTMF": pl.String,54    },55)5657Path("/app/output").mkdir(exist_ok=True)58adae.write_csv("/app/output/adae.csv")

solutions/adam-adae-analysis-time/result.sas

Edit35 lines

1/* opensas reference solution for the yamaa benchmark adam-adae-analysis-time.2   Reads the benchmark inputs and derives the requested output.3   Execute with the existing opensas runtime: opensas /app/output/result.sas. */45data ae;6  length STUDYID USUBJID AETERM AESTDTC $1024;7  infile "/app/input/ae.csv" dsd dlm="," firstobs=2 truncover lrecl=32767;8  input STUDYID : $char1024. USUBJID : $char1024. AESEQ AETERM : $char1024. AESTDTC : $char1024.;9run;1011/* Complete each collected start by its length: the missing parts of the time12   take their earliest values, and the flag names the coarsest part supplied.13   A start without its day, or no start, gives no analysis time. The time of14   day counts the seconds since midnight. */15data result;16  length ASTDTM $19 ASTDT $10 ASTTMF $1;17  set ae;18  ASTDTM=''; ASTDT=''; ASTTMF=''; ASTTM=.;19  ls=lengthn(AESTDTC);20  if ls=19 then ASTDTM=AESTDTC;21  else if ls=16 then do; ASTDTM=cats(AESTDTC, ':00'); ASTTMF='S'; end;22  else if ls=13 then do; ASTDTM=cats(AESTDTC, ':00:00'); ASTTMF='M'; end;23  else if ls=10 then do; ASTDTM=cats(AESTDTC, 'T00:00:00'); ASTTMF='H'; end;24  if ASTDTM ne '' then do;25    ASTDT=substr(ASTDTM, 1, 10);26    ASTTM=input(substr(ASTDTM, 12, 2), 2.)*3600 + input(substr(ASTDTM, 15, 2), 2.)*6027      + input(substr(ASTDTM, 18, 2), 2.);28  end;29run;3031proc sql;32  create table final as select STUDYID, USUBJID, AESEQ, AETERM, ASTDTM, ASTDT, ASTTM, ASTTMF33    from result;34quit;35proc export data=final outfile="/app/output/adae.csv" dbms=csv replace; run;

input/ae.csv

expected/adae.csv

expected/adae.json

expected/define.xml

Define-XML 2.1.11: CATH

ADAE

Your review

Mapping spec

Agent prompt

prompts/adam-adae-analysis-time/full.md

prompts/adam-adae-analysis-time/conventions.md

prompts/adam-adae-analysis-time/brief.md

yamaa code

R

Python

Solution without yamaa

solutions/adam-adae-analysis-time/result.R

solutions/adam-adae-analysis-time/result.py

solutions/adam-adae-analysis-time/result.sas