Observational Source Characteristics Analysis Report (OSCAR)

In order to interpret the results of any analysis on a data source, the characteristics of the data source be clearly understood. The Observational Source Characteristics Analysis Report (OSCAR) provides a systematic approach for summarizing all observational healthcare data within the OMOP common data model. The procedure creates structured output of descriptive statistics for all relevant tables within the model to facilitate rapid summary and interpretation of the potential merits of a particular data source for addressing active surveillance needs.

A prerequisite for OSCAR is that the program must be applied to a data source that conforms to the OMOP common data model, including all necessary tables and fields, and SAS 9.1 has to be available. OSCAR creates a summary result dataset in a structured format. This dataset contains descriptive statistics for all the various data elements with the common data model, but do not contain any person-level data.

Observational Source Characteristics Analysis Report (OSCAR) and Source Code:
If you have implemented CDM v4.0, use OSCAR for CDM v4.0 otherwise, use OSCAR for CDM v2.0.

OSCAR code and specifications for CDM v4.0
OSCAR Code and Specifications for CDM v4.0

OSCAR code and specifications for CDM v2.0
For SAS Datasets

For Oracle Datasets (The code still requires SAS to run but assumes that data are stored in Oracle and not in SAS datasets)

OSCAR has many uses, including:

  • Providing a summarization of available data from a given source
  • Providing context for interpreting and analyzing findings of drug safety studies
  • Facilitating comparisons between data sources
  • Enabling comparison of overall database to specific subpopulations of interest
  • Supporting validation of transformation from raw data to OMOP common data model
  • The diagram shows how OSCAR fits into the workflow for validating the transformation from raw data sources to the OMOP common data model.

    OSCAR Workflow