BookmarkSubscribeRSS Feed

SAS/ACCESS for Hadoop

Started ‎04-30-2015 by
Modified ‎10-27-2015 by
Views 5,063

Greetings and Salutations! I hope everyone who attended SAS Global Forum found the experience fun, educational, and inspirational! One of the sessions that was quite popular was the Hands-On-Workshop, "An Insider's Guide to SAS/ACCESS to Hadoop". This was taught by Jeff Bailey (Cloudera, formerly with SAS) and Diane Hatcher (SAS). Yes, that's me! Smiley Happy

 

By popular demand, I am providing the slides and exercises for the class. We didn't quite get through all of the exercises in 2 hours. There were a lot of great questions and discussion! Hadoop is a brave, new world -- so we are all learning together on how it works and how it works with SAS.

 

Some notes here:

  • The attachment is a .zip file that is about 4.5Mg in size. Included in the .zip file are the following:
    • PDF file that combines the slides plus the exercises. I consolidated these documents together after the workshop.
    • Two (2) SAS datasets to help with some of the exercise ("customers" and "orders").
    • One (1) text file for exercise 5.
  • In order to actually work through the exercises, you will need the following:
    • Base SAS (9.4) available somewhere -- either locally or on a server. You can use SAS Studio or Enterprise Guide for these exercises.
    • SAS/ACCESS to Hadoop configured to point to an existing Hadoop environment. In the class, we used Cloudera 5.3 Quickstart VM, running in vmware's VM Player 7 as a single node local Hadoop cluster. Both Quickstart and VM Player are available as free downloads. We had the Quickstart VM configured for 4Gb RAM and 2CPUs. You can adjust these settings for your environment.
    • The document also includes exercises for SAS Data Loader for Hadoop (courtesy of Lisa Dodson (SAS). You can get the free trial from http://www.sas.com/dataloader. SAS Data Loader Trial is also a VM that will run in VM Player 7. Instructions for installing and configuring SAS Dala Loader are available online, as well.
      • If you have Data Loader Trial, you can configure this first for your Hadoop VM and reuse the configuration xml files and jar files that Data Loader gathers up to help configure SAS/ACCESS to Hadoop with your SAS environment. Feel free to message me, if you want to do this.

 

Please feel free to post your feedback and questions about the exercises in the comments for this post. I hope you get a chance to try out these exercises -- they will teach you alot about how to use SAS with Hadoop!

Comments

Hi Diane,

 

Are the slides and exercises still available? Can't see any attachments on this page. 

 

Thanks

Tomas

Hi Tomas,

 

I'm the community manager for this community and am looking into the slides and exercises for you. I'll keep you posted on my findings.

 

Thanks!

Anna

Hi again Tomas,

 

I tracked down the attachment. I hope it's helpful.

 

Thanks!

Anna

Hi, I have license to SAS Access to Hadoop, but i dont know how to configure this product to my existing configuration. Kindly help me

Hi @sarvesh,

 

Thanks for your question! It's best to "Start a Topic" with your question directly on the Data Management Community. That way, a large number of data management experts can see it and chime in.

 

Anna

Version history
Last update:
‎10-27-2015 11:29 AM
Updated by:
Contributors

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Labels
Article Tags