leveraging the sas 9.3 platform with sas enterprise guide 5 - opus enterprise guide5.1... · 2012....
TRANSCRIPT
Copyright © 2011, SAS Institute Inc. All rights reserved.
Leveraging the SAS® 9.3 Platform with SAS® Enterprise Guide 5.1 Lina Clover
Director, Research and Development
SAS® Institute, Cary, NC
2
Copyright © 2011, SAS Institute Inc. All rights reserved.
Overview
SAS® 9.3 Platform Features:
Grid Computing
High Performance Procedures
Migrating from earlier versions of SAS® Enterprise Guide
Role Based Customization
3
Copyright © 2011, SAS Institute Inc. All rights reserved.
SAS® Enterprise Guide 5.1
Release Objectives
Leverage the capabilities of SAS® 9.3 platform
Enriched User Experience
Increased productivity
Key SAS® 9.3 Platform leveraged features
SAS® 9.3 Grid Computing
Code Optimization for In-Database
Enhanced SAS 9.3 Stored Process
SAS 9.3 High Performance Analytical Procedures
4
Copyright © 2011, SAS Institute Inc. All rights reserved.
SAS® 9.3 Grid Computing Integration
5
Copyright © 2011, SAS Institute Inc. All rights reserved.
SAS® Enterprise Guide 5.1 Grid Integration
Several methods of connecting to the SAS 9.3 Grid environment
GRIDWORK Library
Project, Code, Task level Grid execution options
Code Analysis tool for Grid Submission
6
Copyright © 2011, SAS Institute Inc. All rights reserved.
Connecting to the SAS® 9.3 Grid Set by administrator via SAS Management Console 9.3
Controlled by end user in SAS Enterprise Guide 5.1 with different connection choices:
Stay Connected, As soon as we connect to a workspace server
Connection made when Task or Program is run
7
Copyright © 2011, SAS Institute Inc. All rights reserved.
Connecting to the GRID
Ability to set Grid Code
Submission/Connections for end-users
8
Copyright © 2011, SAS Institute Inc. All rights reserved.
GRIDWORK Output Library
GRIDWORK Output Library added by
default. Used for Queries and Tasks
Intermediate output.
9
Copyright © 2011, SAS Institute Inc. All rights reserved.
Project Options for Code Submissions
Ability to define the Code Submission
options and gain increased performance
in a grid enabled environment
10
Copyright © 2011, SAS Institute Inc. All rights reserved.
Program/Task Grid Options
Individual Task and Program options for
submission to the Grid
11
Copyright © 2011, SAS Institute Inc. All rights reserved.
Flexibility in Connecting
12
Copyright © 2011, SAS Institute Inc. All rights reserved.
How to know if Job is Executing on the GRID
• Status Window
• Code Log Window
13
Copyright © 2011, SAS Institute Inc. All rights reserved.
Grid Code Analysis
Ability to analyse program code for
submission in a Grid enabled
environment
14
Copyright © 2011, SAS Institute Inc. All rights reserved.
SAS® 9.3 High Performance Procedures
15
Copyright © 2011, SAS Institute Inc. All rights reserved.
High Performance Procedures HPA Procedure run on the In-Memory High
Performance Appliance
Enhanced Editor offers HPA Help and Syntax support
List of procedures supported in 5.1:
The HPCOUNTREG Procedure
The HPDMDB Procedure
The HPDS2 Procedure
The HPFOREST Procedure
The HPLMIXED Procedure
The HPLOGISTIC Procedure
The HPNEURAL Procedure
The HPNLIN Procedure
The HPREDUCE Procedure
The HPREG Procedure
The HPSEVERITY Procedure
The HPSAMPLE Procedure
The HPSUMMARY Procedure
16
Copyright © 2011, SAS Institute Inc. All rights reserved.
Enhanced Editor HPA support
Enhanced tool tip support with web link to
Product Documentation and Samples.
17
Copyright © 2011, SAS Institute Inc. All rights reserved.
Migration of SAS® Enterprise Guide Projects from SAS® 9.2 to SAS® 9.3
18
Copyright © 2011, SAS Institute Inc. All rights reserved.
Migrating SAS Enterprise Guide Project files SAS Enterprise Guide 5.1 works with both SAS 9.2 and
9.3
Lazy Project Upgrade:
Opening SAS Enterprise Guide 4.1, 4.2, or 4.3 projects in SAS Enterprise Guide 5.1 automatically converts the project to 5.1 file format
Project Maintenance
Change references within a single project.
Types of references: Servers, Libraries, Data items, Stored processes ,Information maps, OLAP servers ,OLAP catalogs
Migration Wizard tool
Migration of multiple files
Can Import migration mapping from BI Migration Process
Creates a MigrationBackup copies of migrated files
19
Copyright © 2011, SAS Institute Inc. All rights reserved.
Project Maintenance
Invoke Project Maintenance from within
SAS Enterprise Guide
20
Copyright © 2011, SAS Institute Inc. All rights reserved.
Migrating Multiple Files
MigrationWizard.exe installed in same file
directory location as SAS Enterprise
Guide executable SEGuide.exe
21
Copyright © 2011, SAS Institute Inc. All rights reserved.
Mapping Project References
Mapping for Servers, Libraries, Data
items, Stored processes ,Information
maps, OLAP servers ,OLAP catalogs for
22
Copyright © 2011, SAS Institute Inc. All rights reserved.
Migration Options
Options for backups, logging and
mapping verification
23
Copyright © 2011, SAS Institute Inc. All rights reserved.
Role Based Administration
24
Copyright © 2011, SAS Institute Inc. All rights reserved.
Default Roles for SAS® Enterprise Guide
Analysis Role
Basic data analysis, reporting, and other capabilities
Programming Role
SAS programming, stored process authoring, and other capabilities
OLAP Role
Viewing OLAP cubes in the OLAP Analyzer and other capabilities
Advanced Role
All capabilities in SAS Enterprise Guide
25
Copyright © 2011, SAS Institute Inc. All rights reserved.
Default Roles
26
Copyright © 2011, SAS Institute Inc. All rights reserved.
Setting User’s Capabilities within a Role
Administrator can change default role
capabilities
27
Copyright © 2011, SAS Institute Inc. All rights reserved.
Conclusion
SAS Enterprise Guide 5.1 offers numerous SAS 9.3 Platform capabilities ranging from SAS Gird Computing to new High Performance Procedures.
Transitioning SAS Enterprise Guide projects from previous versions of SAS to SAS 9.3 is made easier with flexible migration tools.
Enhanced administration settings available for IT to customize the SAS Enterprise Guide user environment and code execution
28
Copyright © 2011, SAS Institute Inc. All rights reserved.
More information
Contact your account team for consultation
Not sure who to contact? Check www.sas.com/contact for list of global phone and Email resources
Technical questions? [email protected]
Thank you for your time