• Analytics use case(s): Characterization
• Study type: Clinical Application
• Tags: TreatmentPatterns
• Study lead: Anna Ostropolets
• Study lead forums tag: [aostropolets]
• Study start date: 01/01/2025
• Study end date: -
• Protocol: docs/GDE2025 CAP Treatment Pathways Protocol.docx
• Publications: -
• Results explorer: -

This study focuses on exploring the patterns of antibiotics therapy in patients with community-acquired pneumonia across the network. We will explore sequences of drugs prescribed to such patients as well in a subgroup of hospitalized patients.

• A database in Common Data Model version 5 in one of these platforms: SQL Server, Oracle, PostgreSQL, IBM Netezza, Apache Impala, Amazon RedShift, Google BigQuery, or Microsoft APS.
• R version 4.0.5
• On Windows: RTools
• Java
• 100 GB of free disk space

1. Follow these instructions for setting up your R environment, including RTools and Java.

2. Open your study package in RStudio. Use the following code to install all the dependencies:

   install.packages("renv")
   renv::activate()
   renv::restore()

3. Open StrategusCodeToRun.R, change database connection parameters to your database connection (Lines starting with START OF INPUTS and endind with END OF INPUTS) abnd execute the file.

4. Share outputs located in results folder with the study lead