logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Steven HughesEducation
(5/5)

751 Answers

Hire Me
expert
Bidit SadhukhanStatistics
(/5)

608 Answers

Hire Me
expert
Pierre BernierData mining
(5/5)

984 Answers

Hire Me
expert
Liam PattersonEnglish
(5/5)

867 Answers

Hire Me
SAS
(5/5)

Create the InputDS libref and RawData fileref that are both associated with the data folder on your shared drive

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Specifications:

Create the InputDS libref and RawData fileref that are both associated with the data folder on your shared drive. As always, do this using relative paths. Also using relative paths that point directly to your HW2 folder, create your libref and fileref that are associated with the single location where you want to save your results from HW2. (This will likely be the last time I remind you to set up your references.)

Read in the Baseball.dat file data set from your shared library on the L drive and use it to produce a report that matches my reports (plural!) found in HW2 Baseball Report.pdf and HW2 Baseball Report.rtf. There are a few elements you’ll need that cannot be inferred from the provided report, for those I’ve provided these pointers!

–    The PDF uses the Journal style and the RTF uses the Sapphire style.

–    Name your files the way we did before, including your name as part of the file. For example, Tony Stark would create a file called HW2 Stark Baseball Report.

–    Subtitles use 10pt font and footnotes use 8pt font.

–    For those of you who are not familiar with baseball, there are often multiple teams from the same state, or even city, so take care when selecting records.

–    The two reports are not identical. The RTF includes some results that are excluded from the  PDF.  You already know how to identify and select/exclude output objects - but here you need to selectively place them in a particular destination. To do this, you’ll need the following statements - it is up to you to figure out where to put them and what they do!

∗ ODS PDF EXCLUDE NONE;

∗ ODS PDF EXCLUDE ALL;

–    At several points in the report, I have applied a custom format to the Salary variable. That format is named Salary and is located in the InputDS library. As discussed in class and in your reading, it is possible to use a format from a permanent library. To use it in this assignment, you’ll need to do the following:

1.    Include an  OPTIONS statement  that includes FMTSEARCH  =  (InputDS) after you’ve established this library. This will give you access to all formats in this library. (While you’re at it - throw in a NODATE option in the same statement to get rid of the dates and times in your report headers.)

2.    Print out the format (only in the RTF) to see its definition. If necessary, you can choose which formats are included in your printout by using the SELECT statement and naming the format(s) you want to see.

3.    Do not redefine the format yourself! The goal here is to use one that has been provided to you!

–    The labels are rather long, and make the PROC MEANS results look pretty messy. Just like PROC PRINT has a LABEL

option, PROC MEANS has a NOLABELS option - use it!

–    There are many players for whom the Salary is missing. However, we don’t want to exclude these players. In both the MEANS and FREQ steps, these will be automatically filtered out because of the CLASS and TABLES statements, respectively. To fix this, use the MISSING option in both of these statements.

In these cases, as in many statements in SAS, options are applied after a forward slash in the statement you want to modify. For example, saying CLASS Avar Bvar / MISSING; adds the MISSING option to this CLASS statement.

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

368 Experts Online