Test Online Free SAS Institute A00-232 Exam Questions and Answers
Practice a live sample before buying full access. This page keeps the free A00-232 question set organized by page so visitors and search engines can reach the canonical -questions.html URL directly.
Given the following DATA step, what is the value of USNum and WordNum?
Answer: Explanation:
The COUNT function counts the number of times CANADA appeared within the Text string. The COUNTW function counts the number of words in the Text string. A default list of delimiters is used when there are no delimiters specified.
Question 17Selectable Answer
If you specify a CREATE TABLE statement in your PROC SQL step, which of the following happens?
Answer: Explanation:
The CREATE TABLE statement enables you to store your results in a SAS table instead of displaying the query results as a report.
Question 18Selectable Answer
The PROG1 and PROG2 tables list students who took the PROG1 and PROG2 courses, respectively.
Which PROC SQL step will give you the names of the students who took only the PROG1 class?
A)
B)
C)
D)
Answer: Explanation:
The set operator EXCEPT returns all the rows in the first table that do not appear in the second table. The keyword ALL suppresses the extra pass that PROC SQL makes through the data to eliminate duplicate rows. The EXCEPT operator when used alone also produces the output that is specified in the question.
Question 19Selectable Answer
What is the FedSQL equivalent of the following PROC SQL query?
A)
B)
C)
D)
Answer: Explanation:
In PROC FedSQL when you want to limit the number of rows, use the LIMIT clause in the SELECT statement. The LIMIT clause is the LIMIT keyword followed by the count or the number of rows you want to display in the output. You cannot use INOBS= in PROC FedSQL.
Question 20Selectable Answer
Which statement is true regarding the use of the PROC SQL step to query data that is stored in two or more tables?
Answer: Explanation:
If you are joining two tables that contain a same-named column, you must use a prefix to specify the table or tables from which you want the column to be read. Remember that if you join tables that do not contain columns that have matching data values, you can produce a huge amount of output. Be sure to specify a WHERE clause to select only the rows that you want.
Question 21Selectable Answer
Which of the following is false?
Answer: Explanation:
When you submit a macro definition, the macro is compiled and is stored in a SAS catalog. Then when you call the macro, the macro is executed. The macro is available for execution anytime throughout the current SAS session.
Question 22Selectable Answer
Which directives create the following value? 2019.03.19 @ 8:25:19 PM
Answer: Explanation:
The correct directives are %Y, which produces a four-digit year, %0m,which produces a two-digit month, and %0d, which produces a two-digit day. Separate all date directives with a period. Following the date directives, use the @ symbol and use the time directives. The correct time directives are %I: %M:%S %p or %0I:%0M:%0S %p. You would use %I or %0I because the output shows 8 in the evening, which is in the 12-hour clock and not the 24-hour clock.
Question 23Selectable Answer
Which output will the following PROC SQL query generate?
Answer: Explanation:
The correct answer is a.
This PROC SQL query is a left outer join, which retrieves all rows that match across tables (based on the join conditions in the ON clause), plus nonmatching rows from the left (first) table. No columns are overlaid, so all columns from both tables are displayed.
Question 24Selectable Answer
Complete the FUNCTION statement to create a function named TitleName that consists of two character arguments.
Answer: Explanation:
Character arguments must be followed by a dollar sign and separated with a comma. No quotation marks are needed.
Question 25Selectable Answer
Complete the following PROC SQL query to select the columns Address and SqFeet from the table Certadv.Size and to select Price from the table Certadv.Price. (Only the Address column appears in both tables.)
Answer: Explanation:
The SELECT clause lists the columns from both tables to be queried. You must use a prefix with the Address column because it appears in both tables. The prefix specifies the table from which you want the column to
