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

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

expert
Laurence FarrelllPsychology
(5/5)

699 Answers

Hire Me
expert
Barry CresswelllTechnical writing
(5/5)

881 Answers

Hire Me
expert
Jaydon KeySocial sciences
(5/5)

730 Answers

Hire Me
expert
Nikhil JainComputer science
(5/5)

646 Answers

Hire Me
SAS
(5/5)

For this question, you will be asked to collect data from 5 people and enter it directly into a permanent SAS dataset named MYDATA.

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Question #1. Input the raw data file called BASKETBALL.TXT by calling it into the SAS Editor or using another editor such as NOTEPAD on your PC.  This data set contains data on every NCAA Basketball Tournament game played between the years 1991-1995 (data were obtained from www.amstat.org/publications/jse).  There are FIVE variables included on the data set (listed in order of appearance): Year, Winning School, Winning Score, Losing School, and Losing Score.  Which method(s) of input seems most appropriate for these data?  Regardless of which is most appropriate, read in this ASCII data file using an INFILE statement.  YOU MUST PRESERVE THE INTEGRITY OF THE RAW DATASET.   In other words, no letters should be truncated.  Character variables should be created to contain the values of the winning and losing schools, all other variables should be numeric. 

 

The INFILE statement is used when reading in raw data from an external file.  You must also use the appropriate input instructions in the input statement such as column input or informats if necessary.  For example, if my file was in my 'c:\sta511\data' directory, the first few lines of my program would be:

 

data <NAME OF MY NEW SAS DATASET>;

infile '\\client\c$\sta511\data\basketball.txt';

input <LIST OF VARIABLE NAMES WITH APPROPRIATE INPUT INSTRUCTIONS>;

run;

 

Run PROC PRINT and examine your output side by side with the original text file to make sure that you successfully read the data into SAS, maintaining the structure of the original data.  MAKE SURE TO SPOT CHECK LONGER UNIVERSITY NAMES AND THREE DIGIT SCORES TO MAKE SURE YOU HAVE PRESERVED THE INTEGRITY OF THE DATA.

 

 

 

Question #2. 

 

For this question, you will be asked to collect data from 5 people and enter it directly into a permanent SAS dataset named MYDATA.  For each person you should get data for the following variables in the exact way specified below.  (If someone does not submit data for one of the variables, you can indicate that in your dataset as missing data.)  Remember to follow the SAS rules for naming variables.

 

1. NAME: Enter the person's first and last name.  However, let one variable field (NAME) contain both first and last names.  

2. COLOR OF SHIRT:  Enter the color of the shirt the person is wearing.

3. MONEY IN POCKETS: Ask the person how much money they have in their pockets.  Enter this data in $xx.xx format.  For example, someone with a ten dollar bill and 2 quarters should be entered as $10.50. 

4. DATE OF QUESTION.  Enter the date that you asked for this information.  Use the date notation ddMMMyy where dd represents the day, MMM the three letter month abbreviation and yy the two digit year.  Use the appropriate SAS informat that would recognize and correctly input dates in this format.  For example, 15SEP08 should be entered to symbolize September 15, 2008.  

 

After entering the data, run a PROC PRINT and PROC CONTENTS.  Do not worry about formatting your printed output - we will talk more about this later in the course.  In other words, you may leave the dates seen in PROC PRINT as the number of days since Jan. 1, 1960 and you may leave the MONEY variable seen in your output without a dollar sign.  Just be sure that no letters were truncated and no information was lost in reading in your data.

(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!

439 Experts Online