A00-232 Exam Dumps – Reliable Way to Pass and Get Certified

1. Complete the FUNCTION statement to create a function named TitleName that consists of two character arguments.

2. Which output will the following PROC SQL query generate?

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

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

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

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

7. Consider this PROC SQL query:





The table Certadv.Internationalflights contains 201 rows, 7 unique values of FlightNumber, 115 unique values of Boarded, and 4 different flight numbers that have an average value of Boarded that is greater than 150.

How many rows of output will the query generate?

8. What is the observation number where the Course_Code is C001, and Location is Boston?

Exam Objective

• Automate programs by defining and calling macros using the SAS macro language.

• Create data-driven programs using the SAS macro language.

9. Which of the following programs correctly creates a series of macro variables whose names are values of the data set variable Course_code, and then indirectly references one of those macro variables in a later step?

A)





B)





C)





D)

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

A)





B)





C)





D)

11. What value will these statements assign to the macro variable Reptile?

12. What are the four types of tokens that SAS recognizes?

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

14. Which directives create the following value? 2019.03.19 @ 8:25:19 PM

15. What does the FIND hash object method do?

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

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

18. What system option do you have to specify in order to use the new function that you created in a DATA step or a supported PROC step?

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

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

Create custom functions with the FCMP procedure.

21. Given the following program, which statement is not true?

22. When you use an %IF-%THEN statement in your macro program, which of the following is true?

23. Which of the following programs correctly sets the appropriate system options and calls the macro Prtlast? Assume that Prtlast is stored in an autocall library as a text file and that it has not been compiled during the current SAS session.

A)





B)





C)





D)

24. When does the DOSUBL function execute the text string?

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

A)





B)





C)





D)

26. Which statement about the following PROC SQL query is false?

27. Which PROC SQL step combines the tables Certadv.Summer and Certadv.Winter to produce the output displayed below? (pic)

A)





B)





C)





D)

28. What is the value of diff[i] at the end of the second iteration of the DO loop for the first iteration of the DATA step?

29. Consider the following PROC SQL query:





The query references two tables: Certadv.Donors lists name and contact information for all donors who have made contributions since the charity was founded. The table also contains these two columns: Total, which shows the total dollars given by each donor, and Since, which stores the first year in which each donor gave money. Certadv.Current lists the names of all donors who have made contributions in the current year, and the total dollars each has given this year (YearTotal). Assume that the values of LastName are unique in both tables.

What will the output of this query display?

30. Which PROC SQL step returns the names of all the students who took PROG1, PROG2, or both classes?





A)





B)





C)





D)

31. If a macro trigger is embedded in a literal token and you want the trigger to resolve, then the literal string must be enclosed in double quotation marks.

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

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





A)





B)





C)





D)

34. What is the value of Raise for employee ID number E0028 and last name of Lichtenstein? Exam Objective

Generate detailed reports by working with a single, joining tables, or using set operators in SQL.

35. You can define a hash iterator without defining a hash object.

36. Which of the following is false?

37. How many observations are in the Work.Fail data set? Exam Objective

Process data using hash objects.

38. Which program correctly changes the order of first and last names?