Question
You are provided with data as shown in the table below. Provide the SAS code for each section. Write a program in SAS to calculate
You are provided with data as shown in the table below. Provide the SAS code for each section.
- Write a program in SAS to calculate the following:
i) for each gender, the frequency of fish consumed by species
ii) for the age groups <45 and ≥45, the frequency of fish consumed by species
iii) same as ii but limited to residents of Wayne County (County=82)
B. Write a program to summarize the distribution of blood mercury levels by fish species.
Participant | Age | Gender | Species Consumed | Blood Mercury Level | County |
1 | 42 | 1 | Catfish | 15 | 25 |
2 | 67 | 1 | Perch | 20 | 33 |
3 | 22 | 1 | Catfish | <1* | 82 |
4 | 35 | 2 | Catfish | 20 | 55 |
5 | 19 | 1 | Perch | <1* | 82 |
6 | 88 | 1 | Perch | 1 | 11 |
7 | 55 | 2 | Perch | 3 | 82 |
8 | 25 | 2 | Catfish | 10 | 41 |
9 | 30 | 1 | Catfish | 9 | 50 |
10 | 18 | 1 | Catfish | 5 | 72 |
*1.0 is the laboratory limit of detection for mercury; these values are below the limit of detection
2. You have been asked to create a statistical model describing the relationship between blood mercury levels and the other variables below collected from 20,000 study participants. Describe the steps you would take to perform this task and include the programs you would use.
Variable | Variable type (range or categories) |
Age | continuous (18 – 70 years) |
Race | 3 categories (black, white, other) |
Sex | binary (female, male) |
Residence | 83 categories (county codes) |
Frequency of fish consumption per week | 4 categories (>once/week, once/week or less, did not consume, unknown) |
Blood mercury level | continuous (<1- 25) |
Distance from the pollution source | continuous (0-50 miles) |
3. You are asked to examine hospitalizations for two major types of respiratory disease – Chronic Obstructive Pulmonary Disease (COPD) and Asthma. You generate the following two tables for Michigan resident hospital discharges in 2012. (Rates are per 100,000 Michigan residents). Prepare a short narrative that describes, interprets, and compares the data in the two tables; assume you are writing this for the results section of a paper you are preparing for publication.
Primary Discharge Diagnosis: COPD | |||||||
Age Group | Male | Female | Total | ||||
Number | Rate | Number | Rate | Number | Rate | ||
<20 | 30 | 2.1 | 6 | 0.4 | 36 | 1.3 | |
20-44 | 210 | 12.1 | 24 | 1.4 | 234 | 6.8 | |
45+ | 240 | 13.2 | 30 | 1.4 | 270 | 6.9 | |
Total | 480 | 9.7 | 60 | 1.2 | 540 | 5.4 |
Primary Discharge Diagnosis: Asthma | |||||||
Age Group | Male | Female | Total | ||||
Number | Rate | Number | Rate | Number | Rate | ||
<20 | 10 | 0.7 | 10 | 0.7 | 20 | 0.7 | |
20-44 | 80 | 4.6 | 70 | 4.1 | 150 | 4.4 | |
45+ | 55 | 3.0 | 45 | 2.2 | 100 | 2.6 | |
Total | 145 | 2.9 | 125 | 2.4 | 270 | 2.7 |
Step by Step Solution
3.40 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
1 a data fishconsumption input Gender Age Species Frequency datalines M 4...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started