|Project Title||Routine Querying System|
Wednesday, June 24, 2020
Sentinel routine querying tools are SAS programs designed to run against the Sentinel Common Data Model (SCDM). They allow rapid implementation of standard queries across the Sentinel Distributed Database (SDD). The programs can be customized using input parameters that define medical product exposures, outcomes, covariates, diagnoses, date ranges, age ranges, and other implementation details. Tools can perform simple cohort characterization and descriptive analyses, but may also be used to perform more complex adjustment for confounding and to support prospective surveillance activities.
The Cohort Identification and Descriptive Analysis (CIDA) program is the foundation of the routine querying system. CIDA is responsible for identifying, extracting, and characterizing cohorts of interest from the SDD based on the specification of a number of requester-defined options (e.g., continuous enrollment requirements, incidence criteria, inclusion/exclusion criteria). CIDA may be used to calculate simple background rates of health outcomes of interest (HOIs) (e.g., prevalence of acute myocardial infarction), or rates of medical product use (e.g., new warfarin use), or it may be used for more complex queries that identify the occurrence of HOIs during exposure to a medical product of interest (e.g., number of incident diagnoses of rhabdomyolysis during new treatment with a statin).
The CIDA program, by default, will output summary-level counts (e.g., number of new users, number of HOIs) stratified by various parameters (e.g., age group, sex, year, year-month). CIDA will also output metrics on eligible members and eligible member days associated with each result stratum, allowing for the calculation of proportions and rates, and an attrition table, to determine the number of eligible members removed from consideration after application of various cohort selection criteria.
The CIDA program is integrated with additional, optional modules that perform more complex analyses and confounder adjustment:
The functionality and modules used for a particular routine query request is dependent on the question of interest and required output.
The SAS® code for the Macro Toolkit is provided in a zipped file. By unzipping the file and changing the extensions for each of the subprograms from “.sas” to “.txt”, the code will become readable for individuals who do not have the SAS software.
The Sentinel Routine Querying System Documenation is located externally on Sentinel's Git Repository. The Git Repository serves as Sentinel's version control tracking system for analytic packages and technical documentation. A history of modications for the Sentinel Routine Querying System is located here.
Sentinel Distributed Database (SDD)