The SAS Certified Base Programmer for SAS 9 credential is the ideal certification for those relatively new to SAS programming or new to SAS certification. It is also the principle certification for other advanced certifications available from SAS. import and export raw data files
manipulate and transform data
combine SAS data sets
create basic detail and summary reports using SAS procedures
identify and correct data, syntax and programming logic errors
Successful candidates should have experience in programming and data management using SAS 9 and should be able to:
To earn this credential, you must pass the SAS Base Programming for SAS 9 exam.
After the Exam
You will receive an immediate pass/fail score upon completion of your exam attempt at your testing facility. The score report will display the percentage of items in each section that you answered correctly for your exam. Please note: These section scores are calculated on a per section basis and cannot be used in determining your total score. They are provided to you for descriptive purposes only.
Welcome E-mail and Certificate
If you pass your exam and meet all requirements for this credential, you will receive an e-mail from SAS with instructions providing access to your certificate and logo. This e-mail will be sent to the e-mail address you provided to Pearson VUE at exam registration. Some individual firewalls may send this e-mail to your junk folder. Please allow at least one week from your exam date to receive your e-mail.
Candidates who earn this credential will have earned a passing score on the SAS Base Programming for SAS 9 exam. This exam is administered by SAS and Pearson VUE.
- 64 multiple-choice and short-answer questions (must achieve score of 70% correct to pass)
- 110 minutes to complete exam
Candidates should be familiar with the enhancements and new functionality that are available in SAS 9.3
Exam topics include:
- Use FORMATTED and LIST input to read raw data files.
- Use INFILE statement options to control processing when reading raw data files.
- Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls.
- Combine SAS data sets.
- Access an Excel workbook.
Creating Data Structures
- Create temporary and permanent SAS data sets.
- Create and manipulate SAS date values.
- Export data to create standard and comma-delimited raw data files.
- Control which observations and variables in a SAS data set are processed and output
- Investigate SAS data libraries using base SAS utility procedures.
- Sort observations in a SAS data set.
- Conditionally execute SAS statements.
- Use assignment statements in the DATA step.
- Modify variable attributes using options and statements in the DATA step.
- Accumulate sub-totals and totals using DATA step statements.
- Use SAS functions to manipulate character data, numeric data, and SAS date values.
- Use SAS functions to convert character data to numeric and vice versa.
- Process data using DO LOOPS.
- Process data using SAS arrays.
- Validate and clean data.
- Generate list reports using the PRINT procedure.
- Generate summary reports and frequency tables using base SAS procedures.
- Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting.
- Generate reports using ODS statements
- Identify and resolve programming logic errors.
- Recognize and correct syntax errors.
- Examine and resolve data errors