CMENRTPT vs CMENRF in SDTM Understanding CMENRTPT vs CMENRF in SDTM By Sarath Introduction When working with the Concomitant Medication (CM) domain in SDTM, it's crucial to understand how timing variables like CMENRTPT (End Relative to Reference Time Point) and CMENRF (End Relative to Reference Period) differ and when to use each. What is CMENRTPT? CMENRTPT indicates the relationship between the end of the medication and a specific time point , such as the start of treatment or a significant event (e.g., surgery). Controlled Terminology: BEFORE, AFTER, ONGOING, CONCURRENT Example: If a medication was stopped before surgery, CMENRTPT = "BEFORE" . What is CMENRF? CMENRF describes whether the medication ended ...

Resolving the SAS EG Transcoding Error Addressing the "Character Data Lost During Transcoding" Issue in SAS EG Author: Sarath Date: November 19, 2024 Introduction While working in SAS Enterprise Guide (SAS EG), you may encounter the error: "Some character data was lost during transcoding in the dataset." This issue typically arises when character data contains unsupported characters or is truncated due to insufficient column lengths. In this blog post, we'll explore the root causes and provide step-by-step solutions. Common Causes Unsupported Characters: The data contains special or non-ASCII characters not representable in the session encoding. Truncation: Character variables are too short to store the full data, leading to loss of information. ...

Advanced SAS Programming Techniques for SDTM Implementation Date: November 3, 2024 In the realm of clinical trials data management, SDTM (Study Data Tabulation Model) implementation requires sophisticated programming techniques to ensure data accuracy and compliance. This article explores advanced SAS programming methods that can streamline SDTM dataset creation and validation. 1. Efficient Variable Derivation Using Hash Objects Hash objects in SAS provide a powerful way to perform quick lookups and merges, especially useful when dealing with large SDTM datasets. data work.ae; if _n_ = 1 then do; declare hash h_dm(dataset: "sdtm.dm"); h_dm.definekey("usubjid"); h_dm.definedata("age", "sex", "race"); h_dm.definedone(); end; set raw.ae; rc = h_dm.find(); /* Continue processing */ run; Pro Tip:  Hash objects remain in memory throughout the DATA step, making them more efficient than tr...