A00-215 SAS 9.4 Programming Fundamentals Exam is a hot SAS Programming Certification test. PassQuestion provides the up-to-date A00-215 Exam Questions which are useful and valuable for you to prepare the exam well and get the certification, it covers all the exam topics tested in the real test and add your confidence in achieving your goal. We guarantee that after using our A00-215 Exam Questions, you will be prepared to take and pass your SAS Institute A00-215 exam in a easy way.

SAS Certified Associate: Programming Fundamentals Using SAS 9.4

For the student new to SAS programming, this credential is a great place to start your SAS journey. It provides an opportunity to test the knowledge gained in your SAS training classes, and demonstrate that you understand the fundamentals of SAS programming. Candidates who earn this credential will have earned a passing score on the SAS 9.4 Programming Fundamentals exam.

Exam Content

This exam is administered by SAS and Pearson VUE.
60-65 multiple choice and short-answer questions. (must achieve a score of 68% to pass)
120 minutes
Use exam ID A00-215; required when registering with Pearson VUE
This exam is based on SAS 9.4 M5
Pricing Information: SAS 9.4 Programming Fundamentals exam fee $120 USD.

Exam Objectives

Fundamental SAS Concepts

• Recall general rules of DATA and PROC steps
• Recognize general rules of SAS statements including global statements
• Interpret the SAS log
• Distinguish between syntax and logic errors

Explore SAS Data Sets

• Recall naming conventions used for SAS data sets and variables
• Recognize variable types (character and numeric)
• Explain how to create and manipulate SAS date values
• Recognize how SAS stores missing data
• Use the LIBNAME statement to read SAS data sets
• Use PROC CONTENTS to view the descriptor portion of a data set
• Recall how to use Data Set options: DROP=, KEEP=, RENAME=, OBS=

Using the DATA Step to Access SAS Data Sets

• Use the DATA statement to create one or multiple data sets
• Use the SET statement to read a data set
• Explain how to combine data sets
• Explain the compilation and execution process of the DATA step
• Subset observations and variables

Using the DATA Step to Manipulate Data

• Create or update variables
• Recognize SAS Functions
• Perform conditional processing
• Control the output of observations
• Create an accumulating variable
• Explain the function of iterative DO loops
• Assign permanent attributes

Generate Reports Using PROC Steps

• Use PROC PRINT to generate a detail report
• Use PROC MEANS to generate a summary report
• Use PROC FREQ to generate a frequency report
• Identify methods to enhance reports

Use Utility Procedures

• Use PROC SORT to sort a report based on values of a variable
• Use PROC FORMAT to define custom formats

Import and Export non-SAS files

• Use a procedure to transfer a CSV file
• Use the LIBNAME statement to import/export an Excel file with XLSX engine
• Use ODS to direct reports to external files