SAS advance 63

Bitte warte - es wird geladen…

Frage 1 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 2 von 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?

Wähle eine der folgenden:

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;

Erklärung

Frage 3 von 103

3. Given the SAS data sets:

What would allow the program to successfully execute without errors?

Wähle eine der folgenden:

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.

Erklärung

Frage 4 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 5 von 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?

Wähle eine der folgenden:

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.

Erklärung

Frage 6 von 103

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

Which SQL statement could NOT generate this result?

Wähle eine der folgenden:

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.)

Erklärung

Frage 7 von 103

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

Wähle eine der folgenden:

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.

Erklärung

Frage 8 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 9 von 103

9. Given the SAS data set WORK.TRANSACT:

Which SQL statement was used?

Wähle eine der folgenden:

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
;

Erklärung

Frage 10 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 11 von 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?

Wähle eine der folgenden:

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.

Erklärung

Frage 12 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 13 von 103

13. Given the SAS data sets:

Which SQL procedure statement produces the same results?

Wähle eine der folgenden:

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
;

Erklärung

Frage 14 von 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?

Wähle eine der folgenden:

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;

Erklärung

Frage 15 von 103

15. Given the SAS data set WORK.ONE:

Which result set would be generated?

Wähle eine der folgenden:

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

Erklärung

Frage 16 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 17 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 18 von 103

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

Wähle eine der folgenden:

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.

Erklärung

Frage 19 von 103

19. Function %UPCASE:

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

Wähle eine der folgenden:

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

Erklärung

Frage 20 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 21 von 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:

Wähle eine der folgenden:

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.

Erklärung

Frage 22 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 23 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 24 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 25 von 103

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

How many observations appear in the generated report?

Wähle eine der folgenden:

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

Erklärung

Frage 26 von 103

26. Given the following SAS data sets:

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

Wähle eine der folgenden:

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
;

Erklärung

Frage 27 von 103

27. Given the SAS data sets:

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

Wähle eine der folgenden:

Erklärung

Frage 28 von 103

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

Wähle eine der folgenden:

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;

Erklärung

Frage 29 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 30 von 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"

Wähle eine der folgenden:

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."";

Erklärung

Frage 31 von 103

31. Given the SAS data sets:

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

Wähle eine der folgenden:

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

Erklärung

Frage 32 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 33 von 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?

Wähle eine der folgenden:

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;

Erklärung

Frage 34 von 103

34. Given the SAS dataset WORK.ONE

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

Wähle eine der folgenden:

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"

Erklärung

Frage 35 von 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?

Wähle eine der folgenden:

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.

Erklärung

Frage 36 von 103

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

Wähle eine der folgenden:

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.

Erklärung

Frage 37 von 103

37. Given the SAS data sets:

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

Wähle eine der folgenden:

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

Erklärung

Frage 38 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 39 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 40 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 41 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 42 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 43 von 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?

Wähle eine der folgenden:

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)

Erklärung

Frage 44 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 45 von 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

Wähle eine der folgenden:

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

Erklärung

Frage 46 von 103

46. Given the SAS data sets:

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

Wähle eine der folgenden:

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

Erklärung

Frage 47 von 103

47. The following SAS program is submitted:

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

Wähle eine der folgenden:

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

Erklärung

Frage 48 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 49 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 50 von 103

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

Which select statement could NOT have produced this output?

Wähle eine der folgenden:

Erklärung

Frage 51 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 52 von 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:

Wähle eine der folgenden:

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

Erklärung

Frage 53 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 54 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 55 von 103

55. Given the SAS data sets:

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

Wähle eine der folgenden:

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

Erklärung

Frage 56 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 57 von 103

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

Wähle eine der folgenden:

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.

Erklärung

Frage 58 von 103

Given the SAS dataset WORK.ONE:

Salary
------
200
205
.
523

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

Wähle eine der folgenden:

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

Erklärung

Frage 59 von 103

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

Wähle eine der folgenden:

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.

Erklärung

Frage 60 von 103

Given the data set SASHELP.CLASS:

Which PROC steps execute successfully?

Wähle eine der folgenden:

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

Erklärung

Frage 61 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 62 von 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.

Wähle eine der folgenden:

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

Erklärung

Frage 63 von 103

