sdtm-programming

Implement SDTM transformations in Python, SAS, and R with validations.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/siddharthchauhan/ETL --skill sdtm-programming
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sdtm-programming
Source: https://github.com/siddharthchauhan/ETL/tree/main/sdtm_pipeline/deepagents/skills/sdtm-programming
Command: npx skills add https://github.com/siddharthchauhan/ETL --skill sdtm-programming

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SDTM programming workflow is complex and error-prone. This Skill provides structured guidance for implementing SDTM data transformations using Python, SAS, and R, including mapping, validation, and metadata generation.

Core Features & Use Cases

  • Multi-language SDTM transformation: Implement domain-level transformations using Python (Pandas/Polars), SAS, and R with reusable patterns.
  • Controlled terminology handling: Apply CDISC terminology mappings and data quality checks within ETL pipelines.
  • End-to-end SDTM pipelines: Cover from data ingestion to target dataset generation, including EPOCH/BLFL derivations and study-day calculations.
  • Use Case: Build a transformation for DM to SDTM-DM with proper date handling and domain relationships in a clinical trial dataset.

Quick Start

Use this skill to scaffold a basic SDTM transformation for the DM domain using sample source data; adapt mapping_spec and reference_data to your dataset.

Frequently Asked Questions about sdtm-programming

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I implement SDTM data transformations across Python, SAS, and R?

SDTM data transformations across Python, SAS, and R are implemented using reusable ETL patterns for domain-level mappings, controlled terminology validation, and study-day calculations. This approach provides structured guidance for reproducible clinical trial dataset processing.

What is the best way to handle CDISC controlled terminology in SDTM ETL pipelines?

Handling CDISC controlled terminology in SDTM ETL pipelines involves applying terminology mappings and data quality checks directly within the transformation workflow. This enforces standard validation rules across target domains during data ingestion.

How do I derive EPOCH and study-day calculations for SDTM domains like DM and AE?

Deriving EPOCH and study-day calculations for SDTM domains requires applying standard date handling and epoch derivation logic within the transformation pipeline. This ensures correct temporal relationships across DM and AE clinical trial datasets.

Can I use Pandas and Polars for end-to-end SDTM domain mapping specifications?

Pandas and Polars can be used for end-to-end SDTM domain mapping specifications by adapting mapping_spec and reference_data to your source dataset. This allows you to scaffold transformations for target domains like DM, AE, and VS.

Does this SDTM programming approach support BLFL derivations and metadata generation?

This SDTM programming approach supports BLFL derivations and metadata generation as part of end-to-end pipelines. It covers the full workflow from raw clinical data ingestion to target dataset generation with proper domain relationships.