Posts

Showing posts with the label Finding Unique EPOCH values from SDTM datasets in entire library.

Finding EPOCH Values in SDTM Datasets using a SAS Macro

Finding EPOCH Values in SDTM Datasets using a SAS Macro Finding EPOCH Values in SDTM Datasets using a SAS Macro Author: [Sarath] Date: [05SEP2024] The EPOCH variable is essential in many SDTM datasets as it helps describe the period during which an event, observation, or assessment occurs. In clinical trials, correctly capturing and analyzing the EPOCH variable across datasets is crucial. This post walks through a SAS macro program that automates the process of finding all EPOCH values from any dataset within an entire library of SDTM datasets. Program Overview This macro program loops through all the datasets in a specified library, checks for the presence of the EPOCH variable, and extracts the unique values of EPOCH from each dataset. It then consolidates the results and displays them for review. Key Features: Automatically identifies SDTM datasets containing the EPOCH variable. ...