Question
1. NHLQualiers.txt is a tab delimited file containing information on the 2020 Stanley Cup Playo Qualiers. The data set includes the variables WinningTeam (the name
1. NHLQualiers.txt is a tab delimited file containing information on the 2020 Stanley Cup Playo
Qualiers. 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 NHLQualiers.txt le 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 NHLQualiers.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.
WinningTeam WTScore LosingTeam LTScore Date
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 Blues 1 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 Blues 4 8/6/20
Vegas Golden Knights 4 Colorado Avalanche 3 8/8/20
Dallas Stars 2 St. Louis Blues 1 8/9/20
Chicago Blackhawks 6 Edmonton Oilers 4 8/1/20
Edmonton Oilers 6 Chicago Blackhawks 3 8/3/20
Chicago Blackhawks 4 Edmonton Oilers 3 8/5/20
Chicago Blackhawks 3 Edmonton Oilers 2 8/7/20
Arizona Coyotes 4 Nashville Predators 3 8/2/20
Nashville Predators 4 Arizona Coyotes 2 8/4/20
Arizona Coyotes 4 Nashville Predators 1 8/5/20
Arizona Coyotes 4 Nashville Predators 3 8/7/20
Minnesota Wild 3 Vancouver Canucks 0 8/2/20
Vancouver Canucks 4 Minnesota Wild 3 8/4/20
Vancouver Canucks 3 Minnesota Wild 0 8/6/20
Vancouver Canucks 5 Minnesota Wild 4 8/7/20
Calgary Flames 4 Winnipeg Jets 1 8/1/20
Winnipeg Jets 3 Calgary Flames 2 8/3/20
Calgary Flames 6 Winnipeg Jets 2 8/4/20
Calgary Flames 4 Winnipeg Jets 0 8/6/20
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started