SAS Certified Base Programmer 123 Questions (48)
The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY. 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 […]
SAS Certified Base Programmer 123 Questions (47)
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 […]
SAS Certified Base Programmer 123 Questions (46)
The following SAS program is submitted: data stats; set revenue; array weekly{5} mon tue wed thus fri; <insert DO statement here> total = weekly{i} * .25; 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} […]
SAS Certified Base Programmer 123 Questions (45)
The following SAS program is submitted: data work.test; array agent{4} $ 12 sales1 – sales4; run; Which one of the following represents the variables that are contained in the output data set? A. SALES1, SALES2, SALES3, SALES4 B. AGENTS1, AGENTS2, AGENTS3, AGENTS4 C. None, the DATA step fails because the ARRAY statement can reference only […]
SAS Certified Base Programmer 123 Questions (44)
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, […]