1 / 9

SAS Data Integration / SAS Management Console / Platform LSF “The Complete Package”

SAS Data Integration / SAS Management Console / Platform LSF “The Complete Package”. SAS OPUS, June 9 th , 2010. The Real World . 100’s of SAS programs that need to be run monitored or scheduled or A need for an ETL tool that doesn’t require significant programming knowledge

keziah
Download Presentation

SAS Data Integration / SAS Management Console / Platform LSF “The Complete Package”

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAS Data Integration / SAS Management Console / Platform LSF “The Complete Package” SAS OPUS, June 9th, 2010

  2. The Real World • 100’s of SAS programs that need to be run monitored or scheduled or • A need for an ETL tool that doesn’t require significant programming knowledge • A robust tool to manage, organize and develop your data • Minimize the manual running of programs • Monitoring program execution • Take advantage of Parallel processing

  3. Objectives • What is SAS/DI, SMC and Platform LSF? • The Demo will show how all three modules are used together • Demonstrate ways of migrating existing code • Building Flows / Setting Dependencies • Scheduling • Monitoring • Traffic Lighting / Program Control / Logs

  4. SAS DI (Data Integration) • User Interface • ETL Tool • Incorporate existing code • Organize code and processes • Alternative to coding • Metadata (bottle necks, data mappings and transformations)

  5. SMC (SAS Management Console) • Server Manger • Batch Servers, Logs, Spawners • Schedule Manager • Build flows, set dependencies, link to LSF • User Manager • Metadata Manager • Much More

  6. Platform / LSF • Scheduling (LSF is built into SMC) • Process Flow Manager • Monitoring • Traffic lighting, Program Failure, Run-Time Statistics • Schedule • Flow and Program Control • Running / Re-running / Holding / Killing • Logs (date stamped and named)

  7. Demo • Manufacturing • Four Data Sources (flat files) • Order • Parts • Master Sheet (Build Sheet) • Test Details (Results) • Transformations • Reporting

  8. Summary • SAS / DI • Managing SAS programs • Complete SAS Desktop • Using more functionality of SAS/DI • Minimize coding / More Metadata • Future DI releases will convert SAS code into DI objects • SAS Management Console • Dependencies and Scheduling • LSF • Process Flow Manager • Simple and Powerful

  9. Thank You John Ranson Data Solutions and SAS Consultant j.ranson@sympatico.ca 613-293-8326

More Related