A00-212無料問題集「SASInstitute SAS Advanced Programming Exam for SAS 9」

質問 1

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

（A）It is most effective with character data that contains patterns, rather than simple repetitions

（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 uses the Ross Data Compression method to compress numeric data

正解：B 解答を投票する

質問 2

What is an advantage of using a hash object in a SAS DATA step?

（A）The hash object does not require unique keys

（B）The hash object persists after the DATA step has executed

（C）The hash object key values can be multiple numeric and character data values

（D）The hash object automatically sorts the data

正解：C 解答を投票する

質問 3

Which one of the following displays the definition of a stored SQL procedure view in the
SAS log?

（A）DESCRIBE VIEW statement

（B）ECHOVIEW option

（C）VALIDATE VIEW statement

（D）EXPANDVIEW option

正解：A 解答を投票する

質問 4

A data set stored on a network drive has the following characteristics:
14 Million observations
400 numeric variables
0 character variables of length 20
Binary compression
A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to
reduce computer resource utilization in this DATA Step?

（A）A KEEP= data set option used on the DATA Statement

（B）A DROP= data set option used on the DATA Statement

（C）A KEEP Statement used within the DATA Step

（D）A KEEP= data set option used on the SET Statement

正解：B 解答を投票する

質問 5

Given the following SAS data set ONE:
ONE
COUNTRY CITY VISIT
USA BOSTON 10
UK LONDON 5
USA DALLAS 10
UK MARLOW 10
USA BOSTON 20
UK LONDON 15
USA DALLAS 10
The following SAS program is submitted:
proc sql;
select country, city, sum(visit) as TOTAL
from one
group by country, city
order by country, total desc;
quit;
Which one of the following reports is generated?

（A）COUNTRY CITY TOTAL
UK LONDON 20
UK MARLOW 10
USA BOSTON 50
USA DALLAS 20

（B）COUNTRY CITY TOTAL
USA BOSTON 50

（C）COUNTRY CITY TOTAL
UK MARLOW 10
UK LONDON 20
USA BOSTON 50
USA DALLAS 20

（D）COUNTRY CITY TOTAL
UK MARLOW 10
UK LONDON 20
USA DALLAS 20
USA BOSTON 50

正解：A 解答を投票する

質問 6

This question will ask you to provide a segment of missing code.
Given data sets ONE and TWO with the same variables, the following SAS program is submitted:

In the text below, complete the following program so that it will produce the same results as the above program:

Case is ignored and standard SAS syntax rules apply.

正解：

CORR
Explanation:
Reference:
http://www.koerup.dk/Cert/0104/010405/010405.html

質問 7

Which one of the following is true regarding the KEEP statement?

（A）The KEEP statement is available in both the DATA and the PROC steps.

（B）The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is
created.

（C）The KEEP statement applies to all data sets created within the same DATA step.

（D）The KEEP statement selects the variables read from the input data set(s).

正解：C 解答を投票する

質問 8

The following SAS program is submitted:
proc contents data = testdata.one;
run;
Which one of the following SQL statements produces similar information about the column attributes as the above
CONTENTS procedure?

（A）proc sql;
describe table testdata.one;
quit;

（B）proc sql;
show testdata.one;
quit;

（C）proc sql;
show table testdata.one;
quit;

（D）proc sql;
describe testdata.one;
quit;

正解：A 解答を投票する

質問 9

CORRECT TEXT
The following SAS program is submitted:
% macro check(num=4);
% let result=%sysevalf(&num+0.5);
% put result is &result;
% mend;
% check(num=10)
What is the written to the SAS log?

（A）result is 10+0.5

（B）result is 10.5

（C）result is

（D）result is 10

正解：B 解答を投票する

質問 10

Given the following SAS program:
proc sql;
select product, type, sum(sales) as revenue
from one
group by product, type;
quit;
Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing
REVENUE?

（A）order by 1, 3

（B）order by 1, 3 desc

（C）orderby product, revenue desc

（D）order by product, desc revenue

正解：B 解答を投票する

A00-212 無料問題集「SASInstitute SAS Advanced Programming Exam for SAS 9」

弊社を連絡する

関連リンク

トップ試験