SAS advance 63

Por favor, aguarde! Carregando...

Questão 1 de 103

1. When attempting to minimize memory usage, the most efficient way to do group processing when using the MEANS procedure is to use:

Selecione uma das seguintes:

A. the BY statement.
B. GROUPBY with the NOTSORTED specification.
C. the CLASS statement.
D. multiple WHERE statements.

Explicação

Questão 2 de 103

2. The SAS data set WORK.CHECK has a variable named Id_Code in it. Which SQL statement would create an index on this variable?

Selecione uma das seguintes:

A. create index Id_Code on WORK.CHECK;
B. create index(Id_Code) on WORK.CHECK;
C. make index=Id_Code from WORK.CHECK;
D. define index(Id_Code) in WORK.CHECK;

Explicação

Questão 3 de 103

3. Given the SAS data sets:

What would allow the program to successfully execute without errors?

Selecione uma das seguintes:

A. Replace the where clause with:
where EMPLOYEE.Name=(select Names delimited with ','
from WORK.NEWEMPLOYEE
where Salary > 40000);
B. Replace line 104 with:
where EMPLOYEE.Name =ANY (select Names separated with ','
from WORK.NEWEMPLOYEE
where Salary > 40000);
C. Replace the equal sign with the IN operator.
D. Qualify the column names with the table names.

Explicação

Questão 4 de 103

4. Given the SAS data set SASUSER.HIGHWAY:

Which SQL clause stores the text 0-29, 30-49, 50+ in the macro variable GROUPS?

Selecione uma das seguintes:

A. into &GROUPS
B. into :GROUPS
C. into :GROUPS separated by ','
D. into &GROUPS separated by ','

Explicação

Questão 5 de 103

5. The SAS data set WORK.CHECK has an index on the variable Code and the following SAS program is submitted.
proc sort data=WORK.CHECK;
by Code;
run;

Which describes the result of submitting the SAS program?

Selecione uma das seguintes:

A. The index on Code is deleted.
B. The index on Code is updated.
C. The index on Code is uneffected.
D. The sort does not execute.

Explicação

Questão 6 de 103

6. The table WORK.PILOTS contains the following data:

Which SQL statement could NOT generate this result?

Selecione uma das seguintes:

A. select
Jobcode,
Salary,
avg(Salary) label='Avg'
from WORK.PILOTS group by Jobcode
order by Id
;
B. select
Jobcode,
Salary,
(select avg(Salary)
from WORK.PILOTS as P1
where P1.Jobcode=P2.Jobcode) as Avg
from WORK.PILOTS as P2
order by Id
;
C. select
Jobcode,
Salary,
(select avg(Salary)
from WORK.PILOTS
group by Jobcode) as Avg
from WORK.PILOTS
order by Id
;
D. select
Jobcode,
Salary,
Avg
from
WORK.PILOTS,
(select
Jobcode as Jc,
avg(Salary) as Avg
from WORK.PILOTS
group by 1)
where Jobcode=Jc
order by Id
;
(define variable Avg in subquery in from clause.)

Explicação

Questão 7 de 103

7. A quick rule of thumb for the space required to run PROC SORT is:

Selecione uma das seguintes:

A. two times the size of the SAS data set being sorted.
B. three times the size of the SAS data set being sorted.
C. four times the size of the SAS data set being sorted.
D. five times the size of the SAS data set being sorted.

Explicação

Questão 8 de 103

8. Multi-threaded processing for PROC SORT will affect which of these system resources?

Selecione uma das seguintes:

A. CPU time will decrease, wall clock time will decrease
B. CPU time will increase, wall clock time will decrease
C. CPU time will decrease, wall clock time will increase
D. CPU time will increase, wall clock time will increase

Explicação

Questão 9 de 103

9. Given the SAS data set WORK.TRANSACT:

Which SQL statement was used?

Selecione uma das seguintes:

A. select
rep,
min(Cost+Ship)
from WORK.TRANSACT
order by Rep
;
select
Rep,
min(Cost,Ship) as Min
from WORK.TRANSACT
summary by Rep
order by Rep
;
C.
select
Rep,
min(Cost,Ship)
from WORK.TRANSACT
group by Rep
order by Rep
;
D.
select
Rep,
min(Cost+Ship)
from WORK.TRANSACT
group by Rep
order by Rep
;

Explicação

Questão 10 de 103

10. (%EVAL) The following SAS program is submitted:
%let Value=9;
%let Add=5;
%let Newval=%eval(&Value/&Add); %put &Newval;

What is the value of the macro variable Newval when the %PUT statement executes?

Selecione uma das seguintes:

A. 0.555
B. 2
C. 1.8
D. 1

Explicação

Questão 11 de 103

11. The following SAS code is submitted:
data WORK.TEMP WORK.ERRORS / view=WORK.TEMP;
infile RAWDATA;
input Xa Xb Xc;
if Xa=. then output WORK.ERRORS;
else output WORK.TEMP;
run;

Which of the following is true of the WORK.ERRORS data set?

Selecione uma das seguintes:

A. The data set is created when the DATA step is submitted.
B. The data set is created when the view TEMP is used in another SAS step.
C. The data set is not created because the DATA statement contains a syntax error.
D. The descriptor portion of WORK.ERRORS is created when the DATA step is submitted.

Explicação

Questão 12 de 103

12. Which title statement would always display the current date?

Selecione uma das seguintes:

A. title "Today is: &sysdate.";
B. title "Today is: &sysdate9.";
C. title "Today is: &today.";
D. title "Today is: %sysfunc(today(),worddate.)";

Explicação

Questão 13 de 103

13. Given the SAS data sets:

Which SQL procedure statement produces the same results?

Selecione uma das seguintes:

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
;

Explicação

Questão 14 de 103

14. 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?

Selecione uma das seguintes:

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;

Explicação

Questão 15 de 103

15. Given the SAS data set WORK.ONE:

Which result set would be generated?

Selecione uma das seguintes:

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

Explicação

Questão 16 de 103

16. Given the SAS data sets:

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?

Selecione uma das seguintes:

A. append corr
B. union corr
C. outer union corr
D. intersect corr

