run;
Which one of the following represents the values of the AMOUNT and WORD variables? A. amount word 7 FOUR
B. amount word 7 SEVEN
C. amount word 4 FOUR
D. amount word
4 ' ' (missing character value) 67
The SAS data set EMPLOYEE_INFO is listed below: IDNumber Expenses 2542 100.00 3612 133.15 2198 234.34 2198 111.12
The following SAS program is submitted: proc sort data = employee_info; run;
Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value? A. by descending IDNumber Expenses; B. by (IDNumber Expenses) descending;
C. by IDNumber descending Expenses descending; D. by descending IDNumber descending Expenses; 68
The SAS data set QTR1_REVENUE is listed below: destination revenue YYZ 53634 FRA 62129 FRA 75962 RDU 76254 YYZ 82174
The following SAS program is submitted: proc sort data = qtr1_revenue;
by destination descending revenue; run;
Which one of the following represents the first observation in the output data set? A. destination revenue
26
YYZ 82174
B. destination revenue YYZ 53634
C. destination revenue FRA 62129
D. destination revenue FRA 75962 69
The following SAS program is submitted: libname company 'SAS-data-library'; proc sort data = company.payroll; by EmployeeIDNumber; run;
Write access has been granted to the COMPANY library.
Which one of the following represents how the observations are sorted?
A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by
EmployeeIDNumber.
C. COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.
D. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber. 70
The SAS data set EMPLOYEE_INFO is listed below: IDNumber Expenses 2542 100.00 3612 133.15 2198 234.34 2198 111.12
The following SAS program is submitted: proc sort data = employee_info; run;
Which one of the following BY statements completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value? A. by Expenses IDNumber; B. by IDNumber Expenses;
C. by ascending (IDNumber Expenses);
27
D. by ascending IDNumber ascending Expenses; 71.
The SAS data set WORK.AWARDS is listed below: fname points Amy 2 Amy 1 Gerard 3 Wang 3 Wang 1 Wang 2
The following SAS program is submitted: proc sort data = work.awards; by descending fname points; run;
Which one of the following represents how the observations are sorted? A. Wang 3 Gerard 3 Wang 2 Amy 2 Wang 1 Amy 1 B. Wang 3 Wang 2 Wang 1 Gerard 3 Amy 2 Amy 1 C. Wang 3 Wang 1 Wang 2 Gerard 3 Amy 2 Amy 1 D. Wang 1 Wang 2 Wang 3 Gerard 3 Amy 1 Amy 2 72
The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.
28
The following SAS program is submitted:
proc sort data = work.test out = work.testsorted; by name; run;
Which one of the following is the result of the SAS program?
A. The data set WORK.TEST is stored in ascending order by values of the NAME variable. B. The data set WORK.TEST is stored in descending order by values of the NAME variable.
C. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.
D. The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable. 73
Which one of the following statements is true regarding the name of a SAS array? A. It is saved with the data set. B. It can be used in procedures.
C. It exists only for the duration of the DATA step.
D. It can be the same as the name of a variable in the data set.s 74
The following SAS program is submitted: data stats; set revenue;
array weekly{5} mon tue wed thu fri;
total = weekly{i} * .25; output; end; run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array? A. do i = 1 to 5;
B. do weekly{i} = 1 to 5; C. do i = mon tue wed thu fri;
D. A DO loop cannot be used because the variables referenced do not end in a digit.s 75
The following SAS program is submitted: data stats; set revenue;
array weekly{5} mon tue wed thu fri;
total = weekly{i} * .25; output;
29
end; run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array? A. do i = 1 to 5;
B. do weekly{i} = 1 to 5; C. do i = mon tue wed thu fri;
D. A DO loop cannot be used because the variables referenced do not end in a digit.s 76
The following SAS program is submitted: data work.test;
set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 - difsales3; array monthly{3} jansales febsales marsales; run;
Which one of the following represents the new variables that are created? A. JANSALES, FEBSALES and MARSALES B. MONTHLY1, MONTHLY2 and MONTHLY3 C. DIFSALES1, DIFSALES2 and DIFSALES3
D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3 77
On which portion(s) of a SAS data set does the PRINT procedure report? A. the data portion only
B. the descriptor portion only
C. the descriptor portion and the data portion
D. neither the data portion nor the descriptor portion 78
Which one of the following SAS procedures displays the data portion of a SAS data set? A. PRINT B. FSLIST C. CONTENTS D. DATASETS 79
The following SAS program is submitted: proc datasets lib = sasuser; contents data = class varnum; quit;
Which one of the following is the purpose of the VARNUM option? A. to print a list of variable names
B. to print the total number of variables
C. to print a list of the variables in alphabetic order
30