SAS Quiz 3.pdf - 2/2/22 4:53 PM Quiz Feedback Print Quiz:...

2/2/22, 4:53 PM Quiz Feedback
Print
Quiz: Lesson 3
Your Score:
90%
Congratulations! Your score indicates that you have mastered the topics in this
course. You can review the feedback and when you're finished, exit the lesson.
1. Based on the following program and data, how many rows will be included in the payment
table?
proc sort data=payment dupout=dups nodupkey;
by ID;
run;
ID Amount
A $997.54
A $833.88
B $879.05
C $894.77
C $894.77
C $998.26
a. 1
b. 3
c. 5
d. 6
Your answer:
Correct answer:
The NODUPKEY option keeps the first row for each unique value of ID , which includes A, B
and C.
b
b
1/4
2. Which of the following FORMAT statements was used to create this output?
Obs Order_ID Order_Date Delivery_Date
1 1230058123 11JAN07 01/11/07
2 1230080101 15JAN07 01/19/07
3 1230106883 20JAN07 01/22/07
4 1230147441 28JAN07 01/28/07
5 1230315085 27FEB07 02/27/07