Id Name Id Salary --- ------ --- ------ 112 Smith 243 150000 243 Wei 355 45000 457 Jones 523 75000
The following SAS program is submitted:
data WORK.COMBINE;
merge WORK.ONE WORK.TWO; by Id; run;
Which SQL procedure statement produces the same results?
A.
create table WORK.COMBINE as select Id,
Name, Salary from
WORK.ONE full join WORK.TWO on ONE.Id=TWO.Id ;
B.
create table WORK.COMBINE as select
coalesce(ONE.Id, TWO.Id) as Id, Name, Salary from
WORK.ONE, WORK.TWO
where ONE.Id=TWO.Id ;
C.
create table WORK.COMBINE as
select
coalesce(ONE.Id, TWO.Id) as Id, Name, Salary from
WORK.ONE full join WORK.TWO on ONE.Id=TWO.Id order by Id ;
D.
create table WORK.COMBINE as select
coalesce(ONE.Id, TWO.Id) as Id, Name, Salary from
WORK.ONE, WORK.TWO
where ONE.Id=TWO.Id order by ONE.Id ;
Item 14 of 63 Mark item for review
The following SAS program is submitted:
proc contents data=TESTDATA.ONE; run;
Which SQL procedure step produces similar information about the column attributes of TESTDATA.ONE?
A.
proc sql;
contents from TESTDATA.ONE;
quit;
B.
proc sql;
describe from TESTDATA.ONE; quit;
C.
proc sql;
contents table TESTDATA.ONE; quit;
D.
proc sql;
describe table TESTDATA.ONE; quit;
Item 15 of 63 Mark item for review
Given the SAS data set WORK.ONE:
Rep Cost ----- ---- SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100
The following SAS program is submitted;
proc sql; select Rep, avg(Cost) from WORK.ONE order by Rep ; quit;
Which result set would be generated?
A.
JONES 280 JONES 280 SMITH 280 SMITH 280 SMITH 280
B.
JONES 600 SMITH 100
C.
JONES 280 SMITH 280
D.
JONES 100 JONES 100 SMITH 600 SMITH 600 SMITH 600
Item 16 of 63 Mark item for review
Given the SAS data sets:
WORK.MATH1A WORK.MATH1B
Name Fi Name Fi ------- -- ------ -- Lauren L Smith M Patel A Lauren L Chang Z Patel A Hillier R
The following SAS program is submitted:
proc sql;
select *
from WORK.MATH1A
[_insert_set_operator_] select *
from WORK.MATH1B ; quit;
The following output is desired:
Name Fi ------- -- Lauren L Patel A Chang Z Hillier R Smith M Lauren L Patel A
Which SQL set operator completes the program and generates the desired output?
A. append corr
B. union corr
C.
outer union corr
D.
intersect corr
Item 17 of 63 Mark item for review
Which of the following is an advantage of SAS views?
