Archive for August, 2009
SAS Certified Adv Programmer 50 Questions (3)
Which one of the following programs is syntactically correct? a. proc sql; create table forecast as select a.*, b.sales from actual a, budget b where a.dept=b.dept and a.month=b.month; quit; b. proc sql; create table forecast as select a.* b.sales from actual as a, budget as b where a.dept=b.dept and a.month=b.month; quit; c. proc sql; create […]
SAS Certified Adv Programmer 50 Questions (2)
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 right join two on one.year=two.year; quit; Which of the following […]
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. […]