Turn in one copy for each group. If group members are not present in class they will be required to complete their own lab to receive credit. Please turn in a file with your output and a file containing your SAS code.

## Questions

### 1. Using PROC MEANS (40 points)

- Using a LIBNAME reference, load the housing file.
- Create a new SAS data set that only contains homes in MT, CO, ID, and WY.
- Use
`PROC MEANS`

to summarize the price and square footage of the homes **by state**. Note this will require sorting the data set prior to using `PROC MEANS`

.

### 2. SAS Proc SQL (40 points)

For this question, a subset of the tables contained in the History of Baseball database are available in SAS. Additional details are available here: https://www.kaggle.com/seanlahman/the-history-of-baseball. The following tables have been added to the course folder as SAS data sets:

Use SAS Proc SQL to select players born in the State of Montana and compute:

the total number of players the total number of homeruns by these players. (This will require joining the batting and player tables).

### 3. Creating a data set (20 points)

- Create a data set consisting of each group member’s:

- name,
- residence for the summer, and
- number of Sweet Peaks ice cream cones that will be eaten.

- Print this data set and make sure to include an informative title.