A00-232 시험 - SAS Institute실제시험문제와 답 - 113문항

Question No : 1

You are creating a PROC SQL query to list all employees who have spent (or overspent) their allotted 120 hours of vacation for the current year. The hours that each employee used are stored in the existing column Spent. Your query defines a new column, Balance, to calculate each employee's balance of vacation hours.
Which query produces the report that you want?
A)

B)

C)

D)

정답: A
Explanation:
When a WHERE clause references a new column that was defined in the SELECT clause, the WHERE clause must specify the keyword CALCULATED before the column name.

Question No : 2

Are all the values for Course_Code C004? Exam Objective
• Automate programs by defining and calling macros using the SAS macro language.
• Use macro functions.

A.NA

정답:
Explanation:
Note: On the live exam, you will be evaluated both on the results of your code and the code itself. Your code should be similar to the following example code, but does not need to match exactly:

1 The %SYSFUNC function executes the SAS function TODAY and formats the value Worddate. using the macro facility.
2 The %MACRO statement defines the macro Test, which accepts the keyword parameters Vars and Dsn. The macro generates a PROC PRINT step.
3 The %MEND statement ends the macro definition of Test.
4 The %test statement calls the macro Test with a Dsn parameter value of Certadv.All and Vars parameter values of Course_Code and Fee. When executed, it generates a PROC PRINT step that reads the Certadv.All data set and prints only the columns Course_Code and Fee.
Test Your Code Solution

Question No : 3

Which of the following correctly references the macro named Printdsn as shown here:

A.%printdsn(certadv.courses, course_title days);
B.%printdsn(dsn=certadv.courses, vars=course_title days)
C.%printdsn(certadv.courses, course_title, days)
D.%printdsn(certadv.courses, course_title days)

정답:
Explanation:
To call a macro that includes positional parameters, you precede the macro name with a percent sign. You list the values for the macro variables that are defined by the parameters in parentheses. List values in the same order in which the parameters are listed, and separate them with commas. Remember that a macro call is not a SAS language statement and does not require a semicolon.

Question No : 4

Which program would correctly generate two separate lagged variables for each observation?
A)

B)

C)

D)

A.Option A
B.Option B
C.Option C
D.Option D

정답:
Explanation:
The LAG function retrieves the previous value of a numeric or character column. You can use multiple LAG functions within a program. Answer c correctly assigns the variables and uses the LAG function to generate two lagged values.

Question No : 5

Which PROC SQL step combines tables but does not overlay any columns?
A)

B)

C)

D)

A.Option A
B.Option B
C.Option C
D.Option D

정답:
Explanation:
The PROC SQL set operation that uses the set operator OUTER UNION without a keyword is the only code shown that does not overlay any columns in output.

Question No : 6

Which of the following PROC SQL steps creates a table that contains rows for the level-1 flight attendants only?
A)

B)

C)

D)

A.Option A
B.Option B
C.Option C
D.Option D

정답:
Explanation:
The CREATE TABLE statement that includes the AS keyword and query clauses creates a table and loads the results of the query into the new table. The WHERE clause selects only the rows for the level-1 flight attendants.

Question No : 7

What is the value of the column Position? Position=prxmatch('/Dutch/','Sawyer Dutch Kenai');

A.2
B.12
C.7
D.8

정답:
Explanation:
PRXMATCH searches for a pattern match and returns the position at which the pattern is found. The string Dutch is found starting in the eighth position.

Question No : 8

Which of the following statements generates an error message while trying to display the value of the macro variable Month in the SAS log?

A.%PUT the macro variable MONTH has the value &month.;
B.options symbolgen;
C.options &month;
D.%PUT &=month;

정답:
Explanation:
There are two ways to display the value of a macro variable in the SAS log: you can turn on the SYMBOLGEN system option to list the values of all macro variables that are used, or you can use the %PUT statement to write specific text, including macro variable values, to the log. Therefore, answers b, c, and d are all valid ways to display the value of the macro variable in the SAS log.

Question No : 9

Which of the following statements is used to add new rows to a table?

A.LOAD
B.VALUES
C.CREATE TABLE
D.INSERT

정답:
Explanation:
The INSERT statement is used to insert new rows into a new or existing table. There is no LOAD statement in PROC SQL, VALUES is a clause, and the CREATE TABLE statement is used to create a table.

Question No : 10

Which of the following are format options that can be placed after the format name?

A.b and c only.
B.ROUND
C.MULTIPLIER=
D.a and d only.
E.DATATYPE=
F.DEFAULT=

정답:
Explanation:
DEFAULT= and ROUND are format options that are specified after the format name. DEFAULT= specifies the default length of the formatted value. ROUND rounds the value to the nearest integer. DATATYPE= and MULTIPLIER= are template options that are specified after the template value.

Question No : 11

Which statement is false with respect to a set operation that uses the EXCEPT, UNION, or INTERSECT set operator without a keyword?

A.To be overlaid, columns must have the same name.
B.To be overlaid, columns must be of the same data type.
C.Column names in the result set are determined by the first table.
D.By default, only unique rows are displayed in the result set.

정답:
Explanation:
In set operations that use the operators EXCEPT, INTERSECT, or UNION, and no keyword, columns are overlaid based on their position in the SELECT clause. It does not matter whether the overlaid columns have the same name. When columns are overlaid, the column name is taken from the first table that is specified in the SELECT clause.

Question No : 12

When is a Cartesian product returned?

A.When join conditions are not specified in a PROC SQL join.
B.When the keyword ALL is used with the OUTER UNION operator.
C.When more than two tables are specified in a PROC SQL join.
D.When join conditions are not specified in a PROC SQL set operation.

정답:
Explanation:
A Cartesian product is returned when join conditions are not specified in a PROC SQL join. In a Cartesian product, each row from the first table is combined with every row from the second table.

Question No : 13

Which of the statements or clauses in the PROC SQL program below is written incorrectly?

A.WHERE
B.FROM
C.Both a and c.
D.SELECT

정답:
Explanation:
The SELECT clause in the program is written incorrectly. Columns that are listed in the clause must be separated by commas, not just blanks.

Question No : 14

Which statement contains the incorrect syntax for a one-dimensional array?

A.array student[4] Student1-Student4;
B.array coupon[3] (.10, .20, .25);
C.array student[4] _temporary_ $16 ('Anna Johnson', 'Ramesh Pinto', 'Ela Minsur', 'David Michaelsen');
D.array year[2014:2018) Year2014-Year2018;

정답:
Explanation:
The items in an ARRAY statement must be specified in the following order: ARRAY array-name[number-of-array-elements]<$ length array-elements _TEMPORARY_ (initial-values)>;

Question No : 15

Which PICTURE statement displays a nine-digit account number with six leading asterisks followed by the last five digits, such as ******56789?

A.picture actfmt low-high='999999999' (prefix='******');
B.picture actfmt (prefix='*****') low-high='999999999';
C.picture actfmt low-high='99999'(prefix='******');
D.picture actfmt (prefix='******') low-high='99999';

정답:
Explanation:
The five-digit digit selector truncates the leading digits, and the PREFIX= option specifies a character string to place in front of the formatted value. The PREFIX= option must be specified after the template.

SAS Institute A00-232 시험