Description

Scope:
Specific Instructions for this Assignment:
2. Create a report of teams who played in all three of the tournaments for which data were provided. Include the team name, the team’s seed each year, the team’s average PPG of all the players on their roster each year, and the year. Sort the output by team and year. The approach to solving this problem is similar to Assignment 04 except you are using SQL tools this time. Use the INTERSECT operator to determine which schools were in all three tournaments.
3. Three PDF files must be uploaded to WebAssign. Convert your program and the SAS log to PDF files. The third file will contain all the requested output from ODS PDF. The program must contain a completed header block and comment blocks for each step. Except for style, options must be set so the output looks like that in the Assignment output posted on eCampus.