Explicação

Questão 17 de 103

17. Which of the following is an advantage of SAS views?

Selecione uma das seguintes:

A.
SAS views can access the most current
data in files that are frequently updated.
B.
SAS views can avoid storing a SAS copy of
a large data file.
C.
SAS views can decrease programming time.
D.
both A and B are true

Explicação

Questão 18 de 103

18. In what order does SAS search for format definitions by default?

Selecione uma das seguintes:

A. 1. WORK.FORMATS 2. LIBRARY.FORMATS
B. 1. LIBRARY.FORMATS 2. WORK.FORMATS
C. There is no default order, it must be defined by the user.
D. All user defined libraries that have a catalog named FORMATS, in alphabetic order.

Explicação

Questão 19 de 103

19. Function %UPCASE:

Which WHERE statement successfully completes the program and produces a report?

Selecione uma das seguintes:

A. where upcase(Name)=upcase(&Value);
B. where upcase(Name)=%upcase(&Value);
C. where upcase(Name)="upcase(&Value)";
D. where upcase(Name)="%upcase(&Value)";

Explicação

Questão 20 de 103

20. The following SAS program is submitted:
data WORK.TEMP;
length A B 3 X;
infile RAWDATA;
input A B X;
run;

What is the length of variable A?

Selecione uma das seguintes:

A. 3
B. 8
C. WORK.TEMP is not created - X has an invalid length.
D. Unknown.

Explicação

Questão 21 de 103

21. The following SAS program is submitted:

The purpose of the FILEVAR=option on the INFILE statement is to name the variable Next, whose value:

Selecione uma das seguintes:

A. points to a new input file.
B. is output to the SAS data set WORK.NEW.
C. is an input SAS data set reference.
D. points to an aggregate storage location.

Explicação

Questão 22 de 103

22. DESCRIBE TABLE Statement
Given the following partial SAS log:
NOTE: SQL table SASHELP.CLASS was created like:
create table SASHELP.CLASS( bufsize=4096 )
(
Name char(8),
Sex char(1),
Age num,
Height num,
Weight num
);

Which SQL procedure statement generated this output?

Selecione uma das seguintes:

A. CONTENTS FROM SASHELP.CLASS;
B. CREATE FROM SASHELP.CLASS INTO LOG;
C. DESCRIBE TABLE SASHELP.CLASS;
D. VALIDATE SELECT * FROM SASHELP.CLASS;

Explicação

Questão 23 de 103

23. Given the SAS data set SASUSER.HIGHWAY:

What macro variable reference completes the program to create the WORK.NOT and
WORK.SERIOUS data sets?

Selecione uma das seguintes:

A. &Status&i
B. &&Status&i
C. &Status&Count
D. &&Status&Count

Explicação

Questão 24 de 103

24. The following SAS program is submitted:
%let Num1=7;
%let Num2=3;
%let Result=%eval(&Num1/&Num2);
%put &Result;

What is the value of the macro variable Result when the %PUT statement executes?

Selecione uma das seguintes:

A. 2.3
B. 2
C. . (missing value)
D. 2.33333333333333

Explicação

Questão 25 de 103

25. Macros That Include Keyword Parameters:
Given the SAS data set SASUSER.HIGHWAY:

How many observations appear in the generated report?

Selecione uma das seguintes:

A. 0
B. 2
C. 3
D. 5

Explicação

Questão 26 de 103

26. Given the following SAS data sets:

Which of the following SQL statements was most likely used to generate this result?

Selecione uma das seguintes:

A.
select
Id,
sum(Expense) label='COST'
from WORK.VISIT1
group by 1
union all
select
Id,
sum(Cost)
from WORK.VISIT2
group by 1
order by 1,2
;
B. select
id,
sum(expense) as COST
from
WORK.VISIT1(rename=(Expense=Cost)),
WORK.VISIT2
where VISIT1.Id=VISIT2.Id
group by Id
order by
Id,
Cost ;
C. select
VISIT1.Id,
sum(Cost) as Cost
from
WORK.VISIT1(rename=(Expense=Cost)),
WORK.VISIT2
where VISIT1.Id=VISIT2.Id
group by Id
order by
Id,
Cost ;
D. select
Id,
sum(Expense) as Cost
from WORK.VISIT1
group by Id
outer union corr
select
Id,
sum(Cost)
from WORK.VISIT2
group by Id
order by 1,2
;

Explicação

Questão 27 de 103

27. Given the SAS data sets:

What data values are stored in data set WORK.COMBINE?

Selecione uma das seguintes:

Explicação

Questão 28 de 103

28. Which of the following ARRAY statements is similar to the statement array Yr{1974:2007} Yr1974-Yr2007; and will compile without errors?

Selecione uma das seguintes:

A. array Yr{34} Yr1974-Yr2007;
B. array Yr{74:07} Yr1974-Yr2007;
C. array Yr{74-07} Yr1974-Yr2007;
D. array Yr{1974-2007} Yr1974-Yr2007;

Explicação

Questão 29 de 103

29. The following program is submitted to check the variables Xa, Xb, and Xc in the SASUSER.LOOK data set:

data _null_ WORK.BAD_DATA / view=WORK.BAD_DATA ;
set SASUSER.LOOK(keep=Xa Xb Xc);
length _Check_ $ 10 ;
if Xa=. then _check_=trim(_Check_)!!" Xa" ;
if Xb=. then _check_=trim(_Check_)!!" Xb" ;
if Xc=. then _check_=trim(_Check_)!!" Xc" ;
put Xa= Xb= Xc= _check_= ;
run ;

When is the PUT statement executed?

Selecione uma das seguintes:

A. when the code is submitted
B. only when the WORK.BAD_DATA view is used
C. both when the code is submitted and the view is used
D. never, the use of _null_ in a view is a syntax error

Explicação

Questão 30 de 103

30. The following SAS program is submitted:
%let product=merchandise;
[_insert_%put_statement_]
and the following message is written to the SAS log: the value is "merchandise"

Selecione uma das seguintes:

A. %put the value is '"'&product.'"';
B. %put the value is %quote(&product.);
C. %put the value is "&product.";
D. %put the value is ""&product."";

Explicação

Questão 31 de 103

31. Given the SAS data sets:

What data values are stored in data set WORK.COMBINE?

Selecione uma das seguintes:

A. An ERROR message is written to the SAS log and the data set WORK.COMBINE is not created.
B.
SumY X Y
---- -- --
36 A 10
C.
SumY X Y
---- -- --
36 A 10
. A 3
. A 14
. B 9
D.
SumY X Y
---- -- --
36 A 10
36 A 3
36 A 14
36 B 9

Explicação

Questão 32 de 103

32. The following SAS program is submitted:
data WORK.NEW(bufno=4);
set WORK.OLD(bufno=3);
run;

Why are the BUFNO options used?

Selecione uma das seguintes:

A. to reduce memory usage
B. to reduce CPU time usage
C. to reduce the amount of data read
D. to reduce the number of I/O operations

Explicação

Questão 33 de 103

33. Given the following program and desired results:
%let Thing1=gift;
%let Thing2=surprise;
%let Gift1=book;
%let Gift2=jewelry;
%let Surprise1=dinner;
%let Surprise2=movie;

%let Pick=2;
%let Choice=surprise;

Desired %PUT Results in LOG:
My favorite surprise is a movie

What is the correct %PUT statement that generates the desired results?

Selecione uma das seguintes:

A. %put My favorite &Thing&Pick is a &&Choice&Pick;
B. %put My favorite &&Thing&pick is a &&&Choice&Pick;
C. %put My favorite &Choice&pick is a &&Thing&Pick;
D. %put My favorite &&Choice&pick is a &&&Thing&Pick;

Explicação

Questão 34 de 103

34. Given the SAS dataset WORK.ONE

Which SQL procedure clause completes the program and generates the desired output?

Selecione uma das seguintes:

A. select Salary Bonus as Salary*.10
B. select Salary Bonus=Salary*.10 'Bonus'
C. select Salary, Salary*.10 label='Bonus'
D. select Salary, Salary*.10 column="Bonus"

Explicação

Questão 35 de 103

35. The following SAS program is submitted:
options reuse=YES;
data SASUSER.REALESTATE(compress=CHAR);
set SASUSER.HOUSES;
run;

What is the effect of the reuse=YES SAS system option?

Selecione uma das seguintes:

A. It allows updates in place.
B. It tracks and recycles free space.
C. It allows a permanently stored SAS data set to be replaced.
D. It allows users to access the same SAS data set concurrently.

Explicação

Questão 36 de 103

36. Which statement is true for Data step HASH objects?

Selecione uma das seguintes:

A. The key component must be numeric.
B. The data component may consist of numeric and character values.
C. The HASH object is created in one step and referenced in another.
D. The HASH object must be smaller than 2 to the 8th power bytes.

Explicação

Questão 37 de 103

37. Given the SAS data sets:

Which SQL set operator completes the program and generates the desired output?

Selecione uma das seguintes:

A. intersect corr
B. except all
C. intersect all
D. left except

Explicação

Questão 38 de 103

38. The following SAS program is submitted:
%macro CHECK(Num=4);
%let Result=%eval(&Num gt 5);
%put Result is &result;
%mend;
%check(Num=10)

What is written to the SAS log?

Selecione uma das seguintes:

A. Result is 0
B. Result is 1
C. Result is 10 gt 5
D. Result is true

Explicação

Questão 39 de 103

39. The following SAS program is submitted:
%let Mv=shoes;
%macro PRODUCT(Mv=bicycles);
%let Mv=clothes;
%mend;

%PRODUCT(Mv=tents)
%put Mv is &Mv;

What is written to the SAS log?

Selecione uma das seguintes:

A. Mv is bicycles
B. Mv is clothes
C. Mv is shoes
D. Mv is tents

Explicação

Questão 40 de 103

40. Which of the following SAS System options can aid in benchmarking?

Selecione uma das seguintes:

A. BUFSIZE= and BUFNO=
B. FULLSTIMER
C. IOBLOCKSIZE=
D. SYSTIMER

Explicação

Questão 41 de 103

41. Given the following macro program:

Which option would provide feedback in the log about the parameter values passed into this macro when invoked?

Selecione uma das seguintes:

A. MPRINT
B. MDEBUG
C. MLOGIC
D. MPARAM

Explicação

Questão 42 de 103

42. The NOTSORTED option on the BY statement cannot be used with which other statement or option?

Selecione uma das seguintes:

A. SET
B. MERGE
C. IF FIRST.by-variable
D. BY GROUPFORMAT by-variable

Explicação

Questão 43 de 103

43. Given the SAS data set WORK.ONE:
Rep Cost
----- ----
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100

Which SQL clause completes the program and generates the desired output?

Selecione uma das seguintes:

A. where calculated Average > (select avg(Cost) from WORK.ONE)
B. having Average > (select avg(Cost) from WORK.ONE)
C. having avg(Cost) < (select avg(Cost) from WORK.ONE)
D. where avg(Cost) > (select avg(Cost) from WORK.ONE)

Explicação

Questão 44 de 103

44. Which dictionary table provides information on each occurrence of the variable named LastName?

Selecione uma das seguintes:

A. DICTIONARY.TABLES
B. DICTIONARY.COLUMNS
C. DICTIONARY.MEMBERS
D. DICTIONARY.VARIABLES

Explicação

Questão 45 de 103

45. To create a list of unique Customer_Id values from the customer data set, which of the following techniques can be used?

technique 1: proc SORT with NODUPKEY and OUT=
technique 2: data step with IF FIRST.Customer_Id=1
technique 3: proc SQL with the SELECT DISTINCT statement

Selecione uma das seguintes:

A. only technique 1
B. techniques 1 and 2
C. techniques 1 and 3
D. techniques 1, 2, or 3

Explicação

Questão 46 de 103

46. Given the SAS data sets:

Which SQL set operator completes the program and generates the desired output?

Selecione uma das seguintes:

A. intersect corr
B. except
C. intersect
D. left except

Explicação

Questão 47 de 103

47. The following SAS program is submitted:

