Comparing VISIT and VISITNUM Values Across SDTM Datasets and the TV Domain
Comparing VISIT and VISITNUM Values Across SDTM Datasets and the TV Domain Extracting and Comparing Unique VISIT and VISITNUM Values from SDTM Datasets Author: [Your Name] Date: [Creation Date] In clinical trials, the VISIT and VISITNUM variables are key identifiers for subject visits. Ensuring that all datasets have consistent visit data and that it aligns with the planned visits recorded in the TV (Trial Visits) domain is crucial for accurate data analysis. This post presents a SAS macro that automates the extraction of unique VISIT and VISITNUM values across all SDTM datasets in a library and compares them to those found in the TV domain. Program Overview The SAS macro program: Extracts unique VISIT and VISITNUM values from all SDTM datasets in the specified library. Compares these values against those recorded in the TV domain. Highlights any discrepancies between the SD...