ACDM 2024

We are pleased to inform you that an abstract has been accepted for ACDM24 in Copenhagen. Read the full abstract here.
Also, we will have a stand at ACDM for the first time. We hope to see you there.

Mapping Engine:

An Approach to Standardising SAS Programming in Clinical Trials


by Kai Wanke (with Bas van Bakel)

One of the difficulties when working with clinical trial data is the variability of source data generated in different trials or by different vendors poses one of the major challenges faced when working with clinical trial data. Often this is the case even when the same EDC system is used throughout.

To ensure interoperability data is expected to be converted into standardised models before it is analysed and submitted to regulatory bodies. This process presents challenges since it can be time-consuming and may introduce a degree of variability, for example between data generated between different study teams.

To address these challenges, we have developed a data conversion framework. This framework is a suite of SAS macros that uses pseudo-code stored in a spreadsheet (called ‘mapping specifications’) to generate SAS programs that perform the conversion of raw data into specific models, such as SDTM or similar data models which may be company-specific. This framework is referred to as Mapping Engine.

As part of its specifications, Mapping Engine consumes metadata to ensure all its created datasets and variables adhere to the specifications of the selected model such as data types, labels, formats, et cetera.

One of the benefits of working with Mapping Engine is that its specifications are organised around individual source datasets and variables rather than complete trials, making it highly transferable and reusable between files, users, and trials. Moreover, this transferability allows the creation of pre-defined libraries of mapping specifications that are tailored around a specific vendor, therapeutic area, or compound, and describe how the data should be processed.

Using SAS code, it is possible to automatically match the raw data against the mapping libraries, automatically generating an initial version of the specifications that can be used to convert the raw data into the desired model. This results in the automated, metadata-driven conversion of clinical trial data for up to 90% of items in case report forms.

Mapping Engine allows to minimise the manual effort needed during data conversion, while at the same time enforcing programmatic standards and reducing variability between different studies.