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.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
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
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
