Description

Stat 657 Assignment 11 – SAS
Scope:
This assignment uses macro and SQL techniques covered through Lecture 18. This assignment will use the files in the Orion library supplied with the SQL portion of this class and the ncaam06 data set provided for an earlier assignment.
Specific Instructions for this Assignment:
1. Use all three system options that will cause macro resolution, macro code and macro execution information to be written to the log.
9. The report procedure below produces a summary of teams in the WDC region based on the dataset created in the previous step. At this point you are to create a data driven macro definition that will produce a separate report for each region in the data. The only parameter of the macro definition will be the name of the input dataset.

a. Create a data set containing an unduplicated list of the regions.
b. Use a data step to create macro variables for each region and the total number of regions.
c. Replace the data set name and WDC in the code below with appropriate macro references and use a loop to iteratively process the report procedure once for each of the regions in the data.
proc report data=dsname nowd; where region=’WDC’;
define ppg /mean format=8.1 ‘Average Points’; define rpg /mean format=8.1 ‘Average Rebounds’; run;
10. 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.