Which statement completes the program so that the PROC PRINT step executes on Thursday?

Selecione uma das seguintes:

A. if &sysday = Thursday then %do;
B. %if &sysday = Thursday %then %do;
C. %if "&sysday" = Thursday %then %do;
D. %if &sysday = "Thursday" %then %do;

Explicação

Questão 48 de 103

48. Given the following program and data:

What is the WHERE statement that successfully completes the PROC PRINT and selects the observation for Barb?

Selecione uma das seguintes:

A. where Birthday=&Want;
B. where Birthday="&Want";
C. where Birthday="&Want"d;
D. where Birthday='&Want'd;

Explicação

Questão 49 de 103

49. Which macro statement would remove the macro variable Mv_Info from the symbol table?

Selecione uma das seguintes:

A. %mdelete &Mv_Info;
B. %symerase Mv_Info;
C. %symdel &Mv_Info;
D. %symdel Mv_Info;

Explicação

Questão 50 de 103

50. The table WORK.PILOTS contains the following data:

Which select statement could NOT have produced this output?

Selecione uma das seguintes:

Explicação

Questão 51 de 103

51. The SAS data set WORK.TEMP is indexed on the variable Id:

Which BY statement completes the program, creates a listing report that is grouped by Id, and completes without errors?

Selecione uma das seguintes:

A. by Id;
B. by Id grouped;
C. by Id descending;
D. by descending Id;

Explicação

Questão 52 de 103

52. To create a dataset with unique values of a given variable using a data step and the FIRST. VARIABLES and LAST.VARIABLES, it is assumed that the input dataset is:

Selecione uma das seguintes:

A. sorted on that variable.
B. indexed by that variable.
C. naturally in order.
D. any of the above A, B, or C

Explicação

Questão 53 de 103

53.The SASFILE statement requests that a SAS data set be opened and loaded into memory:

Selecione uma das seguintes:

A. one page at a time.
B. one variable at a time.
C. one observation at a time.
D. in its entirety, if possible.

Explicação

Questão 54 de 103

54. The following SAS program is submitted:

%let Name1=Shoes;
%let Name2=Clothes;
%let Root=name;
%let Suffix=2;
%put &&&Root&Suffix;

What is written to the SAS log?

Selecione uma das seguintes:

A. &Name2
B. Clothes
C. &&&Root&Suffix
D. WARNING: Apparent symbolic reference ROOT2 not resolved.

Explicação

Questão 55 de 103

55. Given the SAS data sets:

Which join operator completes the program
and generates the desired output?

Selecione uma das seguintes:

A. left join
B. right join
C. full join
D. outer join

Explicação

Questão 56 de 103

56. The SAS data set WORK.ADDRESSES contains the email addresses of The XYZ Corporation's customers in a variable named Email_Address. The following DATA step is submitted:

Which statement completes the program and creates a SAS program file?

Selecione uma das seguintes:

A. infile "c:\email.sas";
B. output "c:\email.sas";
C. file "c:\email.sas";
D. None of the above.

Explicação

Questão 57 de 103

57. Which of the following is true about the COMPRESS=YES data set option?

Selecione uma das seguintes:

A. It uses the Ross Data Compression method to compress numeric data.
B. It is most effective with character data that contains repeated characters.
C. It is most effective with numeric data that represents large numeric values.
D. It is most effective with character data that contains patterns, rather than simple repetitions.

Explicação

Questão 58 de 103

Given the SAS dataset WORK.ONE:

Salary
------
200
205
.
523

Which WHERE expression completes the program and generates the desired output?

Selecione uma das seguintes:

A. where Salary is not .
B. where Salary ne missing
C. where Salary ne null
D. where Salary is not missing

Explicação

Questão 59 de 103

59. The SAS data set WORK.TEST has an index on the variable Id and the following SAS
program is submitted.

Selecione uma das seguintes:

A. The index on Id is deleted.
B. The index on Id is updated as an index on Id_Code.
C. The index on Id is deleted and an index on Id_Code is created.
D. The index on Id is recreated as an index on Id_Code.

Explicação

Questão 60 de 103

Given the data set SASHELP.CLASS:

Which PROC steps execute successfully?

Selecione uma das seguintes:

A. PROC MEANS only
B. PROC PRINT only
C. PROC MEANS and PROC PRINT
D. No PROC steps execute successfully

Explicação

Questão 61 de 103

61. In a data step merge, the BY variables in all data sets must have the same:

Selecione uma das seguintes:

A. name.
B. name and type.
C. name and length.
D. name, type, and length.

Explicação

Questão 62 de 103

62. Given the following macro program and invocation:

Which of these choices shows the correct %PUT statement output if the program is submitted at the beginning of a new SAS session? Note that other lines may be written to the SAS log by the program, but only the %PUT output is shown here.

Selecione uma das seguintes:

A. ---> inside macro WORK.NEW SASHELP.CLASS
---> outside invocation WORK.NEW SASHELP.CLASS
B. ---> inside macro WORK.NEW SASHELP.CLASS
---> outside invocation &NEWNAME &SETNAME
C. ---> inside macro &NEWNAME &SETNAME
---> outside invocation WORK.NEW SASHELP.CLASS
D. ---> inside macro &NEWNAME &SETNAME
---> outside invocation &NEWNAME &SETNAME

Explicação

Questão 63 de 103

63. The following SAS program is submitted:

Which VAR statement successfully completes the program to produce a report containing four variables?

Selecione uma das seguintes:

A. var %COLS1 %COLS2;
B. var %COLS1-%COLS2;
C. var %COLS1 Weight Height;
D. var Weight Height %COLS1;

Explicação

Questão 64 de 103

Preencha o espaço em branco para completar o texto.

如何在 Log 中輸出 global macro variables

%put

Explicação

Questão 65 de 103

Preencha o espaço em branco para completar o texto.

選出 unique value of a grouped variable

If =1 then output=xxx

(model 是這個 variable 的名字)

Explicação

Questão 66 de 103

Preencha o espaço em branco para completar o texto.

outer union

Explicação

Questão 67 de 103

Preencha o espaço em branco para completar o texto.

A Data has 2000million observations and 300 Character variables

