Numeric Functions

Review ask

As a clinical trial statistician or programmer, challenge anything in this benchmark: describe a problem in Comments, or propose a fix with the Edit button on any source file.

Task: Would a real study need this derivation, specified this way? Does it follow CDISC ADaM: variable names, controlled terms, record structure? Flag any rule that is ambiguous or that a sponsor would handle differently.
Inputs: Do they look like data collected in a real trial, and do they include the situations you would expect to meet in one?
Expected output: Would independent QC programming reproduce every value from these inputs and rules?

The other tabs beside Comments are background for assessment, not under review.

Summary

EditUnder reviewWhat this benchmark means

README.md

Goal: apply CEIL, FLOOR, TRUNC, EXP, MOD, GREATEST, LEAST, and COALESCE to carried values.

Input: subject-level records carrying AVAL as a decimal number and BVAL and CVAL as whole numbers, each copied to the output unchanged (a blank stays blank).

Variables:

CEILVAL holds the smallest whole number at or above AVAL; blank when AVAL is blank.
FLOORVAL holds the largest whole number at or below AVAL; blank when AVAL is blank.
TRUNCVAL holds AVAL with its fraction cut away toward zero, so a negative value with a fraction moves up, not down; blank when AVAL is blank.
EXPVAL holds the constant e raised to AVAL; blank when AVAL is blank.
MODVAL holds the remainder of BVAL divided by three, with the sign of BVAL; blank when BVAL is blank.
GREATESTVAL holds the largest among BVAL, CVAL, and zero, skipping blanks; the zero means it is never blank.
LEASTVAL holds the smallest among BVAL, CVAL, and zero, skipping blanks; the zero means it is never blank.
COALESCEVAL holds CVAL when present and otherwise BVAL; blank when both are blank.

Note: a blank input gives a blank result, except that the largest-or-smallest choice skips blanks and the first-present choice moves to the next value.

YAML specification

1 spec file

spec.yaml

Edit103 lines

1schema_version: "1.0"2domain: ADSL3keys: [STUDYID, USUBJID]4input:5  SOURCE: input/adsl.csv67output:8  path: adsl.csv9  columns: [STUDYID, USUBJID, AVAL, BVAL, CVAL, CEILVAL, FLOORVAL,10    TRUNCVAL, EXPVAL, MODVAL, GREATESTVAL, LEASTVAL, COALESCEVAL]1112columns:13  - name: STUDYID14    type: str15    label: Study Identifier16    derivation: SOURCE.STUDYID1718  - name: USUBJID19    type: str20    label: Unique Subject Identifier21    derivation: SOURCE.USUBJID2223  - name: AVAL24    type: float25    label: Analysis Value26    derivation: SOURCE.AVAL2728  - name: BVAL29    type: int30    label: Secondary Analysis Value31    derivation: SOURCE.BVAL3233  - name: CVAL34    type: int35    label: Tertiary Analysis Value36    derivation: SOURCE.CVAL3738  - name: CEILVAL39    type: int40    label: Ceiling of Analysis Value41    derivation:42      compute:43        expr: "CEIL(AVAL)"4445  - name: FLOORVAL46    type: int47    label: Floor of Analysis Value48    derivation:49      compute:50        expr: "FLOOR(AVAL)"5152  # Toward zero: -2.7 gives -2, where FLOOR gives -3.53  - name: TRUNCVAL54    type: int55    label: Truncation of Analysis Value56    derivation:57      compute:58        expr: "TRUNC(AVAL)"5960  - name: EXPVAL61    type: float62    label: Exponential of Analysis Value63    derivation:64      compute:65        expr: "EXP(AVAL)"6667  # The remainder takes the sign of BVAL, so -7 gives -1 rather than 2.68  - name: MODVAL69    type: int70    label: Remainder of Secondary Value Divided by Three71    derivation:72      compute:73        expr: "MOD(BVAL, 3)"7475  # GREATEST and LEAST skip missing arguments, so with the literal 0 among76  # them neither result is ever missing.77  - name: GREATESTVAL78    type: int79    label: Largest of Secondary, Tertiary, and Zero80    derivation:81      compute:82        expr: "GREATEST(BVAL, CVAL, 0)"8384  - name: LEASTVAL85    type: int86    label: Smallest of Secondary, Tertiary, and Zero87    derivation:88      compute:89        expr: "LEAST(BVAL, CVAL, 0)"9091  - name: COALESCEVAL92    type: int93    label: First Present Value Among Tertiary and Secondary94    derivation:95      compute:96        expr: "COALESCE(CVAL, BVAL)"9798verifications:99  - unique:100      columns: [STUDYID, USUBJID]101  - row_count:102      min: 5103      max: 5

