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