Compress=

Explicação

Questão 68 de 103

Preencha o espaço em branco para completar o texto.

Data Set
ONE
State_ID state
TWO
State_ID City

Quit 前的最後一句:

Ask: where s.state=

(注意一定要加引號)

Explicação

Questão 69 de 103

Preencha o espaço em branco para completar o texto.

HASH object

Explicação

Questão 70 de 103

Preencha o espaço em branco para completar o texto.

Given 2 Data Set
ONE
Name Year
Joyce 9
John 4
John 2
Jane 6
Thomas 8

TWO
Name Age(不需要理會)
Joyce
John
Thomas
Robert
Jeff

The following SAS program is submitted:
select Name, avg(Year) as average
from WORK.ONE
Except Corr
WORK.TWO
.............. quit;

Average of

Explicação

Questão 71 de 103

Preencha o espaço em branco para completar o texto.

FCMP 填空
proc fcmp outlib=sasuser.funcs.trial;
...
endsub;
options =sasuser.funcs; data null;
...
run;

Explicação

Questão 72 de 103

Given data set and macro program, choose missing correct code
call symputx('&Num', California)

Selecione uma das opções:

VERDADEIRO
FALSO

Explicação

Questão 73 de 103

Preencha o espaço em branco para completar o texto.

the first part of code gives Key:valuepair definition, the variables are somekey and someAlpha, we need to fill in the hash object definition.

Some.definedata( );

Explicação

Questão 74 de 103

Preencha o espaço em branco para completar o texto.

declare has Goal();
Goal.definekey(“QtrNum”);
Goal.definedata();
Goal.definedone();

Explicação

Questão 75 de 103

repeated need a local data set, what kind of effect does SASFILE statement has to the Global statement.

Selecione uma ou mais das seguintes:

reduce CPU
reduce I/O
increase memory

Explicação

Questão 76 de 103

考察in line view。程序大致如下: proc sql;
create table forecast as
select a.*, b.sales
from actual a,_______ where a.dept=b.dept
quit;

Selecione uma ou mais das seguintes:

(select
avg(revenue) as average
from Budegt
group by 1) b
select (
avg(revenue) as average from Budegt
group by 1) b

Explicação

Questão 77 de 103

%let this_year=%substr(&sysdate9,6);
%let next_year=&this_year+1;
%let check_year=%eval(&next_year<2016);
%put two years after this year is &next_year+1;
%put &check_year is &check_year;

Assume system time is 01Jan2013, what is the output?

Selecione uma ou mais das seguintes:

two years after this year is 2013+1+1
check_year is 1

Explicação

Questão 78 de 103

A data set has 300,000 observations, 20 character variables, 50 numeric variables, 我们需要其中的 5 character variables 和 7 numeric variables，which is most efficient:

Selecione uma das seguintes:

A. DROP= option in data step
B. KEEP= option in data step
C. KEEP= option in set statement
D. KEEP statement

Explicação

Questão 79 de 103

Array multi{1:2,2} (1,2);
Do i=1 to 2;
Do j=1 to 2;
Output =multi{i.j};
问 i，j 和对应 output 的值，答案:

Selecione uma ou mais das seguintes:

i j output
111
122
21 .
22 .
i j output
111
122
21. 22.

Explicação

Questão 80 de 103

给定一个 data set 和 SQL 代码，问输出结果一致的是: 具体不记得了，摘一段类似的，考点在 nodupkey，注意要 drop 掉一个 variable
proc sort data=retail.order_fact
out=work.sorted (drop=XXX) nodupkey;
by order_date;
run;

需要选有nodupkey， drop掉一个variable,而且by variable 不能有descending的, 因为SQL中的order by 默认是ascending的

Selecione uma das opções:

VERDADEIRO
FALSO

Explicação

Questão 81 de 103

data company.newdata / view=company.newdata;
infile <fileref>;
<DATA step statements>
run;
以上代码 create a data step view 之后，要在 proc means 中使用 view，问应该用哪个代码:

Submit the above code and create a data step view, then we need to use this view in the PROC MEANS procedure, which one to use:

Selecione uma das seguintes:

A. proc means view= company.newdata;
B. proc means data=company.newdata / view=company.newdata;
C. proc means data company.newdata / view
D. proc means data=company.newdata

Explicação

Questão 82 de 103

Pagesize info
Which of proc can check the pagesize info?

Selecione uma das seguintes:

A Proc Contents
B Proc print
C Proc report
D Proc catalog

Explicação

Questão 83 de 103

Given two format with the same name $Gender, one store in Mylib, and the other in library. Proc print data=... ; run;
Using the format $Gender. From the desired output, we can tell that the format in Mylib is used. Options fmtsearch=______________; Which statement should be filled in here?

Selecione uma das seguintes:

A. no fmsearch needed
B. fmsearch=(mylib, library)
C. fmsearch=(library, mylib)
D. fmsearch=(mylib)

Explicação

Questão 84 de 103

Horizontal join set operator (i) right join
Two data sets
Work.One
year sales
2001 800
2001 500
2003 700

Work.Two
year profit
2001 100
2002 200

proc sql;
select sum(profit)
from one right join two
on one.year=two.year;
quit;
What is the output?

Selecione uma das seguintes:

A. 100
B. 300
C. 400
D. 500

Explicação

Questão 85 de 103

IDXNAME=... (instruct SAS to use a specific index for where processing)
IDXWHERE

sas里如何指定使用某一个index,用inxname
选inxname

Selecione uma das opções:

VERDADEIRO
FALSO

Explicação

Questão 86 de 103

It is about except operator, given two data sets,
Ask about the output. Choose the answer with one

Selecione uma ou mais das seguintes:

Answer: Charlie Omar
Answer:
Charlie
Omar

Explicação

Questão 87 de 103

Given two data sets and SQL code, ask for the output.

Selecione uma ou mais das seguintes:

Choose the answer with Thomas, Jones, Smith, but no Adam.
Besides, there is a descreasing option in the code, so the Sales need to be in decreasing order.

Explicação

Questão 88 de 103

哪个个 view 的命名 code 正确?

Selecione uma ou mais das seguintes:

