|Project Title||Routine Querying System|
Wednesday, July 19, 2017
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 various 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 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 Query Request Form is an Excel spreadsheet. If you do not have Excel, click here to obtain a free version of Microsoft’s Excel Viewer.
The SAS® code for this tool 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.
any medical product defined using SCDM variables
Any health outcome defined using SCDM variables
Any available in SDD
Sentinel Distributed Database