Question No : 1
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

Show Answers

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 No : 2
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)

Show Answers

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 No : 3
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.

Show Answers

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 No : 4
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;

Show Answers

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 No : 5
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

Show Answers

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 No : 6
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

Show Answers

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 No : 7
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;

Show Answers

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 No : 8
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.

Show Answers

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 No : 9
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

Show Answers

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 No : 10
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

Show Answers

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.