SAS Big Data Programming and Loading

Exam Content Guide

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