## SAS Certified Adv Programmer 50 Questions (8)

Given the following SAS data sets One and Two: One Num Char1 1 A 2 B 4 D Two Num Char2 2 X 3 Y 5 V The following SAS program is submitted creating the output table Three: data three; merge one (in=in1) two (in=in2); by num; if in2; run; Three Num Char1 Char2 2 […]

## SAS Certified Adv Programmer 50 Questions (7)

How many columns can an SQL procedure subquery within a WHERE or HAVING clause return to the outer query? a. 0 b. 1 c. 2 d. the same number of columns that are in the table

## SAS Certified Adv Programmer 50 Questions (6)

Given the following SAS data sets One and Two: One Num Product 1 Computer 2 Printer 3 Monitor 4 Keyboard 5 Modem Two Num Product 1 Portable 5 External The following SAS program is submitted: proc sql; select product from one where exists (select * from two where one.num=two.num); Which of the following reports is […]

## SAS Certified Adv Programmer 50 Questions (5)

Given the following SAS data sets One and Two: One Num Var1 1 A 1 A 2 B 3 C Two Num Var2 1 A 4 Y 4 Z The following SAS program is submitted: proc sql; select * from one intersect all select * from two; quit; Which of the following reports is generated? […]

## SAS Certified Adv Programmer 50 Questions (4)

Given the following SAS data sets One and Two: One Num Var1 1 A 1 A 2 B 3 C Two Num Var2 1 A 4 Y 4 Z The following SAS program is submitted: proc sql; select * from one except select * from two; quit; Which of the following reports is generated? a. […]