Question: Based on the following program and data, how many rows will be included in the payments _ clean table? proc sort data = emp _

Based on the following program and data, how many rows will be included in the payments_clean table?
proc sort data=emp_payments
out=payments_clean
dupout=payments_dups
nodupkey;
by _all_;
run;
ID
Amount
A
$916.32
A
$854.17
B
$879.05
B
$932.77
C
$879.05
C
$747.96
2
3
5
6
2.
Question 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
Format Order_date date7. Delivery_Data mmddyy8.;
Format Order_Date monyy7. Delivery_Date mmddyy8.;
Format Order_Date date9. Delivery_date mmddyy8.;
Format Order_Date ddmmyy. Delivery_date mmddyy8.;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!