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)

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

  1. 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.
  1. Print this data set and make sure to include an informative title.