1. Download the file ‘AHCA_INP_SAMP_1 from the Week 6 folder in Canvas to your OnDemand data library. a. Import the file into SAS b. Create a new data file for only those records wh

Week 6 Homework and data dictionary:

Download the file ‘AHCA_INP_SAMP_1 to your OnDemand data library.
1. Import the file into SAS
2. Create a new data file for only those records where the principal diagnosis code is ‘41000’ to ‘41499’ and keeping the following variables: sex ethnicity race age payer prindiag othdiag1-othdiag30- prinproc othproc1-othproc30.

2. Using the if-then-else statements create a zero-one dummy variable (0= did not get it and 1 for got it) for cardiac catheterization where the code for cardiac catheterization (CATH) is ‘3720’ to ‘3723’ for the first 11procedures (prinproc and othproc1 othproc10.)

3. Create a zero-one raceeth variable for Non-Hispanic White (0), Non-Hispanic Black (1), and Hispanic (2).

4. Write formats for CATH and RACEETH.

5. Produce a formatted table comparing receipt of cardiac catheterization for the three race/ethnicity groups. Ask for a ChiSq statistic

6. Write a short explanation of the table.

7. Redo number 2 using an array. How many people got the cardiac catheterization?

FOR EACH OF THE STEPS PLEASE COPY AND PASTE THE SAS CODE AND THE LOG INTO A WORD DOCUMENT

Patient Sex

sex

An alpha character code identifying the gender of the patient at admission. A required entry.

M – Male

F – Female

U – Unknown

Patient Ethnicity

ethnicity

The patient’s ethnicity background shall be reported as one choice from the following list

of alternatives. A required entry.

E1 – Hispanic or Latino. A person of Mexican, Puerto Rican, Cuban, Central or South

American or other Spanish culture or origin, regardless of race.

E2 – Non-Hispanic or Latino. A person not of any Spanish culture or origin.

E7 – Unknown

Patient Race

race

A single digit code identifying the patient’s racial background. A required entry.

1 – American Indian or Alaska Native

2 – Asian

3 – Black or African American

4 – Native Hawaiian or Other Pacific Islander

5 – White

6 – Other

7 – Unknown

Prindiag code for Ischemic Heart Disease 41000 to 41499

Prinproc code for percutaneous transluminal angioplasty (PTCA) is ‘3601’, ‘3602’ and ‘3605’

Prinproc code for cardiac bypass graph (CABG) is ‘3610’ to ‘3620’.