ts of a Mathematic Competition

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
The results of a Mathematic Competition are stored in the SAS data set Marks.
Variable
Label
STUDENT ID
SCHOOL
Student's identification number
School (1 = SMK Puteri, 2 = SMK Cabang Tiga, 3 = SMK Dato' Harun)
M1
Mark for first round
M2
M3
Mark for second round
Mark for third round
Obs STUDENT_ID SCHOOL M1 M2 M3 51
1 STTO01
52
53
Average
85 80
03 Passed
Passed
Passed
82.6867
2 STTO02
1
34
75
74 Passed Passed Passed
77.6007
1 STTO03
77
53 Passed Faled
Passed
82.0000
4 STTO04
80
80
95 Passed Passed Passed
85.0000
5 STTO05
2 00
55
00 Faled
Faled
Passed
ও1.3333
6 STTO00
2 0e e7 01 Faled
Passed Passed
85.0007
7 STTO07
3 68 71 7o Failed
3 81 80 90 Passed Passed Passed
3 72 04
Passed Passed
60.0000
8 STTOOS
83.0007
9 STTO00
01 Passed Passed Passed
85.0007
Use PROC SQL to create new temporary SAS data set Over80 which contain only students who obtain average
mark more than 80. Do not include the variable status (S1-S3) to the new data set.
Transcribed Image Text:The results of a Mathematic Competition are stored in the SAS data set Marks. Variable Label STUDENT ID SCHOOL Student's identification number School (1 = SMK Puteri, 2 = SMK Cabang Tiga, 3 = SMK Dato' Harun) M1 Mark for first round M2 M3 Mark for second round Mark for third round Obs STUDENT_ID SCHOOL M1 M2 M3 51 1 STTO01 52 53 Average 85 80 03 Passed Passed Passed 82.6867 2 STTO02 1 34 75 74 Passed Passed Passed 77.6007 1 STTO03 77 53 Passed Faled Passed 82.0000 4 STTO04 80 80 95 Passed Passed Passed 85.0000 5 STTO05 2 00 55 00 Faled Faled Passed ও1.3333 6 STTO00 2 0e e7 01 Faled Passed Passed 85.0007 7 STTO07 3 68 71 7o Failed 3 81 80 90 Passed Passed Passed 3 72 04 Passed Passed 60.0000 8 STTOOS 83.0007 9 STTO00 01 Passed Passed Passed 85.0007 Use PROC SQL to create new temporary SAS data set Over80 which contain only students who obtain average mark more than 80. Do not include the variable status (S1-S3) to the new data set.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY