![Page 1: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/1.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Getting started with SAS enterprise guide
![Page 2: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/2.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Barrie Neill
Host
![Page 3: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/3.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Peter Hobart
Presenter
![Page 4: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/4.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Managing the webinar
• Control bar opened with the white arrow in the orange box
![Page 5: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/5.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
What is your experience with SAS Enterprise Guide?
![Page 6: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/6.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Getting started with sas enterprise guideAGENDA
• What is SAS Enterprise Guide?
• An overview of the interface
• Opening a dataset or table
• Joining tables
• Filtering and Querying
• Reporting
• Resources
![Page 7: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/7.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Are you a SAS Programmer?
![Page 8: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/8.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
What is SAS enterprise guide?
• Enterprise Guide is an easy to use tool for
investigating your data
• It is also a powerful programming
environment
• It can create and launch Stored Processes
• ….It's a code generator….
![Page 9: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/9.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
What version of SAS Enterprise Guide are you on?
![Page 10: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/10.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Key FeaturesSAS / Enterprise Guide versions
4.1 4.2 4.3 5.1 6.1 7.1
Split code window / project view Y Y Y Y Y Y
Stored process creation Y Y Y Y Y Y
SAS Report layout builder Y Y Y Y Y Y
Post - it style project notes Y Y Y Y Y Y
Conditional execution N Y Y Y Y Y
Code Autocomplete / syntax hints N N Y Y Y Y
SAS Code analyser (*enhanced) N N Y Y Y* Y*
Data Explorer N N N Y Y Y
Support for parallel execution N N N Y Y Y
Export data as an XLSX file N N N Y Y Y
Code re-layout on Ctrl+i N N N Y Y Y
Log summary window N N N N Y Y
Code Versioning & Data Step Debugger N N N N N Y
Bitness 32 32 32 32/64 32/64 32/64
![Page 11: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/11.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Compatibility MatrixSAS / Enterprise Guide versions
4.1 4.2 4.3 5.1 6.1 7.1
9.1 Y N N N N N
9.2 L Y Y Y Y* Y
9.3 N N Y* Y Y Y
9.4 N N N Y* Y Y
http://supportprod.unx.sas.com/kb/34/960.html
L : Limited support (Enterprise Guide and SAS on same host, no metadata)* With appropriate hotfixes appliedNote SAS 9.4 is not supported on Windows XP
![Page 12: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/12.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Exploring the interface
![Page 13: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/13.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Using the interface
• Interface layout
• Getting data
• Preparing data
• Running a Task
• Mix and match tasks and coding
![Page 14: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/14.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
InterfaceMain areas
Project Tree
TasksSAS FoldersServersPromptsData Explorations
Main work area:
- Process flow- Data grid
Detailed Task Status
Menu / Toolbar Search
Status Line
![Page 15: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/15.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
InterfaceExtensively customisable
• Windows
• Open / Close
• Resize
• Dock left or right
• Autohide
• Choose which other items to display using the View menu
• Detailed Task Status
• Project Log
• Log Summary
![Page 16: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/16.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Questions?
![Page 17: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/17.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Opening a data set or a table
![Page 18: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/18.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Using a taskFirst, get some data
• Adding data to a project - multiple methods
• File > Open Data (SAS tables)
• File > Import (XLS / XLSX / MDB / ACCDB / TXT / CSV /ASC / HTM etc…)
• View>Servers… and navigate to the required item
• Run SAS code to read or create data
• Tasks > Data > Download
• File > New > Data and type values into a new table
• By default, the table is added to the project and a window displays the first few rows
![Page 19: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/19.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Using an Enterprise Guide TaskDemonstration
![Page 20: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/20.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Using a taskNow choose a task
• Grouped by category under the Task menu
• Or select some data and right - click to choose an action
• Or use the task list window (bottom - left by default)
• (Or use code..)
![Page 21: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/21.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Any questions?
![Page 22: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/22.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Joining tables
![Page 23: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/23.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Questions?
![Page 24: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/24.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Filtering and querying
![Page 25: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/25.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Questions?
![Page 26: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/26.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Reporting on data
![Page 27: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/27.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Using a TaskOne - way frequencies
• Assign columns to the required roles
• As soon as the task has enough information the Run button is enabled
![Page 28: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/28.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Using a taskOne - way frequencies
• Results are added to the project and displayed
• Output types and styles can be customised
![Page 29: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/29.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
What document types do you use for reporting?
![Page 30: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/30.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Questions?
![Page 31: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/31.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Mix and Match: Exploding a pie segmentDemonstration
![Page 32: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/32.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Mix and Match
• Use SAS Enterprise Guide as an aid in rapid application development
• For any task that is unfamiliar / used infrequently• Use the tasks and wizards to quickly get close to the desired result
• Explore options without having to look up syntax
• Then modify / extend the generated code as needed
![Page 33: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/33.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Pie Chart taskMany options - but not one to explode a segment
![Page 34: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/34.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Initial result
![Page 35: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/35.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
When you try editing the code this prompt appears
![Page 36: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/36.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Modify the new version of the code as needed
The explode= option specifies values we want to pull out from the pie
![Page 37: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/37.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
The final result
![Page 38: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/38.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Questions?
![Page 39: Getting started with SAS enterprise guide€¦ · Mix and Match •Use SAS Enterprise Guide as an aid in rapid application development •For any task that is unfamiliar / used infrequently](https://reader035.vdocuments.us/reader035/viewer/2022081517/5ed34b85433b4f046e22a483/html5/thumbnails/39.jpg)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
ResourcesMore information and sources of help
SAS customer loyalty
http://www.sas.com/en_gb/customer-loyalty.html
Links to hundreds of free resources
White paper on ODS Excel
http://support.sas.com/resources/papers/proceedings14/SAS177-2014.pdf
ODS focus area on support.sas.com
http://support.sas.com/rnd/base/ods/index.html
Tip sheets, white papers, more..