• Contents
  • About
  • What’s New in SAS Visual Analytics 6.2
  • 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
    • About the 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
      • Specifying Your Preferences
      • Managing Content on the Home Page
      • Discovering Details Using the Object Inspector on the Home Page
      • Managing Collections
      • Adding Comments to Objects on the Home Page
    • Searching from the SAS Visual Analytics Home Page
      • About 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 Tab
      • Adding a Data Source to a Query
      • Removing a Data Source from a Query
      • Tips for Appending Data
      • 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
    • 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
      • Monitoring Memory Usage
    • Importing Data
      • About the Import Data Features
      • Importing Local Data
      • Importing Remote Data
    • Importing SAS Information Maps
      • About SAS Information Maps
      • Importing a SAS Information Map
      • Limitations and Restrictions
    • Customizing Code
      • Using the Code Tab
      • Preprocess and Postprocess Code
      • Considerations for Manually Editing Code
    • Scheduling Queries
      • About Scheduling Queries
      • Creating Events
      • Exporting Queries as Jobs
      • Additional Scheduling Resources
    • Using the Results Tab
      • About the Results Tab
      • Data Pages
      • Navigate within the Data
      • Find
      • Filter and Sort
      • Export Data
      • Column Headings
  • Exploring Data
    • Overview of SAS Visual Analytics Explorer
      • What Is SAS Visual Analytics Explorer?
      • Accessing the Explorer
      • The Welcome Window
      • Your First Look at the Explorer
    • Specifying Preferences for SAS Visual Analytics Explorer
      • Specifying Global Preferences
      • Specify Preferences That Are Specific to SAS Visual Analytics Explorer
    • Managing Explorations
      • What Is an Exploration?
      • Create a New Exploration
      • Saving Your Exploration
      • Deleting Explorations
      • Exploration Comments
    • 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
      • Creating Calculated Data Items
      • Creating Aggregated Measures
      • Using Distinct Counts
      • Using Percentages of Total
      • Edit a Calculated or Aggregated Data Item
      • Delete a Calculated or Aggregated Data Item
      • Duplicate a 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
      • Ranking Data
      • Working with Visualization Data Ranges and Color Gradients
      • 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 Decision Trees
    • Working with Filters
      • About Filters in SAS Visual Analytics Explorer
      • Working with Basic Filters
      • Working with Advanced Filters
      • Working with Data Source Filters
    • Exporting Content
      • Overview of Exporting Content
      • Export a Visual Exploration as a Report
      • Export a Visual Exploration as a PDF
      • Save a Visualization as an Image File
      • Export Data from a Visualization
      • E-mail a Visual Exploration as a Link
    • Managing Hierarchies
      • Overview of Hierarchies in SAS Visual Analytics Explorer
      • Create a New Hierarchy
      • Derive a Hierarchy from a Date, Time, or Datetime Data Item
      • Create a Hierarchy from a Treemap Visualization
      • Edit a Hierarchy
      • Delete a Hierarchy
    • Performing Data Analysis
      • Overview of Data Analysis in SAS Visual Analytics Explorer
      • Add a Fit Line to an Existing Visualization
      • Add Forecasting to an Existing Visualization
      • Forecast Measures as a New Visualization
      • Apply Scenario Analysis to a Forecast
  • Designing Reports
    • Overview of SAS Visual Analytics Designer
      • About the SAS Visual Analytics Designer
      • Your First Look at the Designer
      • Open Window
      • Search Window
      • Report Themes
    • Specifying Preferences for SAS Visual Analytics Designer
      • Specifying Global and General Preferences
      • Specifying Your Preferences for the Designer
    • Opening Reports
      • Opening Reports in the Designer
      • An Example Report
    • Creating, Saving, E-Mailing, and Printing 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
      • E-mailing a Report
      • Printing 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
      • Using Other Object Types in Reports
      • Duplicating a Report Object
      • 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
      • Working with Data Items 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
      • Working with Basic Filters for Report Objects
      • Working with Advanced Filters for Report Objects
      • Working with Data Item Filters in a Report
    • Working with Interactions
      • Overview of Interactions
      • Creating Interactions
      • Deleting Interactions
      • Creating Links
      • Deleting Links
    • Ranking Values in Reports
      • Overview of Ranking in Reports
      • Adding a New Rank
      • Deleting a Rank
    • 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 the 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 SAS Visual Analytics Viewer
      • Overview of Viewing Reports in SAS Visual Analytics Viewer
      • Opening a Report in the Viewer
      • Viewing Report Object Information
      • Adding Comments to a Report in the Viewer
      • Interacting with Reports in the Viewer
  • Appendix
    • Operators for Calculated Data Items
      • Overview of Operators for Calculated Data Items
      • Numeric (Simple) Operators
      • Comparison Operators
      • Boolean Operators
      • Numeric (Advanced) Operators
      • Date and Time Operators
      • Aggregated Operators
      • Text Operators
    • Conditions and Operators for Filters
    • Data Limits
      • Data Limits for SAS Visual Analytics Explorer
      • High-Cardinality Thresholds for Report Objects
    • Repairing Reports
  • Glossary


ProductRelease
SAS Visual Analytics6.2
Type
Usage and Reference
Copyright Date
June 2013
Last Updated
26Mar2015