45. The Rose Bowl is a college football tradition that dates back to the early 1900s. The Microsoft Excel file RoseBowl.xlsx contains records on the winning and losing teams during the Rose Bowls history. The variables in this file are game date, winning team, winning score, losing team, and losing score. These data are sorted by winning team and then by date.

a. Examine the Microsoft Excel file RoseBowl.xlsx and read it into SAS.

b. Create a variable that calculates the difference in points between the two teams.

c. Present the game date using a format that includes the day of the week.

d. Create a cumulative counter variable that tracks the total number of Rose Bowl games.

e. Create another cumulative counter variable that tracks the number of points scored in all of the games.