Ace the A00-232 Exam and Earn SAS Certified Professional: Advanced Programming Using SAS 9.4 Credential with Our Dumps

1. Which of the following is false?

2. Which statement is false regarding an ARRAY statement?

3. Given the PROC SQL query and tables shown below, which output is generated?

4. What does a component object consist of?

5. Which of the following is false?

6. What happens if you store a macro definition in a SAS catalog SOURCE entry?

7. What is the value of Final_Cost for observation 282? Exam Objective

Create custom functions with the FCMP procedure.

8. Which of the following PROC SQL steps creates a new table by copying only the column structure (but not the rows) of an existing table?

A)

B)

C)

D)

9. Suppose you are asked to create a report of the courses that are offered in all three available locations. The report should not contain any duplicate items.

Which program correctly displays the following query result? (pic)

A)

B)

C)

D.

10. How many statements does the program below contain?

11. Which of the following correctly creates a macro variable in a PROC SQL step?

A)

B)

C)

D)

12. The keyword ALL cannot be used with which of the following set operators?

13. Which PROC SQL query removes duplicate values of MemberType from the query output, so that only the unique values are listed?

A)

B)

C)

D)

14. Which of the following TITLE statements correctly references the macro variable Month?

15. Which of the following statements about the %INCLUDE statement is correct?

16. In which step does the SAS hash object exist?

17. Which of the following examples correctly defines a macro named Print that defines and resolves parameters named vars and total?

A)

B)

C)

D)

18. Given the following DATA step, what is the value of USNum and WordNum?

19. Which of the following statements is false?

20. If you specify a CREATE TABLE statement in your PROC SQL step, which of the following happens?

21. Which PICTURE statement generates a date format that produces the following results when used with the Date column?

22. Which of the following causes PROC SQL to list rows that have no data in the Address column?

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

24. The SYMPUTX routine cannot do which of the following things?

25. Case Study 2: Write your own SAS code in SAS programming environment.

Directions

This scenario uses the Certadv.Monsal data set. Write a SAS program that does the following:

• Use PROC FORMAT to create a numeric format that specifies a template for displaying month values.

• If the value is 1 through 12, display the value as a two-digit number (month values 1 through 9 should contain a leading zero).

• If the value is not a number between 1 and 12 inclusive, display the value 'Not a valid month'.

• Name the custom format Monthfmt.

• Use a PROC PRINT step to create a report based on Certadv.Monsal. Apply the Monthfmt custom format to the Month variable.

Test Your Code

How many instances of 'Not a valid month' does your output contain?

Exam Objective

Specify a template using the PICTURE statement within the FORMAT procedure.

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

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

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

29. When is a Cartesian product returned?

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

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

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

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

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

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

A)

B)

C)

D)

36. Which PROC SQL step combines tables but does not overlay any columns?

A)

B)

C)

D)

37. Which program would correctly generate two separate lagged variables for each observation?

A)

B)

C)

D)

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

39. 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.

40. 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)