ONLY USE SAS STUDIO ON DEMAND!!! 1. Download the file ‘AHCA_INP_SAMP_1 to your OnDemand data library. a. Import the file into SAS b. Create a new data file for only those records w
Week 6 Homework and data dictionary:
Download the file ‘AHCA_INP_SAMP_1 to your OnDemand data library.
Import the file into SAS
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’.