A00-212 practice questions, page 5 of 8, with answer review and explanations.
Question 21
Given the SAS data sets ONE and TWO: The following SAS program is submitted: Data combine; Merge one two; By id; Run; Which SQL procedure program procedures the same results?
proc sql; Create table combine as Select coalesce (one.id, two.id) as id, Name,salary from one, two where one.id=two.id; Quit;
proc sql; Create table combine as Select one.id, Name, salary from one full join two where one.id=two.id; Quit
proc sql; Create table combine as Select one.id,name,salary from one inner join two on one.id=two.id Quit
proc sql; Create table combine as Select coalesce (one id, two id) as id, Name,salary from one full join two on one.id=two.id;
Question 22
The following SAS program is submitted: proc contents data = testdata.one; run; Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA.ONE?
proc sql; Contents table testdata.one; Quit;
proc sql; Describe table testdata.one; Quit;
proc sql; describe testdata.one; Quit;
proc sql; Contents testdata.one; Quit;
Question 23
The following SAS program is submitted: data temp; array points{2,3} (10,15,20,25,30,35); run; What impact does the ARRAY statement have in the Program Data Vector(PDV)?
No variable are created in the PDV
The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV
The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV
Question 24
Given the SAS data set ONE: ONE - NUM VAR - 1 A 2 B 3 C Which SQL procedure program deletes the data set ONE?
proc sql; Drop table one; Quit;
proc sql; Remove table one; Quit;
proc sql; Delete table one; Quit;
proc sql; Delete from one;
Question 25
The following SAS program is submitted: %macro location; data _null_; call symput ('dept','sales'); run; %let country=Germany; %put_global_; %mend; %let company = ABC; %location; Which macro variables are written to the SAS log?