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?
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库SAS ADVANCE（63题，无答案版，适合独立练习使用）(3)在线全文阅读。
相关推荐：