Analysis Start Time of an Adverse Event with ADaMIG 1.1

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 SAS Transport version 5 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: the SAS Transport file stores ASTTM as an eight-byte numeric value with the SAS format TIME8., beside ASTDT with DATE9. and ASTDTM with DATETIME20.. The data-definition document records these formats. A time of zero flagged H is an imputed midnight rather than a collected one.

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

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/define.xml

EditDefine-XML

Define-XML 2.1.11: CATH

Example study submitting adverse event onset times in SAS transport; CATH-01; ADaMIG 1.1

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.xpt

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 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.1" 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.xpt">
          <def:title>adae.xpt</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-adamig11/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 start date and time from AESTDTC: a start collected to the second has its collected value, a start collected to the minute has seconds 00, a start collected to the hour has minutes and seconds 00, and a complete date without a time has time 00:00:00. ASTDTM has no value when AESTDTC lacks a complete calendar date.

ASTDT is the calendar date of ASTDTM and ASTTM is its time of day as whole seconds since midnight; both have no value when ASTDTM has no value.

ASTTMF is "H" for a start collected as a complete date without a time, "M" for a start collected to the hour, and "S" for a start collected to the minute. ASTTMF has no value when the start was collected to the second or ASTDTM has no value. An ASTTM of 0 with ASTTMF "H" is imputed midnight.

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

prompts/adam-adae-adamig11/conventions.md

Edit10 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.

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

prompts/adam-adae-adamig11/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-adamig11/result.R

Edit38 lines

1# Derive ADaM adverse-event start date/time and time-imputation flags.2ae <- read.csv("/app/input/ae.csv", stringsAsFactors = FALSE, check.names = FALSE,3               na.strings = c("", "NA"))4required <- c("STUDYID", "USUBJID", "AESEQ", "AETERM", "AESTDTC")5stopifnot(all(required %in% names(ae)))67n <- nrow(ae)8adae <- ae[c("STUDYID", "USUBJID", "AESEQ", "AETERM")]9adae$ASTDTM <- rep(NA_character_, n)10adae$ASTDT <- rep(NA_character_, n)11adae$ASTTM <- rep(NA_integer_, n)12adae$ASTTMF <- rep(NA_character_, n)1314for (i in seq_len(n)) {15  dtc <- ae$AESTDTC[i]16  if (is.na(dtc)) next17  # Each accepted form must contain a complete calendar date.18  if (!grepl("^[0-9]{4}-[0-9]{2}-[0-9]{2}(T[0-9]{2}(:[0-9]{2}(:[0-9]{2})?)?)?$", dtc)) next19  date_text <- substr(dtc, 1L, 10L)20  parsed_date <- as.Date(date_text, format = "%Y-%m-%d")21  if (is.na(parsed_date) || format(parsed_date, "%Y-%m-%d") != date_text) next22  precision <- nchar(dtc)23  hour <- if (precision >= 13L) as.integer(substr(dtc, 12L, 13L)) else 0L24  minute <- if (precision >= 16L) as.integer(substr(dtc, 15L, 16L)) else 0L25  second <- if (precision >= 19L) as.integer(substr(dtc, 18L, 19L)) else 0L26  if (hour > 23L || minute > 59L || second > 59L) next27  adae$ASTDTM[i] <- sprintf("%sT%02d:%02d:%02d", date_text, hour, minute, second)28  adae$ASTDT[i] <- date_text29  adae$ASTTM[i] <- hour * 3600L + minute * 60L + second30  adae$ASTTMF[i] <- switch(as.character(precision), `10` = "H", `13` = "M",31                         `16` = "S", NA_character_)32}3334stopifnot(nrow(adae) == nrow(ae),35          identical(names(adae), c("STUDYID", "USUBJID", "AESEQ", "AETERM",36                                   "ASTDTM", "ASTDT", "ASTTM", "ASTTMF")))37dir.create("/app/output", showWarnings = FALSE)38write.csv(adae, "/app/output/adae.csv", row.names = FALSE, na = "")

solutions/adam-adae-adamig11/result.py

Edit74 lines

