Reference no: EM131596214

Assignment

Problem 1. Refer to Table 1 to complete the following questions.

Name	Class	Homework	Midterm1	Midterm2	Project
Justin	1	.	88	90	82
Christal	1	100	85	80	88
Rebecca	1	80	77	.	65
Easton	2	90	.	76	73
Jacob	2	60	67	53	70
Cindy	2	85	83	66	90

Table 1: Grades

1. Create a new folder named Final in your computer. Specify a library reference name for this library and read the dataset in Table 1 into the library.

2. Create a new variable Avgmid, which is the average of the two midterms. If one of the two midterms is a missing value, I expect the average to be the grade of non-missing one. For example, if John misses midterm1 and his grade for midterm2 is 90, then Avgmid for John should be 90. And then calculate the final score (denoted by the variable Final ) according to the following rule:

Final = 30%Homework + 40%Avgmid + 30%Project If Homework is a missing value, then the final score is defined to be

Final = 50%Avgmid + 50%Project

3. Use Means Procedure to generate a summary dataset, which should includes the mean, median and standard deviation for the final score of students in Class 1, students in Class 2 and all of the students.

4. Use Report Procedure to generate a report for the summary dataset, use Define State- ment to define labels for the variables.

5. From the report you generated, what are the mean, median and standard deviation for the final score of students in Class 1, students in Class 2 and all of the students? Please write answers in the comments of your .sas file.

Problem 2. We have the following small dataset.

Item	Shop	Year	Date	Price
Cellphone	A	2013	02/25/2013	$259.99
Vacuum Cleaner	W	2014	09/30/2014	$78.29
Toaster	A	2014	07/12/2014	$32.35
Microwave	E	2013	12/05/2013	$87.40
Headphone	E	2014	01/03/2014	$96.72
Monitor	A	2013	03/21/2013	$275.99
Clothes Iron	W	2013	10/04/2013	$39.73

Table 2: Shopping List

The columns, from left to right, represent the following variables (see Table 3):

Variable Name	Description	Variable Type
Item	Item name	Character
Shop	Code for shop	Character
Year	Year when bought	Numeric
Date	Date when bought	Numeric
Price	Price of the item	Numeric

Table 3: Description

1. Use proper method to read the dataset in Table 2 into the library and generate two reports using Report Procedure and one two-way frequency table using Freq Procedure. I want you to create reports and table looking similar to Figure 1. (See next page)

Pay attention to:

(a) the group of items, ( hint: the items are grouped by Shop and Year ); (b)the label of variables;

(c) the format of variables, ( hint: you might use Format Procedure to define your own informat and format);

(d) the title;

(e) there is one variable with label "Number of Items" in the summary report.

2. What is the meaning of the four numbers in the cell Amazon× 2014? Please write answers in the comments in your .sas file.

Attachment:- Assignment.pdf