SAS Certified Adv Programmer 130 Questions (53)
Which one of the following is the purpose of the IDXNAME= data set option? A. It instructs SAS to name and store a specific index. B. It instructs SAS to store an index in a particular location. C. It instructs SAS to use a specific index for WHERE processing. D. It instructs SAS to use […]
SAS Certified Adv Programmer 130 Questions (52)
The following SAS program is submitted: data temp; array points{2,3} _temporary_; run; Which one of the following is the maximum number of elements that are stored? A. 2 B. 3 C. 5 D. 6
SAS Certified Adv Programmer 130 Questions (51)
Which one of the following displays the definition of a stored SQL procedure view in the SAS log? A. ECHO VIEW option B. EXPAND VIEW option C. VALIDATE VIEW statement D. DESCRIBE VIEW statement
SAS Certified Adv Programmer 130 Questions (50)
Which one of the following is true regarding the KEEP statement? A. The KEEP statement is available in both the DATA and the PROC steps B. The KEEP statement selects the variables read from the input data set(s). C. The KEEP statement applies to all data sets created within the same DATA step. D. The […]
SAS Certified Adv Programmer 130 Questions (49)
Given the following SAS data set ONE: ONE LEVEL AGE 1 10 2 20 3 20 2 10 1 10 2 30 3 10 2 20 3 30 1 10 The following SAS program is submitted: proc sql; select level, max(age) as MAX from one group by level having max(age) > (select avg(age) from one); […]