This page is a one-stop solution for any information you may require for SAS Certified Associate - Programming Fundamentals Using SAS 9.4 (A00-215) Certification exam. The SAS A00-215 Exam Summary, Syllabus Topics and Sample Questions provide the base for the actual SAS Programming Fundamentals Associate exam preparation, we have designed these resources to help you get ready to take your dream exam.
The SAS Certified Associate - Programming Fundamentals Using SAS 9.4 credential is globally recognized for validating SAS Programming Fundamentals knowledge. With the SAS Programming Fundamentals Associate Certification credential, you stand out in a crowd and prove that you have the SAS Programming Fundamentals knowledge to make a difference within your organization. The SAS Certified Associate - Programming Fundamentals Using SAS 9.4 Certification (A00-215) exam will test the candidate's knowledge on following areas.
SAS A00-215 Exam Summary:
| Exam Name | SAS Certified Associate - Programming Fundamentals Using SAS 9.4 |
| Exam Code | A00-215 |
| Exam Duration | 120 minutes |
| Exam Questions | 60-65 |
| Passing Score | 68% |
| Exam Price | $120 (USD) |
| Training |
SAS Programming 1: Essentials SAS Programming 2: Data Manipulation Techniques SAS Certified Specialist Prep Guide - Base Programming Using SAS 9.4 |
| Exam Registration | Pearson VUE |
| Sample Questions | SAS Programming Fundamentals Certification Sample Question |
| Practice Exam | SAS Programming Fundamentals Certification Practice Exam |
SAS A00-215 Exam Topics:
| Objective | Details |
|---|---|
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. |
- Recall SAS syntax rules. - Recognize different types of syntax errors and be able to resolve common problems. - Recall use of the PUTLOG statement to troubleshoot logic errors. |
Exploring 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. |
- Explain how SAS stores date values. - Recall how to use SAS date formats to specify how the values are displayed. |
| 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. |
- Use MERGE and BY statements to combine multiple data sets horizontally. - Use the IN= option on the MERGE statement to control processing. - Use the SET statement to combine multiple data sets vertically. |
| Explain the compilation and execution process of the DATA step. |
- Describe how the Program Data Vector PDV is created. - Explain how the LENGTH statement affects the default behavior of the PDV. - Describe the process of the data step iteration. |
| Subset observations and variables. |
- Use the WHERE statement to subset observations during input. - Use the IF statement to subset observations during processing. - Use DROP/KEEP statements to subset variables at output. - Use DROP=/KEEP= options to subset variables at input and output. |
Using the DATA Step to Manipulate Data |
|
| Create or update variables. |
- Use the assignment statement to create character and numeric variables. - Recall how to assign a date constant to a variable. |
| Recognize SAS Functions. |
- Use Character Functions: UPCASE, PROPCASE, SUBSTR, SCAN, FIND, LENGTH, CATX. - Use Date Functions: MONTH, DAY, YEAR, TODAY, MDY. - Use Truncation Functions: ROUND, INT. - Use Descriptive Stats Functions: MEAN, SUM. |
| Perform conditional processing. |
- Use the IF-THEN and ELSE statements. - Use IF-THEN DO and ELSE DO statements. - Use the LENGTH statement for assigning byte size of character variables. |
| Control the output of observations. |
- Use the OUTPUT statement to output to a specific data set. - Use the OUTPUT statement to control output timing. |
| Create an accumulating variable. |
- Use the SUM statement. - Use BY group processing with FIRST. and LAST to accumulate in groups. |
| Explain the function of iterative DO loops. | |
| Assign permanent attributes. |
- Use the FORMAT statement to change the display of the variable value. - Use the LABEL statement to change the display of the variable name |
Generating Reports Using PROC Steps |
|
| Use PROC PRINT to generate a detail report. |
- Use the LABEL option and NOOBS options to enhance the report. - Use the VAR statement to control the display of variables. |
| Use PROC MEANS to generate a summary report. |
- Use the MAXDEC= option to control the display of decimal places. - Use VAR and CLASS statements to control the structure of the report. |
| Use PROC FREQ to generate a frequency report. |
- Use the ORDER=option to control the order of the rows of the report. - Use the TABLES statement for one-way and two-way tables. - Use the NOCUM and NOPERCENT options in a one-way table. - Use the CROSSLIST option to control the layout of two-way tables. |
| Identify methods to enhance reports. |
- Use TITLE statement. - Use FOOTNOTE statement. - Use FORMAT statement for temporary attributes. - Use the LABEL statement for temporary attributes. - Use the WHERE statement for subsetting observations. |
Using Utility Procedures |
|
| Use PROC SORT to sort a report based on values of a variable. |
- Use the OUT= option to create an output data set that contains the data in sorted order. - Use the BY statement to specify the variable(s) whose values are used to sort the data. - Use the DESCENDING option with the BY statement to sort options in descending order. |
| Use PROC FORMAT to define custom formats. |
- Use the VALUE statement to display one or more values. - Use the keyword OTHER to label missing values. |
Import and Export non-SAS files |
|
| Use a procedure to transfer a CSV file. |
- Use PROC IMPORT to import a CSV file. - Use the PROC EXPORT to export to a CSV file. |
| Use the LIBNAME statement to import/export an Excel file with XLSX engine. | |
| Use ODS to direct reports to external files. |
- Use the destinations of PDF, RTF, EXCEL. - Use the options of FILE= and STYLE=. |
The SAS has created this credential to assess the knowledge and understanding of a candidate in the area as above via the certification exam. The SAS Programming Fundamentals (A00-215) Certification exam contains a high value in the market being the brand value of the SAS attached with it. It is highly recommended to a candidate to do a thorough study and also get a hand full of the practice to clear SAS Certified Associate - Programming Fundamentals Using SAS 9.4 exam without any hiccups.