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;
Quit;

Answer(s): D

Reveal Solution Next Question

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;

Answer(s): B

Reveal Solution Next Question

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

Answer(s): C

Reveal Solution Next Question

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;
Quit;

Answer(s): A

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 6)

QUESTION: 21

QUESTION: 22

QUESTION: 23

QUESTION: 24