Word document with your SAS code used to perform data cleaning and analysis

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

To complete the goals for this exercise, follow the analysis plan below.  We would like for you to save the following items for this exercise in the Dropbox folder:

1. Word document with your SAS code used to perform data cleaning and analysis

2. Brief report with methods and results

 

Goals:  

• Combine claims data with enrollment and area-level data to create an analytic dataset.  

• Examine demographics and unadjusted costs

• Run a linear regression.

 

Analysis Plan:  

• Cohort Definition: Include all members where:

o Member included in 2012 enrollment file 

o Had >= 1 month of enrollment in the diabetes program in 2012

 

• Outcome:  Annual total cost of office visits with any diabetes diagnosis that occurred while enrolled in the diabetes management program

o Claims included must meet the following criteria:

 Office visits  

 >=1 line with an ICD9 diabetes diagnosis (250.x) 

 Claim date of service during enrollment in the diabetes program

o Calculate the individual total annual cost of claims meeting above criteria (include all claim lines within claim, not just the line with the diabetes diagnosis) 

o Calculate the annual costs of included claims

 

• Predictor:  Area level indicator of lower SES

o Zip code file includes median income for each zip code

o Create indicator of lower SES

 Definition of Lower SES:  zip code median income < median income across zip codes

 Indicator = 0 if not lower SES, =1 if lower SES

• Covariates:

o Age (treat as a continuous variable)

o Indicator for gender (make the reference group = male)

o Months of enrollment in the diabetes management program in 2012 (treat as a continuous variable)

o Indicators for race (make the reference group = white)

 

• Examine summary statistics for all variables (mean, SD, median, min, max)

o Outcome

o Predictor

o Covariates

 

• Model:

o Linear regression

 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme