SAS advance 63

Please wait - loading…

Question 1 of 103

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

Select one of the following:

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

Explanation

Question 2 of 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?

Select one of the following:

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;

Explanation

Question 3 of 103

3. Given the SAS data sets:

What would allow the program to successfully execute without errors?

Select one of the following:

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.

Explanation

Question 4 of 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?

Select one of the following:

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

Explanation

Question 5 of 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?

Select one of the following:

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.

Explanation

Question 6 of 103

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

Which SQL statement could NOT generate this result?

Select one of the following:

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

Explanation

Question 7 of 103

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

Select one of the following:

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.

Explanation

Question 8 of 103

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

Select one of the following:

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

Explanation

Question 9 of 103

9. Given the SAS data set WORK.TRANSACT:

Which SQL statement was used?

Select one of the following:

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
;

Explanation

Question 10 of 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?

Select one of the following:

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

Explanation

Question 11 of 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?

Select one of the following:

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.

Explanation

Question 12 of 103

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

Select one of the following:

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

Explanation

Question 13 of 103

13. Given the SAS data sets:

Which SQL procedure statement produces the same results?

Select one of the following:

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
;

Explanation

Question 14 of 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?

Select one of the following:

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;

Explanation

Question 15 of 103

15. Given the SAS data set WORK.ONE:

Which result set would be generated?

Select one of the following:

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

Explanation

Question 16 of 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?

Select one of the following:

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

Explanation

Question 17 of 103

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

Select one of the following:

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

Explanation

Question 18 of 103

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

Select one of the following:

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.

Explanation

Question 19 of 103

19. Function %UPCASE:

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

Select one of the following:

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

Explanation

Question 20 of 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?

Select one of the following:

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

Explanation

Question 21 of 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:

Select one of the following:

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.

Explanation

Question 22 of 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?

Select one of the following:

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

Explanation

Question 23 of 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?

Select one of the following:

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

Explanation

Question 24 of 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?

Select one of the following:

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

Explanation

Question 25 of 103

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

How many observations appear in the generated report?

Select one of the following:

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

Explanation

Question 26 of 103

26. Given the following SAS data sets:

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

Select one of the following:

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
;

Explanation

Question 27 of 103

27. Given the SAS data sets:

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

Select one of the following:

Explanation

Question 28 of 103

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

Select one of the following:

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;

Explanation

Question 29 of 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?

Select one of the following:

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

Explanation

Question 30 of 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"

Select one of the following:

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

Explanation

Question 31 of 103

31. Given the SAS data sets:

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

Select one of the following:

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

Explanation

Question 32 of 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?

Select one of the following:

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

Explanation

Question 33 of 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?

Select one of the following:

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;

Explanation

Question 34 of 103

34. Given the SAS dataset WORK.ONE

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

Select one of the following:

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"

Explanation

Question 35 of 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?

Select one of the following:

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.

Explanation

Question 36 of 103

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

Select one of the following:

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.

Explanation

Question 37 of 103

37. Given the SAS data sets:

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

Select one of the following:

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

Explanation

Question 38 of 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?

Select one of the following:

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

Explanation

Question 39 of 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?

Select one of the following:

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

Explanation

Question 40 of 103

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

Select one of the following:

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

Explanation

Question 41 of 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?

Select one of the following:

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

Explanation

Question 42 of 103

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

Select one of the following:

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

Explanation

Question 43 of 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?

Select one of the following:

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)

Explanation

Question 44 of 103

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

Select one of the following:

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

Explanation

Question 45 of 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

Select one of the following:

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

Explanation

Question 46 of 103

46. Given the SAS data sets:

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

Select one of the following:

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

Explanation

Question 47 of 103

47. The following SAS program is submitted:

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

Select one of the following:

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

Explanation

Question 48 of 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?

Select one of the following:

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

Explanation

Question 49 of 103

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

Select one of the following:

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

Explanation

Question 50 of 103

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

Which select statement could NOT have produced this output?

Select one of the following:

Explanation

Question 51 of 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?

Select one of the following:

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

Explanation

Question 52 of 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:

Select one of the following:

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

Explanation

Question 53 of 103

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

Select one of the following:

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

Explanation

Question 54 of 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?

Select one of the following:

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

Explanation

Question 55 of 103

55. Given the SAS data sets:

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

Select one of the following:

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

Explanation

Question 56 of 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?

Select one of the following:

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

Explanation

Question 57 of 103

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

Select one of the following:

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.

Explanation

Question 58 of 103

Given the SAS dataset WORK.ONE:

Salary
------
200
205
.
523

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

Select one of the following:

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

Explanation

Question 59 of 103

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

Select one of the following:

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.

Explanation

Question 60 of 103

Given the data set SASHELP.CLASS:

Which PROC steps execute successfully?

Select one of the following:

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

Explanation

Question 61 of 103

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

Select one of the following:

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

Explanation

Question 62 of 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.

