What is your proficiency level with statistics packages such as SAS, SPSS or SQL? Other packages or programming languages? Please elaborate.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

PART 2. INTERVIEW TASK

 

1. What is your proficiency level with statistics packages such as SAS, SPSS or SQL? Other packages or programming languages? Please elaborate.

 

 

2. You are provided with data as shown in the table below. Provide the SAS code for each section. (It is not necessary to provide the actual output/results.) 

 

A. Write a program in SAS to calculate the following: 

i) for each gender, frequency of occupant type 

ii) number of drivers with blood alcohol content > 0.08 by county 

iii) number of drivers with blood alcohol content > 0.08 for Wayne County (County=82) 

  

B. Write a program to summarize the distribution of blood alcohol content by age groups 16-24, and 25 and older.  

 

Person # Age (yrs) Gender Occupant Type Blood Alcohol Content County

1 17 M D 0.06 25

2 65 M D 0.00 33

3 2 F P NA 82

4 35 M D 0.10 55

5 17 F D 0.12 82

6 1 M P NA 11

7 22 M D 0.15 82

8 46 M P NA 41

9 23 F P NA 50

10 24 F D 0.11 72

D=driver; P=passenger 

NA: not applicable – BAC test not performed 

 

 

3. Your supervisor has asked you to develop a report in which you will analyze data on work-related amputations for 2017. You have been provided with the following two datasets that will need to be linked in order to perform your analysis: emergency department visits and workers’ compensation claims. The variables within each dataset are listed below. Please describe all the steps you would take prior to performing data linkage. 

Emergency department visit data Workers’ compensation claims data

Date of birth Date of birth 

Date of injury Date of injury 

Age (at ED visit) Sex 

Gender Race

Race Last name 

Ethnicity Zip code of residence 

Last name Employer name 

Social security number Social security number 

Address Part of body injured 

City of residence Type of injury (e.g., burn, laceration, amputation) 

County of residence Outcome of claim (e.g., paid, not paid, still in process) 

State of residence

ICD10CM code

Cause of injury 

Payment source

 

4. You are asked to characterize suicide/suicide attempt data for Michigan for a given year. You generate tables that illustrate the numbers and rates of suicide deaths and suicide attempt hospitalizations. 

  The two tables with the results are below. Prepare a short narrative given these results. Assume you are writing this for the results section of a paper you are preparing for publication.   

 

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