Topic: SQL for Predictive Models
Learning Module Objectives:
After completing the activities in this section, you should be able to:
Teach One Assignment
If you are supposed to teach about this section of the course, select one of the assignments, do the assignment and show it to the instructor to make sure you have done it correctly. Prepare your slides, narrate your slides, remove excess words from narrated slides, convert narrated slides to a file format that can be uploaded, upload your file, email everyone in the class the URL of your file. Make sure that all these tasks are done ahead of scheduled class session. Your peers will appreciate receiving your advice on how to solve a class assignment as soon as possible and well before last day prior to class session. More
No individual assignment should be completed in teams. Submit your work in Blackboard. Do not discuss the work with other students.
Question 1: Calculate the likelihood ratio associated with repeated (first, second, third, fourth, and fifth) Infection of unspecified site and diabetes. Calculate the likelihood ratio as:
Take your definition for unspecified bacterial infection and diabetes from Agency for Health Care Quality and Research's Clinical Classification Software (CCS codes). Since codes have removed some elements of the diagnosis code, add an "I" prior to the diagnosis code and a period prior to the last 2 digits. The CCS diagnosis code should correspond to the format of ICD9 codes in the data. Rank order the repeated bacterial diagnoses of each person and calculate a separate likelihood ratio for each occasions of repetition of the unspecified bacterial diagnosis. Make sure that you count distinct individuals in calculation of the likelihood ratios. Plot the relationship between likelihood ratio for diabetes and the number of bacterial infections. CCS Codes► Data►
Question 2: Redo question 1 but this time exclude patients who died within 6 months of the nth unspecified bacterial infection. Data►
To complete this team assignment, upload your SQL code, the first 4 diagnoses with the largest likelihood ratios (report the names and the likelihood ratios), and the total number of unique diagnoses into a word document. Then, upload the document into Blackboard. Each student will upload their document by Sunday, 11:55 PM, EST.
Copyright © Farrokh Alemi, Ph.D. First created on January 9th 2005. Most recent revision 07/20/2018. This page is part of the course on Healthcare Databases.