SAS Global Certification program

The SAS Data Integration Development for SAS 9 exam will test the candidate's ability to apply the skills and knowledge necessary for Data Integration Development in the SAS environment.

Successful candidates should be skilled in tasks such as:

• Defining architecture of the platform for SAS Business Analytics
• Creating Metadata for Source and Target Data
• Creating Metadata for Target Data and Jobs
• Working with Transformations
• Working with Tables and Table Loader Transformation
• Working with Slowly Changing Dimensions
• Defining Generated Transformations
• Deploying Jobs

To earn this credential, you must pass the SAS Data Integration Development for SAS 9 exam.

Required Exam

Candidates who earn this credential will have earned a passing score on the SAS Data Integration Development for SAS 9 exam. This exam is administered by Prometric.

• 78 multiple-choice questions (must achieve score of 70% correct to pass)
• 2 hours to complete exam
• Use exam ID A00-260; required when registering with Prometric.

Exam topics include:

Overview

• Define the architecture of the platform for SAS Business Analytics.
• Describe the available interfaces.
• Define the change management feature of SAS Data Integration Studio.
• Discuss the DataFlux Integration Server.

Creating Metadata for Source and Target Data

• Define administrative tasks to be performed for SAS Data Integration Studio.
• Describe the New Library Wizard.
• Use Register Tables wizard to register source data.
• Use Register Tables wizard to register metadata for a Microsoft Access database table using ODBC.
• Register metadata for a comma-delimited external file.
• Import and Export Metadata.

Creating Metadata for Target Data and Jobs

• Describe features of the New Tables wizard.
• Discuss SAS packages.
• Discuss importing and exporting of relational metadata.
• Discuss components of SQL Join's Designer window.
• Investigate mapping and propagation.
• Work with performance statistics.
• Generate reports on metadata for tables and jobs.
• Define Impact and Reverse Impact Analysis.

Working with Transformations

• Discuss and use the Extract and Summary Statistics transformation.
• Discuss and use the Loop transformations.
• Investigate where status handling is available.
• Discuss and use the Data Validation transformation.
• Discuss and use the Rank, Transpose, Append, List and Sort transformations.
• Discuss and use the Apply Lookup Standardization transformation.
• Define the Concept of a Checkpoint.

Working with Tables and the Table Loader Transformation

• Discuss reasons to use the Table Loader transformation.
• Discuss various load styles provided by the Table Loader transformation.
• Discuss various types of keys and how to define in SAS Data Integration Studio.
• Discuss indexes and how to define in SAS Data Integration Studio.
• Discuss Table Loader options for keys and indexes.

Working with Slowly Changing Dimensions

• List the functions of the SCD Type 2 transformation.
• Define business keys.
• Define surrogate and retained keys.
• Detect and track changes.
• Discuss the Lookup transformation.

Defining Generated Transformations

• Define SAS code transformation templates.
• Create a custom transformation

Deploying Jobs

• Discuss the types of job deployment available for SAS Data Integration Studio Jobs.
• Provide an overview of the scheduling process.
• Discuss the types of scheduling servers.
• Discuss the Schedule Manager in SAS Management Console.
• Discuss batch servers.
• List the applications that can be used to create and execute stored processes.
• Describe deployment of SAS Data Integration Studio jobs as a SAS Stored Process.
• Import SAS code.

The recommended preparation for the SAS Data Integration Development for SAS 9 exam will be the SAS Data Integration Studio Fast Track course. The Fast Track course is a combination of two separate courses presented in an accelerated format. While no exam questions will be drawn verbatim from the course or course exercises, the course will provide candidates with a foundation from which to apply the knowledge and skills necessary for the exam.

Experience is a critical component to becoming a SAS Certified Professional. The below diagram illustrates training options available to help you prepare for this credential's required examination. Be sure to check your local country's preparation bundles which often include an exam voucher.

Preparation options may vary by country

Choose a country for specific training options.

Choose your location Argentina Australia/New Zealand Austria Belgium/Luxemborg Brazil Canada Chile China Colombia/Venenzuela/Peru Czech Republic Denmark France Finland Germany Hong Kong Hungary India Ireland Italy Japan Korea Malaysia Mexico Netherlands Norway Poland Portugal Russia Singapore Slovakia Slovenia South Africa Spain Sweden Switzerland Taiwan Thailand Turkey United States UK

For more information

Contact the SAS Global Certification Program at certification@sas.com or 800-333-7660.

Registration Options

• Online
  Visit www.prometric.com/sas. Follow these easy steps once on the site:
  1. Select the first box "Schedule a Test"
  2. Select "Schedule an Appointment"
  3. Choose your country and state/province if applicable
  4. Insure that "SAS Institute" is selected as your client and program
  5. Select your desired SAS certification exam
  6. Review available testing sites and select "Schedule Appointment"
  First-time registration with Prometric requires a 24-hour waiting period before the candidate can schedule an exam online. Candidates who are registering for an exam for the first time will receive an email confirmation from Prometric within 24 hours to begin the online scheduling process. Candidates who have previously tested with Prometric and have their Prometric ID or have previously registered online can schedule their exam online immediately.

• Telephone
  By phone in the U.S. and Canada: 888-895-5819 between 7:00 a.m. and 7:00 p.m. CST

  By phone outside the U.S. and Canada, visit www.prometric.com/sas for a list of exam registration phone numbers.

Testing Locations

To find your nearest testing center, visit www.prometric.com/sas.

Information required upon registration

Please be prepared to provide the following information to Prometric when registering:

1. First and last name - Please provide your name as you would like it to appear on your certificate.
2. Prometric assigns a unique identification number to each candidate. Please use this ID number each time you schedule an exam with Prometric or SAS.
3. Mailing address - Please list the address to which all correspondence should be mailed.
4. Company name - If you have listed your business address, please include your company name to ensure appropriate routing.
5. E-mail address - For the latest program updates, email is the most efficient and effective means of contacting you.
6. Contact phone numbers
7. Exam number and title
8. Testing center preference - To find your nearest testing center, visit www.prometric.com/sas.
9. Method of payment (credit card (American Express, Mastercard, and Visa), vouchers) Payment options may vary by country.

If your address has changed since you last registered for an exam, please contact Prometric to update your demographic information.

Exam Pricing

Within North America and India, the cost associated with an exam offered through Prometric is US $180.

Certification exam prices are subject to change. In some countries, different pricing and additional taxes may apply. Please visit www.prometric.com/sas for exam pricing in your country.

Faculty, staff, and full-time students of degree-granting institutions are eligible for a discount on SAS Certification exams. Candidates in the United States and Canada receive a 50% discount. International candidates should contact your local office for discount information.

Cancellation Policy

Candidates may cancel or reschedule exams at no charge if they contact the Prometric Regional Service Center by 6:00 p.m. ET at least one business day prior to the scheduled exam date. Candidates who do not appear for the test or cancel less than one business day before the exam will not receive a refund.

Retake Policy

Candidates may attempt each certification exam up to five times in a 12-month period, waiting a minimum of 14 days between attempts. Exams that do not comply with this retake policy will be considered invalid and will not be eligible for refund and/or a certification credential. Once a passing score is achieved on a specific exam, no further attempts are allowed on that exam.

Candidate Agreement

Candidates are encouraged to review the SAS Institute Inc. Global Certification Program Candidate Agreement prior to their exam day.

What to bring: Certification candidates are required to provide two forms of identification at the testing center, including one photo identification such as a driver's license or a valid passport. Both forms must display the candidate's signature.

Arriving at the test center: Candidates should plan to arrive 15 minutes before their scheduled exam time. Candidates arriving more than 15 minutes late are not guaranteed exam availability or a refund.

Reference materials: To maintain the security of the test environment, candidates are not permitted to bring reference materials of any kind into the testing center.

Personal items: The only items allowed in the testing area are your identification. Please leave any backpacks, laptops, briefcases and other personal items at home. If you have personal items that cannot be left behind (such as purses), the testing center may have lockers available for use. No cameras, cell phones, audio players, or other electronic devices are allowed during exam sessions. Please refer to Prometric Testing Center Regulations for more information.

All notes will be collected at the end of testing and no material may be removed from the testing event.

Score Report

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 have passed your exam and met all requirements for this credential, you will receive two e-mails. One e-mail will contain your logo access and welcome information. The second e-mail will include a pdf copy of your certificate which you can print at any time. These e-mails will be sent to the e-mail address you provided to Prometric at exam registration. Please allow at least two weeks from your exam date to receive your e-mails.

Directory Listing

Upon receipt of your credentials from SAS, your name will be added to the SAS Certified Professional Directory Listing. This process can take up to one week after your certificate is awarded. If you do not wish for your name to appear in the SAS Certified Professional Directory listing, you may choose to be excluded at the time of exam registration.