1. NHLQualifiers.txt is a tab delimited file containing information on the 2020 Stanley Cup Playoff Qualifiers. The data set includes the variables WinningTeam (the name of the winning team), WTScore (the winning team's score), LosingTeam (the name of the losing team), LTScore (the losing team's score), and Date (the date on which the game was held). Take note of the date format in the .txt file.

(a) Load the NHLQualifiers.txt file into SAS. The entirety of the team names should be stored and the Date variable should be stored as date data. Use functions in SAS to create a variable called DaySince. This variable should be the number of days since the game took place. Print the resulting SAS data set and report the output.

(b) Load the NHLQualifiers.txt file into R. Convert the Date variable into date data. Create a new variable called EndQual. This variables should be the number of hours between the date of the game and the date the qualifying round ended, which was August 9, 2020. Print the resulting data frame and report the output.

NHLQualifiers.txt: WinningTeam WTScoreLosingTeam LTScoreDate

Philadelphia Flyers 4 Boston Bruins 1 8/2/20

Tampa Bay Lightning 3 Washington Capitals 2 8/3/20

Tampa Bay Lightning 3 Boston Bruins 2 8/5/20

Philadelphia Flyers 3 Washington Capitals 1 8/6/20

Philadelphia Flyers 4 Tampa Bay Lightning 1 8/8/20

Washington Capitals 2 Boston Bruins 1 8/9/20

Montreal Canadiens 3 Pittsburgh Penguins 2 8/1/20

Pittsburgh Penguins 3 Montreal Canadiens 1 8/3/20

Montreal Canadiens 4 Pittsburgh Penguins 3 8/5/20

Montreal Canadiens 2 Pittsburgh Penguins 0 8/7/20

Carolina Hurricanes 3 New York Rangers 2 8/1/20

Carolina Hurricanes 4 New York Rangers 1 8/3/20

Carolina Hurricanes 4 New York Rangers 1 8/4/20

New York Islanders 2 Florida Panthers 1 8/1/20

New York Islanders 5 Florida Panthers 2 8/4/20

Florida Panthers 3 New York Islanders 2 8/5/20

New York Islanders 5 Florida Panthers 1 8/7/20

Columbus Blue Jackets 2 Toronto Maple Leafs 0 8/2/20

Toronto Maple Leafs 3 Columbus Blue Jackets 0 8/4/20

Columbus Blue Jackets 4 Toronto Maple Leafs 3 8/6/20

Toronto Maple Leafs 4 Columbus Blue Jackets 3 8/7/20

Columbus Blue Jackets 3 Toronto Maple Leafs 0 8/9/20

Colorado Avalanche 2 St. Louis Blues1 8/2/20

Vegas Golden Knights 4 Dallas Stars 3 8/3/20

Colorado Avalanche 4 Dallas Stars 0 8/5/20

Vegas Golden Knights 6 St. Louis Blues4 8/6/20

Vegas Golden Knights 4 Colorado Avalanche 3 8/8/20

Dallas Stars 2 St. Louis Blues1 8/9/20

Chicago Blackhawks 6 Edmonton Oilers4 8/1/20

Edmonton Oilers6 Chicago Blackhawks 3 8/3/20

Chicago Blackhawks 4 Edmonton Oilers3 8/5/20

Chicago Blackhawks 3 Edmonton Oilers2 8/7/20

Arizona Coyotes4 Nashville Predators 3 8/2/20

Nashville Predators 4 Arizona Coyotes2 8/4/20

Arizona Coyotes4 Nashville Predators 1 8/5/20

Arizona Coyotes4 Nashville Predators 3 8/7/20

Minnesota Wild3 Vancouver Canucks 0 8/2/20

Vancouver Canucks 4 Minnesota Wild3 8/4/20

Vancouver Canucks 3 Minnesota Wild0 8/6/20

Vancouver Canucks 5 Minnesota Wild4 8/7/20

Calgary Flames4 Winnipeg Jets 1 8/1/20

Winnipeg Jets 3 Calgary Flames2 8/3/20

Calgary Flames6 Winnipeg Jets 2 8/4/20

Calgary Flames4 Winnipeg Jets 0 8/6/20