1"""Create the event-level ADAE start datetime analysis variables."""23import csv4import re5from datetime import datetime6from pathlib import Path789COLUMNS = [10    "STUDYID",11    "USUBJID",12    "AESEQ",13    "AETERM",14    "ASTDTM",15    "ASTDT",16    "ASTTM",17    "ASTTMF",18]19START_PATTERN = re.compile(20    r"(\d{4})-(\d{2})-(\d{2})(?:T(\d{2})(?::(\d{2})(?::(\d{2}))?)?)?"21)222324def derive_start(value):25    """Impute only uncollected time components of a complete calendar date."""26    match = START_PATTERN.fullmatch((value or "").strip())27    if match is None:28        return {column: "" for column in COLUMNS[4:]}2930    year, month, day, hour, minute, second = match.groups()31    try:32        start = datetime(33            int(year),34            int(month),35            int(day),36            int(hour or 0),37            int(minute or 0),38            int(second or 0),39        )40    except ValueError:41        return {column: "" for column in COLUMNS[4:]}4243    flag = (44        "H"45        if hour is None46        else "M"47        if minute is None48        else "S"49        if second is None50        else ""51    )52    return {53        "ASTDTM": start.isoformat(timespec="seconds"),54        "ASTDT": start.date().isoformat(),55        "ASTTM": start.hour * 3600 + start.minute * 60 + start.second,56        "ASTTMF": flag,57    }585960def main():61    output_path = Path("/app/output/adae.csv")62    output_path.parent.mkdir(parents=True, exist_ok=True)63    with Path("/app/input/ae.csv").open(newline="", encoding="utf-8-sig") as source:64        with output_path.open("w", newline="", encoding="utf-8") as target:65            writer = csv.DictWriter(target, fieldnames=COLUMNS)66            writer.writeheader()67            for event in csv.DictReader(source):68                row = {column: event.get(column, "") for column in COLUMNS[:4]}69                row.update(derive_start(event.get("AESTDTC")))70                writer.writerow(row)717273if __name__ == "__main__":74    main()

solutions/adam-adae-adamig11/result.sas

Edit40 lines

1proc import datafile="/app/input/ae.csv" out=ae dbms=csv replace;2  guessingrows=max;3run;45data adae;6  length STUDYID $40 USUBJID $80 AESEQ 8 AETERM $200 ASTDTM $19 ASTDT $10 ASTTM 8 ASTTMF $1;7  set ae;8  ASTDTM = '';9  ASTDT = '';10  ASTTM = .;11  ASTTMF = '';12  _length = length(strip(AESTDTC));13  if _length >= 10 then do;14    _date = input(substr(AESTDTC,1,10),yymmdd10.);15    if not missing(_date) then do;16      _hour = 0;17      _minute = 0;18      _second = 0;19      if _length = 10 then ASTTMF = 'H';20      else if _length >= 13 then do;21        _hour = input(substr(AESTDTC,12,2),2.);22        if _length = 13 then ASTTMF = 'M';23        else if _length >= 16 then do;24          _minute = input(substr(AESTDTC,15,2),2.);25          if _length = 16 then ASTTMF = 'S';26          else if _length >= 19 then27            _second = input(substr(AESTDTC,18,2),2.);28        end;29      end;30      _datetime = dhms(_date,_hour,_minute,_second);31      ASTDTM = put(_datetime,e8601dt19.);32      ASTDT = put(datepart(_datetime),yymmdd10.);33      ASTTM = timepart(_datetime);34    end;35  end;36  keep STUDYID USUBJID AESEQ AETERM ASTDTM ASTDT ASTTM ASTTMF;37run;3839proc export data=adae outfile="/app/output/adae.csv" dbms=csv replace;40run;

input/ae.csv

expected/adae.csv

expected/define.xml

Define-XML 2.1.11: CATH

ADAE

Your review

Mapping spec

Agent prompt

prompts/adam-adae-adamig11/full.md

prompts/adam-adae-adamig11/conventions.md

prompts/adam-adae-adamig11/brief.md

yamaa code

R

Python

Solution without yamaa

solutions/adam-adae-adamig11/result.R

solutions/adam-adae-adamig11/result.py

solutions/adam-adae-adamig11/result.sas