Select one of the following:

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

Explanation

Question 63 of 103

63. The following SAS program is submitted:

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

Select one of the following:

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

Explanation

Question 64 of 103

Fill the blank space to complete the text.

如何在 Log 中輸出 global macro variables

%put

Explanation

Question 65 of 103

Fill the blank space to complete the text.

選出 unique value of a grouped variable

If =1 then output=xxx

(model 是這個 variable 的名字)

Explanation

Question 66 of 103

Fill the blank space to complete the text.

outer union

Explanation

Question 67 of 103

Fill the blank space to complete the text.

A Data has 2000million observations and 300 Character variables

Compress=

Explanation

Question 68 of 103

Fill the blank space to complete the text.

Data Set
ONE
State_ID state
TWO
State_ID City

Quit 前的最後一句:

Ask: where s.state=

(注意一定要加引號)

Explanation

Question 69 of 103

Fill the blank space to complete the text.

HASH object

Explanation

Question 70 of 103

Fill the blank space to complete the text.

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

Explanation

Question 71 of 103

Fill the blank space to complete the text.

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

Explanation

Question 72 of 103

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

Select one of the following:

True
False

Explanation

Question 73 of 103

Fill the blank space to complete the text.

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

Explanation

Question 74 of 103

Fill the blank space to complete the text.

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

Explanation

Question 75 of 103

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

Select one or more of the following:

reduce CPU
reduce I/O
increase memory

Explanation

Question 76 of 103

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

Select one or more of the following:

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

Explanation

Question 77 of 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?

Select one or more of the following:

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

Explanation

Question 78 of 103

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

Select one of the following:

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

Explanation

Question 79 of 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 的值，答案:

Select one or more of the following:

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

Explanation

Question 80 of 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的

Select one of the following:

True
False

Explanation

Question 81 of 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:

Select one of the following:

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

Explanation

Question 82 of 103

Pagesize info
Which of proc can check the pagesize info?

Select one of the following:

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

Explanation

Question 83 of 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?

Select one of the following:

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

Explanation

Question 84 of 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?

Select one of the following:

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

Explanation

Question 85 of 103

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

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

Select one of the following:

True
False

Explanation

Question 86 of 103

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

Select one or more of the following:

Answer: Charlie Omar
Answer:
Charlie
Omar

Explanation

Question 87 of 103

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

Select one or more of the following:

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.

Explanation

Question 88 of 103

哪个个 view 的命名 code 正确?

Select one or more of the following:

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

Explanation

Question 89 of 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?

Select one of the following:

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

Explanation

Question 90 of 103

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

Select one of the following:

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

Explanation

Question 91 of 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.

Select one of the following:

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

Explanation

Question 92 of 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?

Select one or more of the following:

Product Totalsales
1001 500
1002 .
1003 200
Product Totalsales

1001 500
1002 .
1003 200

Explanation

Question 93 of 103

Work.temp is indexed

Select one of the following:

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

Explanation

Question 94 of 103

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

Select one or more of the following:

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

Explanation

Question 95 of 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;

Select one or more of the following:

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.

Explanation

Question 96 of 103

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

Select one of the following:

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

Explanation

Question 97 of 103

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

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

Select one of the following:

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

Explanation

Question 98 of 103

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

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

Select one of the following:

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

Explanation

Question 99 of 103

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

Select one of the following:

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

Explanation

Question 100 of 103

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

Select one of the following:

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

Explanation

Question 101 of 103

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

Select one of the following:

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

Explanation

Question 102 of 103

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

Select one of the following:

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

Explanation

Question 103 of 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>;

Select one of the following:

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 .

Explanation

Check answer

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

	Created by Grace Li about 6 years ago

Quiz on SAS advance 63, created by Grace Li on 26/09/2018.

SAS advance 63

Question 1 of 103

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

Select one of the following:

Explanation

Question 2 of 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?

Select one of the following:

Explanation

Question 3 of 103

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

Select one of the following:

Explanation

Question 4 of 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?

Select one of the following:

Explanation

Question 5 of 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?

Select one of the following:

Explanation

Question 6 of 103

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

Select one of the following:

Explanation

Question 7 of 103

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

Select one of the following:

Explanation

Question 8 of 103

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

Select one of the following:

Explanation

Question 9 of 103

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

Select one of the following:

Explanation

Question 10 of 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?

Select one of the following:

Explanation

Question 11 of 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?

Select one of the following:

Explanation

Question 12 of 103

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

Select one of the following:

Explanation

Question 13 of 103

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

Select one of the following:

Explanation

Question 14 of 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?

Select one of the following:

Explanation

Question 15 of 103

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

Select one of the following:

Explanation

Question 16 of 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?

Select one of the following:

Explanation

Question 17 of 103

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

Select one of the following:

Explanation

Question 18 of 103

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

Select one of the following:

Explanation

Question 19 of 103

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

Select one of the following:

Explanation

Question 20 of 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?