Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Sashelp.Baseball data set contains salary and performance information for Major League Baseball players ( excluding pitchers ) who played at least one game in

The Sashelp.Baseball data set contains salary and performance information for Major League Baseball players (excluding pitchers) who played at least one game in both the 1986 and 1987 seasons (Time Inc. 1987). The salaries are for the 1987 season, and the performance measures are from the 1986 season.
a. Write a PRINT step to display the permanent data set in the SAShelp library, Baseball.
b. Use a SORT procedure to read in the permanent data set, Baseball, to create a temporary data set called Baseball sorted by team. The OUT= option will need to be utilized.
c. Write another PRINT step that references the newly sorted temporary Baseball dataset.
a. Add a SUM statement to the PROC PRINT to display the sum of nHome (number of home runs) BY Team (will need a BY statement).
d. Write a PROC UNIVARIATE step to generate statistics for the Salary column in the temporary Baseball table.
a. Add a statement to display the player's name in the Extreme Observations Table.
e. What is the Table name (name of output object in the LOG?) of the second table that is generated by the PROC UNIVARIATE?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

10th Edition

0137916787, 978-0137916788

More Books

Students also viewed these Databases questions