data xxx/ view=xxx
(view 和 data set 的命名必须一样)

Explicação

Questão 89 de 103

Efficiency of If-then/Else and Where clauses
A compressed data set has 200,000 observations, 300 variables. We need 20% of character observations, What method can minimize computer resource usage?

Selecione uma das seguintes:

A. If-then/Else clause
B. Case
C. Where
D. ...

Explicação

Questão 90 de 103

Macro variable with macro trigger signs.
Output title “RECENT A&M ACTIVITY”, which macro definition should be used.

Selecione uma das seguintes:

A. title %sysfundc(“RECENT A&M ACTIVITY”)
B. title %str(“RECENT A&M ACTIVITY”);
C. title %nrstr(“RECENT A&M ACTIVITY”);
D. title %bquote(“RECENT A&M ACTIVITY);

Explicação

Questão 91 de 103

Effect on SASFILE for repeating a local data set
Repeated need a local data set, what kind of effect does SASFILE statement has to the Global statement.

Selecione uma das seguintes:

A increase Network Bandwidth
B CPU increase
C I/O increase
D memory increase

Explicação

Questão 92 de 103

left join and in-line view

Product
Product_id Product
1 1001
2 1002
3 1003

Sales
Product_id Sales
3 100
1 200
5 100
1 200
3 100
1 100

Proc sql;
Select p.product s.totalsales
From product as p
left join (
select sum(sales) as totalsales
from sales as s)
on p.product_id=s.product_id;
quit;

What is the output?

Selecione uma ou mais das seguintes:

Product Totalsales
1001 500
1002 .
1003 200
Product Totalsales

1001 500
1002 .
1003 200

Explicação

Questão 93 de 103

Work.temp is indexed

Selecione uma das seguintes:

A Stops to executes as this is not in ascending order
B Stops to executes as this is not in descending order
C continue to executes without problem
D continue to executes but index=USE

Explicação

Questão 94 de 103

in-line view
给了一段 code 明确告知 in-line view 中给定的 condition 有
multiply observations satisfied the condition，问 program 运行结果。

Selecione uma ou mais das seguintes:

答案是运行出错没有结果
因为 in-line view return multiple results

Explicação

Questão 95 de 103

in-line view
给了一段 code 明确告知运行出错没有结果，问原因
given a failed program, ask the reason of failure.
Proc sql;
select Jobcode, Salary,
(select avg(Salary)
from WORK.PILOTS
order by Jobcode) as Avg
from WORK.PILOTS
order by ID;
quit;

Selecione uma ou mais das seguintes:

Order By statement cannot be used inside of an in-line view.
There is another choice says that if using in-line view then we cannot use Order By statement. This is not true. The ORDER BY ID statement in the outside query is OK.

Explicação

Questão 96 de 103

用 sql 生成多个宏变量
Proc sql...;
select column1, column2
<insert code>;

Selecione uma das seguintes:

into: c1varibale1-: c1varibale3
: c2varibale1-: c2varibale3
into: c1varibale1- c1varibale3
: c2varibale1- c2varibale3
into: c1varibale1: c1varibale2: c1varibale3
: c2varibale1: c2varibale2: c2varibale3
into : type1 -:type3 , :sale1- :sale3
INTO: shoesales1-: shoesales3, shoetype1-:shoetype3

Explicação

Questão 97 de 103

展示数据库中两个数据集的名字、储存的行数和被删除的行数

问怎么在一个 library 里挑出删除了 5%以上 observation 的 dataset
选项太长了不记得具体的了，是考 dictionary table 的

Selecione uma das seguintes:

select menname, nobs, delobs from dictionary.tables
select menname, nlobs, delobs from dictionary.tables
select menname, nobs, delobs from dictionary.members

Explicação

Questão 98 de 103

multiple datasets 想用 set 和 key 合并的时候，应该应用在什么样的 dataset 上 (chapter 15)

mergedataset时，什么时候用multipleSETstatement最有效率

Selecione uma das seguintes:

A: dataset 都是 large，两个里面都有 index。
B: larger dataset，一个 smaller dataset，index in larger dataset
C: larger dataset，一个 smaller dataset，index in smaller dataset

Explicação

Questão 99 de 103

考点: create index 时 unique 是已经确认的，不能被更改

Selecione uma das seguintes:

create index 时 unique 是已经确认的
不能被更改

Explicação

Questão 100 de 103

引用 index 时，哪个效率高(题干和选项都没记清，仅提供考点)
在 index 很复杂的情况下，在 where statement 中选择怎样 index 最有效?

Selecione uma das seguintes:

index include more rows
index unqualified more rows
index that disqualify most variables
simple index
composite index

Explicação

Questão 101 de 103

给了data set 和desired output，要求选code。发现是要生成unique value of key variable.

Selecione uma das seguintes:

只有proc sort nodupkey; by var 的选项对
有干扰选项proc sort nodup; by var;

Explicação

Questão 102 de 103

什么样 characteristic 的 index can only be set up with DATASET procedure.

Selecione uma das seguintes:

A: 关于 index centiles 的，好像是 index centiles can be updated.
D:index 可以包括 missing value
A. multiple variables;
B. unique key

Explicação

Questão 103 de 103

要选出 inactive_date 为 missing 时候的 observation。题目是 prol sql;
Select *
From dataset1 A
Full join dataset2 B
On A.ID = B.ID
Where inactive_date is missing;

问 data dataset3;
merge dataset1 (In=Ina)
dataset2 (In=Inb);
By ID;
<insert statement>;

Selecione uma das seguintes:

A: where inactive_date is missing and (Ina and Inb)
B: where inactive_date is missing and (Ina or Inb)
C:想不起来了好像是 if inactive_date is missing and (ina and inb)
D: If inactive_date ne .

Explicação

Verificar resposta