63. The following SAS program is submitted:

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

Wähle eine der folgenden:

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

Erklärung

Frage 64 von 103

Fülle die Lücke, um den Text zu vervollständigen

如何在 Log 中輸出 global macro variables

%put

Erklärung

Frage 65 von 103

Fülle die Lücke, um den Text zu vervollständigen

選出 unique value of a grouped variable

If =1 then output=xxx

(model 是這個 variable 的名字)

Erklärung

Frage 66 von 103

Fülle die Lücke, um den Text zu vervollständigen

outer union

Erklärung

Frage 67 von 103

Fülle die Lücke, um den Text zu vervollständigen

A Data has 2000million observations and 300 Character variables

Compress=

Erklärung

Frage 68 von 103

Fülle die Lücke, um den Text zu vervollständigen

Data Set
ONE
State_ID state
TWO
State_ID City

Quit 前的最後一句:

Ask: where s.state=

(注意一定要加引號)

Erklärung

Frage 69 von 103

Fülle die Lücke, um den Text zu vervollständigen

HASH object

Erklärung

Frage 70 von 103

Fülle die Lücke, um den Text zu vervollständigen

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

Erklärung

Frage 71 von 103

Fülle die Lücke, um den Text zu vervollständigen

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

Erklärung

Frage 72 von 103

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

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 73 von 103

Fülle die Lücke, um den Text zu vervollständigen

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( );

Erklärung

Frage 74 von 103

Fülle die Lücke, um den Text zu vervollständigen

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

Erklärung

Frage 75 von 103

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

Wähle eine oder mehr der folgenden:

reduce CPU
reduce I/O
increase memory

Erklärung

Frage 76 von 103

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

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 77 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 78 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 79 von 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 的值，答案:

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 80 von 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的

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 81 von 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:

Wähle eine der folgenden:

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

Erklärung

Frage 82 von 103

Pagesize info
Which of proc can check the pagesize info?

Wähle eine der folgenden:

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

Erklärung

Frage 83 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 84 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 85 von 103

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

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

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 86 von 103

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

Wähle eine oder mehr der folgenden:

Answer: Charlie Omar
Answer:
Charlie
Omar

Erklärung

Frage 87 von 103

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

Wähle eine oder mehr der folgenden:

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.

Erklärung

Frage 88 von 103

哪个个 view 的命名 code 正确?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 89 von 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?

Wähle eine der folgenden:

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

Erklärung

Frage 90 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 91 von 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.

Wähle eine der folgenden:

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

Erklärung

Frage 92 von 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?

Wähle eine oder mehr der folgenden:

Product Totalsales
1001 500
1002 .
1003 200
Product Totalsales

1001 500
1002 .
1003 200

Erklärung

Frage 93 von 103

Work.temp is indexed

Wähle eine der folgenden:

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

Erklärung

Frage 94 von 103

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

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 95 von 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;

Wähle eine oder mehr der folgenden:

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.

Erklärung

Frage 96 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 97 von 103

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

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

Wähle eine der folgenden:

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

Erklärung

Frage 98 von 103

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

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

Wähle eine der folgenden:

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

Erklärung

Frage 99 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 100 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 101 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 102 von 103

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

Wähle eine der folgenden:

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

Erklärung

Frage 103 von 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>;

Wähle eine der folgenden:

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 .

Erklärung

Antwort prüfen

["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"]

	Erstellt von Grace Li vor fast 6 Jahre

Quiz am SAS advance 63, erstellt von Grace Li am 26/09/2018.

SAS advance 63

Frage 1 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 2 von 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?

Wähle eine der folgenden:

Erklärung

Frage 3 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 4 von 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?

Wähle eine der folgenden:

Erklärung

Frage 5 von 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?

Wähle eine der folgenden:

Erklärung

Frage 6 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 7 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 8 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 9 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 10 von 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?

Wähle eine der folgenden:

Erklärung

Frage 11 von 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?

Wähle eine der folgenden:

Erklärung

Frage 12 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 13 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 14 von 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?

Wähle eine der folgenden:

Erklärung

Frage 15 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 16 von 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?

Wähle eine der folgenden:

Erklärung

Frage 17 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 18 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 19 von 103

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

Wähle eine der folgenden:

Erklärung

Frage 20 von 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?

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?