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 […]