["https://cdn.goconqr.com/uploads/media/image/17291588/desktop_08cdf852-fbb5-465e-ba76-2e7066936b46.png","https://cdn.goconqr.com/uploads/media/image/17291624/desktop_4e14bbfe-9e67-47ab-811a-872adc314005.png","https://cdn.goconqr.com/uploads/media/image/17291668/desktop_bef58bf7-c38f-400d-b49e-090d50bc8c2b.png","https://cdn.goconqr.com/uploads/media/image/17292028/desktop_eaf575b7-db9f-4196-ba85-1763d8f75fd9.png","https://cdn.goconqr.com/uploads/media/image/17310208/desktop_3c9f22cf-74a5-40e7-b331-23a78d1e239f.png","https://cdn.goconqr.com/uploads/media/image/17310697/desktop_ab9bd8d3-aafc-4951-8c84-dc821440a2f9.png","https://cdn.goconqr.com/uploads/media/image/17310743/desktop_48df73a3-16cd-4476-97f1-85674531efb4.png","https://cdn.goconqr.com/uploads/media/image/17310963/desktop_eb0aa168-8374-427b-93b0-c25d3abdde0e.png","https://cdn.goconqr.com/uploads/media/image/17311298/desktop_89833321-e21e-469c-9d3c-fac88a1db066.png","https://cdn.goconqr.com/uploads/media/image/17314071/desktop_7ad299fd-023f-4cc6-bc7a-7a4352b78a98.png","https://cdn.goconqr.com/uploads/media/image/17314908/desktop_e114f783-e363-42f0-bf3a-3590f2e2b2ed.png","https://cdn.goconqr.com/uploads/media/image/17314977/desktop_c8bfe270-63d1-42d7-9fcd-581b0de3e7f9.png","https://cdn.goconqr.com/uploads/media/image/17315163/desktop_313c2aaf-2efc-45ed-a0f4-f4a8be1e3202.png","https://cdn.goconqr.com/uploads/media/image/17315634/desktop_17ce113f-4b9c-4dd9-bac0-f850980481d5.png","https://cdn.goconqr.com/uploads/media/image/17315840/desktop_08cb6bba-5b9a-4926-abd9-066ad06a6f37.png","https://cdn.goconqr.com/uploads/media/image/17315923/desktop_5dc0232c-4f26-435b-a404-eca20d128c91.png","https://cdn.goconqr.com/uploads/media/image/17316283/desktop_487da0e8-a2df-4f71-a71a-03a175c4da9c.png","https://cdn.goconqr.com/uploads/media/image/17318820/desktop_98d4d8b6-248c-4fde-9a96-206e284998e0.png","https://cdn.goconqr.com/uploads/media/image/17319179/desktop_af964a11-3c57-4bd2-a417-c2b7cf11d422.png","https://cdn.goconqr.com/uploads/media/image/17326574/desktop_a7ec23a0-d8dd-499e-9441-77ff1d98c869.png","https://cdn.goconqr.com/uploads/media/image/17327486/desktop_e23ebe47-1b3e-497d-8a1d-8af848b7d7fe.png","https://cdn.goconqr.com/uploads/media/image/17327576/desktop_5aa63fde-5b4b-4668-86c5-1640e8f59075.png","https://cdn.goconqr.com/uploads/media/image/17327932/desktop_59d8c054-ee97-4056-904a-faf15026c705.png","https://cdn.goconqr.com/uploads/media/image/17327966/desktop_16e5b3bc-ee99-4003-bedd-69d587a5eeea.png","https://cdn.goconqr.com/uploads/media/image/17328018/desktop_c8183ff7-4221-429c-8f61-6dd7108d4c26.png","https://cdn.goconqr.com/uploads/media/image/17328034/desktop_7896b4bf-7629-4468-b75a-d8bc96ac553c.png","https://cdn.goconqr.com/uploads/media/image/17328074/desktop_7398304f-716b-4859-b28c-e0a6c11c0b23.png","https://cdn.goconqr.com/uploads/media/image/17328116/desktop_94ce8a92-5579-4772-81eb-476d2c500ed7.png","https://cdn.goconqr.com/uploads/media/image/17328164/desktop_a10467a1-a18e-4535-99fc-f54817cdb7d4.png","https://cdn.goconqr.com/uploads/media/image/17375482/desktop_a9d0ac51-5ee7-42cb-8db5-da7e0ec1182c.png","https://cdn.goconqr.com/uploads/media/image/17370727/desktop_d26b82b4-2a3a-4ca8-af6d-36ac5d6846eb.png","https://cdn.goconqr.com/uploads/media/image/17315178/desktop_ebf7facb-423d-420d-a411-bbe75d8ffac1.png","https://cdn.goconqr.com/uploads/media/image/17315205/desktop_ef318da9-bf90-428e-ba3a-4827d226613c.png","https://cdn.goconqr.com/uploads/media/image/17315212/desktop_f74edbb5-ce9c-42ca-b18c-69c83e18b0d0.png","https://cdn.goconqr.com/uploads/media/image/17315216/desktop_4b6aa76a-f5a7-45d3-ac16-ab3fa3a3366b.png","https://cdn.goconqr.com/uploads/media/image/17327578/desktop_079fc316-c7e2-421e-8ae6-00447d5f433d.png","https://cdn.goconqr.com/uploads/media/image/17327582/desktop_50f6af37-988c-4316-b993-11d13e09a18a.png","https://cdn.goconqr.com/uploads/media/image/17327635/desktop_1b178395-544f-4c55-b2f4-e9f9fe820d1d.png","https://cdn.goconqr.com/uploads/media/image/17327638/desktop_68c938c1-c443-4dc2-8b78-a8aaa34f1145.png"]

	Criado por Grace Li quase 6 anos atrás

Quiz sobre SAS advance 63, criado por Grace Li em 26-09-2018.

SAS advance 63

SAS advance 63

Questão 1 de 103

1. When attempting to minimize memory usage, the most efficient way to do group processing when using the MEANS procedure is to use:

Selecione uma das seguintes:

Explicação

Questão 2 de 103

2. The SAS data set WORK.CHECK has a variable named Id_Code in it. Which SQL statement would create an index on this variable?

Selecione uma das seguintes:

Explicação

Questão 3 de 103

3. Given the SAS data sets: What would allow the program to successfully execute without errors?

Selecione uma das seguintes:

Explicação

Questão 4 de 103

