OpenExamsFREE PRACTICE — ANY EXAM

SAS Certified Data Integration Developer for SAS 9 — Requirements & Free Practice

US · License preparation

100 free questions · Answer explanations · No signup required

Choose what to practice

Start with an exam below. Your examination requirements depend on your application pathway. View licensing requirements

Loading selected examination banks…

Licenses, application pathways and examination requirements

Each license and applicant pathway has its own requirements and exemptions. Choosing practice questions does not determine your eligibility.

SAS Certified Data Integration Developer for SAS 9

Certification of skills and knowledge for data integration development in the SAS environment.

Licensing authority: SAS Institute Inc. · Application information

Initial by examination
SAS® Certified Data Integration Developer for SAS® 9
Cancellation
Cancel or reschedule at least 24 hours before the appointment; late changes or no-show forfeit the full fee.
Eligibility
Accept the SAS Institute Inc. Certification Program Candidate Agreement and comply with conduct and applicable trademark requirements; the credential page identifies no additional examination prerequisite.
Payment
Published exam fee USD 180, payable to Pearson at registration; applicable academic discounts follow SAS policy.
Retakes
Up to five attempts in 12 months, at least 14 days between attempts, with fees for each attempt; no further attempt after passing for initial qualification.
Scheduling
Use exam ID A00-260 and the SAS Certification Portal to schedule an appointment; no fixed application deadline is published on the credential or portal page. Provider controls appointment availability.
Source Claim Ids
["sas260-adoption","sas260-registration","sas260-assessment"]
Testing
Pass A00-260, based on SAS 9.4 using SAS Data Integration Studio 4.8 and later; published passing score 69%.

SAS® Certified Data Integration Developer for SAS® 9

Provider
SAS and Pearson VUE
Format
Multiple choice and short-answer questions
Exam questions
Total questions: 52.
Time limit
105 minutes
Passing score
69%
Exam fee
USD 180
Examination outline

The authority publishes percentage ranges for each content area. The practice percentages below use the midpoint of each range, normalized to 100%; they are not exact percentages published by the authority. Practice question counts may differ slightly because of rounding.

  • Overview — Official range: 5–6% (Practice allocation: 5.5%)
    • Platform architecture for SAS Business Analytics
    • SAS Data Integration Studio interface
    • Change management
  • Creating Metadata for Source and Target Data — Official range: 19–20% (Practice allocation: 19.5%)
    • Administrative tasks
    • New Library Wizard
    • Register Tables wizard and source metadata
    • Microsoft Access table metadata using ODBC
    • Comma-delimited external file metadata
    • Import and Export Metadata
  • Creating Metadata for Target Data and Jobs — Official range: 17–18% (Practice allocation: 17.5%)
    • New Table wizard
    • Join's Designer window
    • Mapping and propagation
    • Performance statistics
    • Metadata reports for tables and jobs
    • Impact and Reverse Impact Analysis
  • Working with Transformations — Official range: 21–22% (Practice allocation: 21.5%)
    • Extract and Summary Statistics transformation
    • Loop transformations
    • Status handling
    • Data Validation transformation
    • Rank, Transpose, Append, List and Sort transformations
    • SQL grouping transformations
  • Working with Tables and the Table Loader Transformation — Official range: 17–18% (Practice allocation: 17.5%)
    • Reasons to use Table Loader
    • Table Loader load styles
    • Types and definition of keys
    • Definition of indexes
    • Table Loader options for keys and indexes
    • Bulk Table Loader transformation
    • Join’s Designer Window for in database processing
  • Defining Generated Transformations — Official range: 5–6% (Practice allocation: 5.5%)
    • SAS code transformation templates
    • Custom transformation
  • Deploying Jobs — Official range: 5–6% (Practice allocation: 5.5%)
    • Types of job deployment
    • Scheduling process
  • In Database Processing — Official range: 7–8% (Practice allocation: 7.5%)
    • In-database processing and benefits
    • Enable in-database processing
    • ELT methods
    • DBMS functions in a SAS DI job
Examination sources