---
title: "Lab 12: SAS Basic"
author: 'Group Member Names - here'
output: html_document
---
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)

a. Using a LIBNAME reference, load the housing file.
b. Create a new SAS data set that only contains homes in MT, CO, ID, and WY.
c. 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:

- batting
- player

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)

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

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