Focused business man working at laptop with SAS® Optimization software

SAS Big Data Programming and Loading

Exam Content Guide

Below we provide a list of the objectives that will be tested on the exam.
For more specific details about each objective download the complete exam content guide.

SAS® Visual Statistics cluster on desktop monitors

 

SAS and Hadoop - 30%

  • Describe the baseline requirements for interacting with Hadoop
  • Use the HADOOP procedure and the Hadoop FILENAME statement to interact with Hadoop from a SAS session
  • Query and manage Hive tables stored in Hadoop using explicit SQL pass-through
  • Work with Hadoop files using the SAS/ACCESS LIBNAME statement

SAS DS2 Programming - 30%

  • Write DS2 programs
  • Read data using DS2
  • Work with variables, arrays, and ANSI SQL data types
  • Use expressions and functions in DS2 programs
  • Work with Methods, Packages, and Threads

Hadoop Programming - 15%

  • Describe the Hadoop architecture
  • Manipulate and load data files using command line tools
  • Write Hive programs to create, join, and query data tables
  • Write Pig programs to perform ETL tasks and to analyze large data sets

Data manipulation with the IMSTAT procedure - 25%

  • Execute IMSTAT procedures
  • Perform actions required to produce graphs with PROC IMSTAT
  • Manipulate In-Memory Data
  • Use High-Performance procedures with the SAS LASR Analytic Server

Recommended Resources

Catalog

Download Training Catalog

A comprehensive guide to SAS training and certification options.

Directory

Certified Professional Directory

A public registry of SAS certified professionals.

Contact Us

Contact Us

Have a question? Need more information?
We're here to help.

Back to Top