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
README.mdGoal: derive AVISIT (sentence case) and AVISIT_TITLE (title
case) from the collected visit name, replacing a hand-written
visit-label mapping.
Input: lab records carrying VISIT (the collected visit name, e.g.
WEEK 8), copied to the output unchanged.
Variables:
AVISITisVISITin sentence case: the first character becomes uppercase and every later letter lowercase, soEND OF TREATMENTgivesEnd of treatment.AVISIT_TITLEisVISITin title case: each unbroken run of letters starts uppercase and continues lowercase, and any other character, such as a space or hyphen, ends a word:END OF TREATMENTgivesEnd Of TreatmentandFOLLOW-UPgivesFollow-Up.
Note: only the plain English letters A to Z change case; every
other character is unchanged. The two forms agree whenever the visit
name holds one run of letters (WEEK 8 gives Week 8 both ways).
Rows are ordered by the collected visit name, then by subject.
Inputs
Under review1 source fileinput/lb.csv
Edit5 rows| STUDYID | USUBJID | VISIT |
|---|---|---|
| YAMAA-01 | WEEK 2 | |
| YAMAA-01 | WEEK 8 | |
| YAMAA-01 | SCREENING | |
| YAMAA-01 | END OF TREATMENT | |
| YAMAA-01 | FOLLOW-UP |
Expected output
Under review5 expected rowsexpected/adlb.csv
Edit5 rows| STUDYID | USUBJID | VISIT | AVISIT | AVISIT_TITLE |
|---|---|---|---|---|
| YAMAA-01 | END OF TREATMENT | End of treatment | End Of Treatment | |
| YAMAA-01 | FOLLOW-UP | Follow-up | Follow-Up | |
| YAMAA-01 | SCREENING | Screening | Screening | |
| YAMAA-01 | WEEK 2 | Week 2 | Week 2 | |
| YAMAA-01 | WEEK 8 | Week 8 | Week 8 |
Comments and assessment materials
| Dataset Name | Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Computational Method | Origin |
|---|---|---|---|---|---|---|---|
| ADLB | STUDYID | Study Identifier | character | Copy value from LB.STUDYID. | Predecessor | ||
| ADLB | USUBJID | Unique Subject Identifier | character | Copy value from LB.USUBJID. | Predecessor | ||
| ADLB | VISIT | Visit Name | character | Copy value from LB.VISIT. | Predecessor | ||
| ADLB | AVISIT | Analysis Visit | character | Convert LB.VISIT to sentence case. | Derived | ||
| ADLB | AVISIT_TITLE | Analysis Visit Title Case | character | Convert LB.VISIT to title case. | Derived |
| Version | Date | Author | Description | Reviewer | Sign-off |
|---|---|---|---|---|---|
| 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 |
yamaa
Comments
Signed in with GitHub; saved in repository Discussions