bcarnagie/icope_survey_code_sample

SAS analysis scripts for the I-COPE Study, examining COVID-19's impact among PLHIV in Kenya # I-COPE Study: SARS-CoV-2 Seroprevalence and Impact of COVID-19 among People Living with HIV in Kenya This repository contains SAS code used to generate descriptive statistics and visualizations for Table 1 and Table 2 of the I-COPE Study, which explores the seroprevalence of SARS-CoV-2 and the impact of COVID-19 among people living with HIV in Kenya. This was a project that I worked on during my time at ICAP at Columbia University, where I was employed as a Data Assistant. ## 📌 Objective To generate baseline characteristics (Table 1), COVID-19 vaccination uptake patterns (Table 2), and stratified statistics by healthcare facility for individuals enrolled in the I-COPE study using survey and clinical data. ## 📂 File Summary - `icope_table1_analysis.sas`: SAS script for data import, cleaning, derivation of key variables, descriptive statistics, visualizations, and time-based calculations (Table 1). - `icope_table2_vaccine_analysis.sas`: SAS script focused on COVID-19 vaccination data, including series completion, booster uptake, timing between doses, and adoption phase categorization (Table 2). ## 🧰 Tools Used - **SAS 9.4** - Procedures used: `PROC IMPORT`, `PROC FREQ`, `PROC MEANS`, `PROC FORMAT`, `PROC UNIVARIATE`, `PROC SGPLOT`, `PROC CONTENTS` - Date manipulation using `MDY`, `INTCK`, `PUT`, and conditional logic ## 📊 Key Features ### Table 1 - Derived variables for age group, gender, marital status, education, employment, vaccination status, and viral load category - Stratified frequency tables and chi-square tests by facility (`es_hf`) - Travel time normalization and household size categorization - Calculation of time since HIV diagnosis and recent viral load - Histograms and bar plots ### Table 2 - Vaccine series and booster completion status based on dose and type - Substitution of missing baseline values with medical record data - Month/year extraction from vaccination dates and categorization into adopter phases - Derivation of time intervals betwee …