Practice Free SAS Institute A00-232 Exam Questions Online, A00-232 Free Demo

Question 1 Selectable Answer

Which of the clauses below correctly sorts rows by the values of the columns Price and SqFeet?

A. sort price sqfeet
B. order price, sqfeet
C. order by price,sqfeet
D. sort by price sqfeet

Answer:
Explanation:
The ORDER BY clause specifies how the rows are to be sorted. You follow the keywords ORDER BY by one or more column names or numbers, separated by commas.

Question 2 Selectable Answer

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)

Answer:
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 3 Selectable Answer

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.

Answer:
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 4 Selectable Answer

For the program below, select an iterative DO statement to process all elements in the Contrib array.

A. do while i le 4;
B. do until i=4;
C. do i=1 to 4;
D. do i=4;

Answer:
Explanation:
In the DO statement, you specify the index variable that represents the values of the array elements.
Then specify the start and stop positions of the array elements.

Question 5 Selectable Answer

Which of the following programs correctly associates more than one data value with one key?
A)

B)

C)

D)

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

Answer:
Explanation:
Answer a is correct because the code correctly associates two data values, City and Name, with one key, Code. The code also uses the three required methods correctly. Answer b defines two keys and one data value, while answer c defines two data and two keys. Answer d is invalid because it does not use the required methods properly.

Question 6 Selectable Answer

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

Answer:
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 7 Selectable Answer

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;

Answer:
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 8 Selectable Answer

Which of the following is false?

A. The SYMPUTX routine can be used to create a macro variable during execution of a PROC SQL query.
B. In the DATA step, the SYMPUTX routine automatically converts numeric values to character strings before assigning values to macro variables.
C. By default, the INTO clause in PROC SQL does not remove leading and training blanks before assigning macro variable values.
D. The SYMPUTX routine can be used to create a macro variable during execution of the DATA step.

Answer:
Explanation:
The SYMPUTX routine can be used in a DATA step. In the DATA step, the SYMPUTX routine performs automatic conversion on numeric values that you attempt to assign as values for macro variables, using the BEST12. format. However, you cannot use the SYMPUTX routine to create a macro variable during the execution of a PROC SQL query.

Question 9 Selectable Answer

Which program correctly searches a string for a substring and returns the position of a substring?
A)

B)

C)

D)

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

Answer:
Explanation:
Use the PRXMATCH function in a Perl regular expression to search a string for a substring and return the position of a substring.

Question 10 Selectable Answer

Which ARRAY statement correctly loads the following values into the array DataSurv?

A)

B)

C)

D)

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

Answer:
Explanation:
In a two-dimensional array, elements are referenced using two numbers. The first number corresponds to the row and the second number corresponds to the column. The dimension values are separated with a comma. Initial values are loaded into a two-dimensional array by specifying the values one row at a time, left to right.

Question 11 Written Answer

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)

Answer: 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 12 Selectable Answer

If a substring is not found in a string, the FIND function returns which value?

A. 1
B. 2
C. 0
D. Not found.

Answer:
Explanation:
The FIND function searches for a specific substring of characters within a character string. When the FIND function finds a substring, FIND returns the value of 1. When the substring is not found, FIND returns the value of 0.

Question 13 Selectable Answer

Which PROC SQL query will generate the same output as the DATA step match-merge and PROC PRINT step shown below?

A)

B)

C)

D)

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

Answer:
Explanation:
In order to generate the same output as the DATA step and PROC PRINT steps, the PROC SQL full outer join must use the COALESCE function with the duplicate columns specified as arguments.

Question 14 Selectable Answer

Suppose you had the program below, and you wanted to concatenate the values from the libname and memname columns to create a call to %Report3 for each row of data read.
Which option would correctly run the program below and generate a result?

A. rc=dosubl(catx(%Report3,',libname,memname),')');
B. rc=dosubl(cats(%Report3,',libname,memname),')');
C. rc=dosubl(catx(%Report3(',catx(',',libname,memname),')'));
D. rc=dosubl(cats('%Report3(',catx(',',libname,memname),')'));

Answer:
Explanation:
The DOSUBL function uses the values that are found in the Libname and Memname columns concatenated between %Report3 (' and ') to generate a valid macro call.

Question 15 Selectable Answer

Which of the following creates an empty table that contains the two columns FullName and Age?
A)

B)

C)

D)

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

Answer:
Explanation:
The CREATE TABLE statement can include column specifications to create an empty table. The entire group of column specifications must be enclosed in a single set of parentheses. You must list each column's name, data type, and (for character columns) length. The length is specified as an integer in parentheses. Multiple column specifications must be separated by commas.

Test Online Free SAS Institute A00-232 Exam Questions and Answers