Inputs

Under review1 source file

input/adsl.csv

Edit5 rows

input/adsl.csv
STUDYID	AVAL	BVAL	CVAL
CATH	2.3	7	5
CATH	-2.7	-7	—
CATH	2.0	10	3
CATH	—	5	8
CATH	0.5	—	—

Expected output

Under review5 expected rows

expected/adsl.csv

Edit5 rows

expected/adsl.csv
STUDYID	AVAL	BVAL	CVAL	CEILVAL	FLOORVAL	TRUNCVAL	EXPVAL	MODVAL	GREATESTVAL	LEASTVAL	COALESCEVAL
CATH	2.3	7	5	3	2	2	9.974182454814718	1	7	0	5
CATH	-2.7	-7	—	-2	-3	-2	0.06720551273974976	-1	0	-7	-7
CATH	2	10	3	2	2	2	7.38905609893065	1	10	0	3
CATH	—	5	8	—	—	—	—	2	8	0	8
CATH	0.5	—	—	1	0	0	1.6487212707001282	—	0	0	—

Shaded columns are derived— = missing value

Comments and assessment materials

Dataset Name	Variable Name	Variable Label	Type	Computational Method	Origin
ADSL	STUDYID	Study Identifier	character	Copy value from SOURCE.STUDYID.	Predecessor
ADSL	USUBJID	Unique Subject Identifier	character	Copy value from SOURCE.USUBJID.	Predecessor
ADSL	AVAL	Analysis Value	numeric	Copy value from SOURCE.AVAL.	Predecessor
ADSL	BVAL	Secondary Analysis Value	numeric	Copy value from SOURCE.BVAL.	Predecessor
ADSL	CVAL	Tertiary Analysis Value	numeric	Copy value from SOURCE.CVAL.	Predecessor
ADSL	CEILVAL	Ceiling of Analysis Value	numeric	Compute CEIL(AVAL).	Derived
ADSL	FLOORVAL	Floor of Analysis Value	numeric	Compute FLOOR(AVAL).	Derived
ADSL	TRUNCVAL	Truncation of Analysis Value	numeric	Compute TRUNC(AVAL).	Derived
ADSL	EXPVAL	Exponential of Analysis Value	numeric	Compute EXP(AVAL).	Derived
ADSL	MODVAL	Remainder of Secondary Value Divided by Three	numeric	Compute MOD(BVAL, 3).	Derived
ADSL	GREATESTVAL	Largest of Secondary, Tertiary, and Zero	numeric	Compute GREATEST(BVAL, CVAL, 0).	Derived
ADSL	LEASTVAL	Smallest of Secondary, Tertiary, and Zero	numeric	Compute LEAST(BVAL, CVAL, 0).	Derived
ADSL	COALESCEVAL	First Present Value Among Tertiary and Secondary	numeric	Compute COALESCE(CVAL, BVAL).	Derived

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

run.R

Edit4 lines

1library(yamaa)23adsl <- yamaa_domain("spec.yaml")$output4adsl

run.py

Edit4 lines

1import yamaa23adsl = yamaa.yamaa_domain("spec.yaml").output4adsl

input/adsl.csv

expected/adsl.csv

Comments

Mapping spec

yamaa code

run.R

run.py