SAS Certified Adv Programmer 50 Questions (1)
Given the following SAS data sets One and Two: One Year Qtr Budget 2001 3 500 2001 4 400 2002 1 700 Two Year Qtr Sales 2001 4 300 2002 1 600 The following SAS program is submitted: proc sql; select one.*, sales from one, two where one.year=two.year and one.qtr=two.qtr; quit; Which of the following […]
SAS Certified Base Programmer 50 Questions (50)
The following SAS program is submitted: data test; input country $8. date mmddyy10.; cards; Germany 12/31/2000 France 01/32/2001 ; run; Which one of the following is the value of the variable _ERROR_ when the variable _N_ has a value of 2? a. 0 b. 1 c. true d. false
SAS Certified Base Programmer 50 Questions (49)
Which one of the following statements is true when SAS encounters a data error? a. The execution phase is stopped, and a system abend occurs. b. A missing value is assigned to the appropriate variable, and execution continues. c. The execution phase is stopped, and a SAS data set is created with zero observations. d. […]
SAS Certified Base Programmer 50 Questions (48)
The following SAS program is submitted: proc report data=survey nowd; column age choice1; <insert DEFINE statement here> define choice1/display; run; Which one of the following DEFINE statements completes the program and displays values of the variable Age in ascending order? a. define age/sort; b. define age/order; c. define age/sort by age; d. define age/order by […]
SAS Certified Base Programmer 50 Questions (47)
The following SAS program is submitted: data work.travel; do i=1 to 6 by 2; trip + i; end; run; Which one of the following is the value of the variable trip in the output data set? a. 2 b. 3 c. 9 d. 10