Contents
About
What’s New in SAS Visual Analytics 6.1
Accessibility Features of SAS Visual Analytics
About This Book
Introduction to SAS Visual Analytics
About SAS Visual Analytics
What Is SAS Visual Analytics?
Benefits of Using SAS Visual Analytics
How Does SAS Visual Analytics Work?
Accessing SAS Visual Analytics
Overview of SAS Visual Analytics Capabilities
Log On to SAS Visual Analytics
Log Off from SAS Visual Analytics
SAS Visual Analytics Interface
Your First Look at the SAS Visual Analytics Home Page
About the Availability of Menus and Menu Selections in SAS Visual Analytics
Managing Your Content on the Home Page
Specifying Your Preferences
Discovering Details Using the Object Inspector on the Home Page
Adding Comments to Reports and Explorations on the Home Page
Searching for Reports, Explorations, and Stored Processes from the SAS Visual Analytics Home Page
Searching from the Home Page
Refining Your Search Results
Preparing Data
Overview of SAS Visual Data Builder
What Is SAS Visual Data Builder?
Accessing SAS Visual Data Builder
Your First Look at SAS Visual Data Builder
About Access to DBMS Data
Working with User-Defined Formats
Specifying Preferences for SAS Visual Data Builder
Specifying Global and General Preferences
Specifying Your Preferences for SAS Visual Data Builder
Designing Queries
What Is a Query?
About Designing Queries
Creating a New Query
Saving Your Query
Saving a Query as a New Query
Using the Design View
Adding a Data Source to a Query
Removing a Data Source from a Query
Specifying Properties for a Query
Working with Tables
Source Tables
Specifying Properties for a Source Table
Output Tables
Staging Tables
Output and Staging Table Interactions
Clearing Output Information
Working with Columns
Adding Columns to a Query
Removing Columns
Specifying a Column Expression
Specifying Aggregations
Removing All Aggregations
Using Group By Variables
Using the Auto-Aggregate Functions
Using the Pivot By Feature
Working with Query Filters
About Filtering Data
Specifying a WHERE Clause
Specifying a HAVING Clause
Best Practices for Filters
Working with Joins
About Joins
How Does the Automatic Join Feature Work?
Adding a Join
Removing a Join
Managing Joins in a Query
Best Practices for Managing Joins
Working with SAS LASR Analytic Server
Understanding Co-Located Data
Using SAS Data in HDFS Libraries
Using SAS LASR Analytic Server Libraries
Partitioning Tables
Exploring Results
Loading a Table to SAS LASR Analytic Server
Importing Data
About the Import Data Feature
Importing Data
Editing Code
Using the Code View
Considerations for Manually Editing Code
Scheduling Queries
About Scheduling Queries
Creating Events
Exporting Queries as Jobs
Additional Scheduling Resources
Using the Results View
About the Results View
Data Pages
Navigate within the Data
Find
Filter and Sort
Export Data
Print
Column Headings
Exploring Data
Overview of SAS Visual Analytics Explorer
What Is SAS Visual Analytics Explorer?
Accessing SAS Visual Analytics Explorer
The Welcome Window
Your First Look at SAS Visual Analytics Explorer
Specifying Preferences for SAS Visual Analytics Explorer
Specifying Global Preferences
Specify Preferences That Are Specific to SAS Visual Analytics Explorer
Managing Data
Managing Data Properties
Open a Different Data Source as a New Exploration
Change the Data Source for Your Exploration
Refresh Your Data Source
Using Distinct Counts
Creating Calculated Data Items
Create a Duplicate Data Item
Delete a Calculated, Duplicate, or Derived Data Item
Define a Geography Data Item
Working with Visualizations
Overview of Visualizations
Working with Visualizations
Manage Visualization Comments
Managing Visualization Data Roles
Working with Filters
Working with Data Brushing
Working with Automatic Charts
Working with Bar Charts
Working with Line Charts
Working with Tables
Working with Crosstabs
Working with Scatter Plots
Working with Bubble Plots
Working with Histograms
Working with Box Plots
Working with Heat Maps
Working with Geo Maps
Working with Treemaps
Working with Correlation Matrices
Working with Visualization Filters
About Filters
Create a Filter
Create a Filter from a Data Selection
Edit a Filter By Using Visual Filter Controls
Edit a Filter By Using the Edit Filter Window
Set the Scope of a Filter (Global or Local)
Delete a Filter
Reset a Filter
Exporting Data
Overview of Exporting Data
Export a Visual Exploration as a Report
Export a Visual Exploration as a PDF
Save a Visualization as an Image File
E-mail a Visual Exploration as a Link
Managing Hierarchies
Overview of Hierarchies in SAS Visual Analytics Explorer
Create a New Hierarchy
Edit a Hierarchy
Delete a Hierarchy
Managing Explorations
What Is an Exploration?
Create a New Exploration
Saving Your Exploration
Deleting Explorations
Exploration Comments
Performing Data Analysis
Overview of Data Analysis in SAS Visual Explorer
Add a Fit Line to an Existing Visualization
Add Forecasting to an Existing Visualization
Correlate Measures as a New Visualization
Forecast Measures as a New Visualization
Designing Reports
Overview of SAS Visual Analytics Designer
About SAS Visual Analytics Designer
Your First Look at SAS Visual Analytics Designer
Open Window
Search Window
Specifying Preferences for SAS Visual Analytics Designer
Specifying Global and General Preferences
Specifying Your Preferences for SAS Visual Analytics Designer
Opening Reports
Opening Reports in SAS Visual Analytics Designer
An Example Report
Creating and Saving Reports
About Reports
Creating a New Report
Specify Report Properties
Choosing a Report Layout
Basing a New Report on Report Objects Imported from One or More Existing Reports
Saving a Report
Displaying Results Using Report Objects
Using Tables, Graphs, Gauges, Controls, and Other Report Objects
Using Tables to Display Results
Using Graphs to Display Results
Using Gauges to Display Results
Using Controls to Display Results
Adding Other Objects to Reports
Adding Comments to Reports
Selecting Data for Reports
Overview of Data Sources and Data Items
Adding a Data Source or Data Sources
Refreshing a Data Source for a Report
Removing a Data Source from a Report
Changing a Data Source in a Report
Using Data Items in a Report
Working with Data Item Filters in a Report
Working with Hierarchies in a Report
Working with Calculated Data Items in Reports
Viewing Measure Details
Showing or Hiding Data Items
Modifying Data Role Assignments in Report Objects
Removing Data Role Assignments from Report Objects
Sorting Data Items in Reports
How Sorting Can Help with Analysis
Sorting Data in a List Table
Sorting Data in a Crosstab
Sorting Data in a Graph
Working with Display Rules for Reports
Overview of Display Rules
Adding Report-Level Display Rules
Adding Table-Level Display Rules
Adding Graph-Level Display Rules
Adding Display Rules to a Gauge
Working with Report Filters
About Report Filters
Creating a Filter for a Report Object
Editing a Filter Using the Edit Filter Window
Removing a Filter for a Report Object
Working with Interactions
Overview of Interactions
Creating Interactions
Deleting Interactions
Maintaining Multi-Section Reports
Overview of Report Sections
Adding a Section to a Report
Renaming a Report Section
Deleting a Section from a Report
Moving or Dragging a Report Object to Another Section
Exporting Data from Report Objects
Overview of Exporting from SAS Visual Analytics Designer
Exporting Data from Report Objects
Viewing Reports
Viewing Reports on a Mobile Device
Opening the App for the First Time
Add a Server Connection for iPad
Add a Server Connection for Android
Viewing Reports in the SAS Visual Analytics Viewer
Overview of Viewing Reports in SAS Visual Analytics Viewer
Opening a Report in SAS Visual Analytics Viewer
Adding Comments to a Report in SAS Visual Analytics Viewer
Managing the Environment
Overview of SAS Visual Analytics Administrator
About SAS Visual Analytics Administrator
Your First Look at SAS Visual Analytics Administrator
Accessing SAS Visual Analytics Administrator
Specifying Your Preferences for SAS Visual Analytics Administrator
What Does the LASR Tables Tab Show?
A Quick Tour of the LASR Tables Tab
A Quick Tour of the Folders Tab
Managing SAS LASR Analytic Server Connections
About SAS LASR Analytic Servers in the Metadata
Working with SAS LASR Analytic Server Connections
Working with Tables
How Are Jobs Created and Used?
About Loading Data to the SAS LASR Analytic Server
Working with Tables in the LASR Tables Tab
Working with Tables in the Folders Window
About Adding Data to Co-located Storage
Loading Data to a Co-Located Provider
Loading Data to a Data Server
Working with HDFS
What Is the HDFS Content Explorer?
What Can I Do with the HDFS Content Explorer?
Navigating HDFS Folders
Deleting a Table from HDFS
Viewing HDFS System Properties
Viewing Basic File Information
Viewing Table Information
Viewing Block Information
Monitoring Resources
Utilization History
Real-Time View
Monitoring Processes
Viewing Memory and CPU Utilization
CPU and Memory Utilization by Instance
Managing Mobile Devices
Features in SAS Visual Analytics Mobile Devices Administration
Managing Mobile Devices
Setting Permissions
About Managing Security for Folders and Tables
Introduction to Permissions
The Authorization Page
Add an Explicit Grant or Denial
Row-level Security for LASR Tables
Permission Origins
Appendix
Operators for Calculated Data Items
Data Limits for SAS Visual Analytics Explorer
Glossary
Product
Release
SAS Visual Analytics
6.1
Type
Usage and Reference
Copyright Date
December 2012
Last Updated
29Apr2013