Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
PIVOT TABLES
AN ENTERPRISE GUIDE
APPROACH
___________________________________________
Judy Orr Lawrence – SAS Training Specialist
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
AGENDA
EG Technique for Pivot Tables
o Summary Tables Task
o Prompts
o Query Builder Prompt Filter
SAS MS Excel Add-In
ENTERPRISE GUIDE SUMMARY TABLES
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
AGENDA
EDMONTON SAS USER GROUP
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
AGENDA
EDMONTON SAS USER GROUP
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
ENTERPRISE
GUIDE
SUMMARY (PIVOT) TABLES
o The Summary Tables Task in
EG can summarize, analyse,
explore and present your data
similar to Excel PIVOT tables
o Adding Prompts to
Summary Tables can make
the task more dynamic
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
ENTERPRISE
GUIDE
SUMMARY TABLES TASK
Drag and drop available variables and statistics into the preview area to construct your summary table
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
ENTERPRISE
GUIDE
SUMMARY REPORT
Add prompts to automate the selection of row, column and analysis variables
Column Variable 1
Analysis Variable 1
Analysis Variable 2
Row Variable 1
Row Variable 2
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
ENTERPRISE
GUIDE
SUMMARY TABLES WITH PROMPTS
Prompt selection list displays at run-time
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
ENTERPRISE
GUIDE
SUMMARY (PIVOT) TABLES
o Construct a Query to filter
based on prompt selected
values
o Choose values from the
prompt list at run-time
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
ENTERPRISE
GUIDE
SUMMARY (PIVOT) TABLES
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
DEMO
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
ENTERPRISE
GUIDE
SUMMARY (PIVOT) TABLES STEPS
Dynamic selection of Column, Row and Analysis Variables
1) Create advanced Summary Table
2) Create Variable Prompts for Column, Row and Analysis variables
3) Modify the Summary Table to include the variable prompts
Dynamic selection of values
1) Create a Query based on source table
2) Create value prompts and add to Query as a filter
3) Change input source for Summary Table to Query result
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
SAS
MS EXCEL ADD-IN
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
ENTERPRISE
GUIDE TRAINING
HTTP://SUPPORT.SAS.COM/TRAINING/CANADA/
Course
Next Calgary
Public Class
SAS Enterprise Guide 1: Querying and Reporting NOV 2 - 3
SAS Enterprise Guide for Experienced SAS Programmers N/A
SAS Enterprise Guide 2: Advanced Tasks and Querying N/A
Creating Reports and Graphs with SAS Enterprise Guide N/A
SAS Enterprise Guide: ANOVA, Regression, and Logistic Regression N/A
Also available as Live-Web & E-Learning
Copyri g ht © 2013, SAS Institut e Inc. All rights r eserved.
QUESTIONS?