4. Given the SAS data set SASUSER.HIGHWAY: Which SQL clause stores the text 0-29, 30-49, 50+ in the macro variable GROUPS?

Selecione uma das seguintes:

Explicação

Questão 5 de 103

5. The SAS data set WORK.CHECK has an index on the variable Code and the following SAS program is submitted. proc sort data=WORK.CHECK; by Code; run; Which describes the result of submitting the SAS program?

Selecione uma das seguintes:

Explicação

Questão 6 de 103

6. The table WORK.PILOTS contains the following data: Which SQL statement could NOT generate this result?

Selecione uma das seguintes:

Explicação

Questão 7 de 103

7. A quick rule of thumb for the space required to run PROC SORT is:

Selecione uma das seguintes:

Explicação

Questão 8 de 103

8. Multi-threaded processing for PROC SORT will affect which of these system resources?

Selecione uma das seguintes:

Explicação

Questão 9 de 103

9. Given the SAS data set WORK.TRANSACT: Which SQL statement was used?

Selecione uma das seguintes:

Explicação

Questão 10 de 103

10. (%EVAL) The following SAS program is submitted: %let Value=9; %let Add=5; %let Newval=%eval(&Value/&Add); %put &Newval; What is the value of the macro variable Newval when the %PUT statement executes?

Selecione uma das seguintes:

Explicação

Questão 11 de 103

11. The following SAS code is submitted: data WORK.TEMP WORK.ERRORS / view=WORK.TEMP; infile RAWDATA; input Xa Xb Xc; if Xa=. then output WORK.ERRORS; else output WORK.TEMP; run; Which of the following is true of the WORK.ERRORS data set?

Selecione uma das seguintes:

Explicação

Questão 12 de 103

12. Which title statement would always display the current date?

Selecione uma das seguintes:

Explicação

Questão 13 de 103

13. Given the SAS data sets: Which SQL procedure statement produces the same results?

Selecione uma das seguintes:

Explicação

Questão 14 de 103

14. 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?

Selecione uma das seguintes:

Explicação

Questão 15 de 103

15. Given the SAS data set WORK.ONE: Which result set would be generated?

Selecione uma das seguintes:

Explicação

Questão 16 de 103

16. Given the SAS data sets: 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?

Selecione uma das seguintes:

Explicação

Questão 17 de 103

17. Which of the following is an advantage of SAS views?

Selecione uma das seguintes:

Explicação

Questão 18 de 103

18. In what order does SAS search for format definitions by default?

Selecione uma das seguintes:

Explicação

Questão 19 de 103

19. Function %UPCASE: Which WHERE statement successfully completes the program and produces a report?

Selecione uma das seguintes:

Explicação

Questão 20 de 103

3. Given the SAS data sets:

What would allow the program to successfully execute without errors?

4. Given the SAS data set SASUSER.HIGHWAY:

Which SQL clause stores the text 0-29, 30-49, 50+ in the macro variable GROUPS?

5. The SAS data set WORK.CHECK has an index on the variable Code and the following SAS program is submitted.
proc sort data=WORK.CHECK;
by Code;
run;

Which describes the result of submitting the SAS program?

6. The table WORK.PILOTS contains the following data:

Which SQL statement could NOT generate this result?

9. Given the SAS data set WORK.TRANSACT:

Which SQL statement was used?

10. (%EVAL) The following SAS program is submitted:
%let Value=9;
%let Add=5;
%let Newval=%eval(&Value/&Add); %put &Newval;

What is the value of the macro variable Newval when the %PUT statement executes?

11. The following SAS code is submitted:
data WORK.TEMP WORK.ERRORS / view=WORK.TEMP;
infile RAWDATA;
input Xa Xb Xc;
if Xa=. then output WORK.ERRORS;
else output WORK.TEMP;
run;

Which of the following is true of the WORK.ERRORS data set?

13. Given the SAS data sets:

Which SQL procedure statement produces the same results?

14. 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?

15. Given the SAS data set WORK.ONE:

Which result set would be generated?

16. Given the SAS data sets:

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?

19. Function %UPCASE:

Which WHERE statement successfully completes the program and produces a report?

20. The following SAS program is submitted:
data WORK.TEMP;
length A B 3 X;
infile RAWDATA;
input A B X;
run;

What is the length of variable A?

21. The following SAS program is submitted:

The purpose of the FILEVAR=option on the INFILE statement is to name the variable Next, whose value:

22. DESCRIBE TABLE Statement
Given the following partial SAS log:
NOTE: SQL table SASHELP.CLASS was created like:
create table SASHELP.CLASS( bufsize=4096 )
(
Name char(8),
Sex char(1),
Age num,
Height num,
Weight num
);

Which SQL procedure statement generated this output?

23. Given the SAS data set SASUSER.HIGHWAY:

What macro variable reference completes the program to create the WORK.NOT and
WORK.SERIOUS data sets?

24. The following SAS program is submitted:
%let Num1=7;
%let Num2=3;
%let Result=%eval(&Num1/&Num2);
%put &Result;

What is the value of the macro variable Result when the %PUT statement executes?

25. Macros That Include Keyword Parameters:
Given the SAS data set SASUSER.HIGHWAY:

How many observations appear in the generated report?

26. Given the following SAS data sets:

Which of the following SQL statements was most likely used to generate this result?

27. Given the SAS data sets:

What data values are stored in data set WORK.COMBINE?

30. The following SAS program is submitted:
%let product=merchandise;
[_insert_%put_statement_]
and the following message is written to the SAS log: the value is "merchandise"

31. Given the SAS data sets:

What data values are stored in data set WORK.COMBINE?

32. The following SAS program is submitted:
data WORK.NEW(bufno=4);
set WORK.OLD(bufno=3);
run;

Why are the BUFNO options used?

34. Given the SAS dataset WORK.ONE

Which SQL procedure clause completes the program and generates the desired output?

35. The following SAS program is submitted:
options reuse=YES;
data SASUSER.REALESTATE(compress=CHAR);
set SASUSER.HOUSES;
run;

What is the effect of the reuse=YES SAS system option?

37. Given the SAS data sets:

Which SQL set operator completes the program and generates the desired output?