You are provided with data as shown in the table below. Provide the SAS code for each section.

1. 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

Answer rating: 100% (QA)

1 a data fishconsumption input Gender Age Species Frequency datalines M 4... View the full answer