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} = 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.
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 numeric data.
D. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.
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, DIFF_SALES2 and DIFF_SALES3
SAS Certified Base Programmer 123 Questions (43)
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
SAS Certified Base Programmer 123 Questions (42)
Which one of the following SAS procedures displays the data portion of a SAS data set?
A. PRINT
B. FSLIST
C. CONTENTS
D. DATASETS