A00-215 Dumps (V11.02) with 78 Exam Questions and Answers – Your Best Preparation Resource for SAS Certified Associate: Programming Fundamentals Using SAS 9.4 Exam

1. Which step temporarily assign a format to the sales variable?

2. Which PROC PRINT option displays variable labels in the report?

3. You submit a program and the SAS log is shown below:

Which statement is true regarding the submitted program?

4. The data set Snacks contains three variables (productName, Flavor, and Price).

Given the program shown below:

What is the type and length of SnackType?

5. Which statement is true regarding variable names?

6. Which PROC SORT option allows you to create an output data set of the sorted data?

7. Given the following code:

Which variables are created with the BY statement?

8. Given the display of the CITIES data set:

Which program creates the PROC PRINT report below?

9. Which statements read the input data set SASHELP. SHOES and create the output data set WORK. TOTAL?

10. The sashelp. class data set has 19 observations.

Given the frequency information about the Age, shown below:

How many observations are written to output data set when the following code is submitted?

11. The SAS log of a submitted DATA step is shown below:

Which action resolve the error messages?

12. Which statement is true regarding a variable?

13. Given the SAS data set WORK PRODUCTS:

The following SAS program is submitted:

How many variables does the WORK REVENUE data set contains?

14. How does SAS display missing values?

15. CORRECT TEXT

Given the following DATA step:

What is the value of average? Enter your numeric answer in the space above.

16. The following program is summited:

The following report is created:

However, the desired report is shown below:

What change is needed to display the desired formatted values for the Answer varia?

17. What type of error does NOT produce the expected results and does NOT generate errors or warnings in the log?

18. Which statement is true about the DROP statement during the compilation phase of the DATA step?

19. Which statement is true regarding the XLSX engine in the LIBNAME statement?

20. Given the report shown below:

Which PROC PREQ step creates the frequency report?

21. Which variable in the Program Data Vector represents the number of times the Data step has iterated?

22. CORRECT TEXT

What is the default byte size of a numeric variable?

Enter your numeric answer in the space above.

23. Which statement is true when creating two SAS data sets with a DATA step?

24. When the following code is submitted, execution fails.

Why does the execution fail? Multiple executable statements are not allowed in the DO block.

25. Which PROC PRINT step correctly displays only the first 10 observations in the data set?

26. Given the partial shown below:

Which step will produce this report?

27. Which code uses the correct syntax to conditionally create the two variables age-Cat and account?

28. Given the input data set WORK.RUN:

Given the following DATA step:

What is the correct output data set WORK.RUN2? A)

B)

C)

D)

29. Given the data sets AMERICIAN NATIONAL and results in the data set BASEBALL shown below:

AMERICAN

NATIONAL BASEBALL

Which DATA step correctly creates the BASEBALL data set?

30. Which PROC MEANS program creates the report below?