Interactive Reports in SAS® Visual Analytics

Interactive Reports in SAS® Visual Analytics

by Nicole Ball
Released August 2021
Publisher(s): SAS Institute
ISBN: 9781953330550

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Elevate your reports with more user control and interactive elements

Want to create exciting, user-friendly visualizations to bring greater intelligence to your organization? By mastering the full power of SAS Visual Analytics, you can add features that will enhance your reports and bring more depth and insight to your data. Interactive Reports in SAS Visual Analytics: Advanced Features and Customization is for experienced users who want to harness the advanced functionality of Visual Analytics on SAS Viya to create visualizations or augment existing reports. The book is full of real-world examples and step-by-step instructions to help you unlock the full potential of your reports.

In this book, you will learn how to

  • create interactive URL links to external websites
  • use parameters to give the viewer more control
  • add custom graphs and maps
  • execute SAS code using SAS Viya jobs
  • and more!

Table of contents

  1. About This Book
  2. About The Author
  3. Chapter 1: Introduction
    1. Introduction
    2. SAS Visual Analytics
    3. SAS Viya
  4. Chapter 2: Creating Advanced Data Items and Filters
    1. Introduction
    2. Example: Creating a Calculated Item and a Basic Filter
    3. Example: Grouping an Aggregated Measure
    4. Example: Using a Common Filter
    5. Example: Creating a Periodic Aggregated Measure and Adding Time Filters
    6. Example: Creating a Moving Average
    7. Example: Creating a Tabular Aggregated Measure
  5. Chapter 3: Linking to External Websites
    1. Introduction
      1. Step 1: Research
      2. Step 2: Hardcode
      3. Step 3: Parameterize
      4. Step 4: Test
    2. Example: Creating a Static URL Link
    3. Example: Creating a Web Link
      1. Step 1: Research
      2. Step 2: Hardcode
      3. Step 3: Parameterize
      4. Step 4: Test
    4. Example: Searching a Web Page
      1. Step 1: Research
      2. Step 2: Hardcode
      3. Step 3: Parameterize
      4. Step 4: Test
    5. Example: Linking to a File
      1. Step 1: Research
      2. Step 2: Hardcode
      3. Step 3: Parameterize
      4. Step 4: Test
    6. Example: Viewing a Map Location (Additional)
      1. Step 1: Research
      2. Step 2: Hardcode
      3. Step 3: Parameterize
      4. Step 4: Test
    7. Example: Linking to a Parameterized Report (Additional)
      1. Step 1: Research
      2. Step 2: Hardcode
      3. Step 3: Parameterize
      4. Step 4: Test
  6. Chapter 4: Applying Numeric Parameters
    1. Introduction
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    2. Example: Highlighting Values below a Threshold
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    3. Example: Displaying Countries with Orders above a Minimum
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    4. Example: Showing Top Customers
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    5. Example: Grouping Values Based on a Threshold
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    6. Example: Viewing Data for the Next N Years
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
  7. Chapter 5: Using Character Parameters
    1. Introduction
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    2. Example: Searching for a String
      1. Step 1: Create
      2. Step 2: Populate
      3. Steps 3 and 4: Apply and Test
    3. Example: Selecting Characteristics for Indirect Filtering
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    4. Example: Ranking Top or Bottom Values
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
      5. Alternate Solution
    5. Example: Choosing Multiple Measures
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    6. Example: Selecting a Region (Additional)
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
  8. Chapter 6: Working with Date Parameters
    1. Introduction
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    2. Example: Highlighting a Selected Month
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    3. Example: Choosing a Month to Compare Values
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    4. Example: Viewing the Last Five Years of Available Data
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    5. Example: Viewing 10 Years after a Selected Year
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
    6. Example: Displaying Data within a Selected Range
      1. Step 1: Create
      2. Step 2: Populate
      3. Step 3: Apply
      4. Step 4: Test
  9. Chapter 7: Using SAS Graph Builder to Create Custom Graphs
    1. Introduction
      1. Step 1: Choose Graph Elements
      2. Step 2: Lay Out Elements
      3. Step 3: Configure Roles
      4. Step 4: Adjust Appearance
      5. Step 5: Save and Use
    2. Example: Using a Data-Driven Lattice
      1. Step 1: Choose Graph Elements
      2. Step 2: Lay Out Elements
      3. Step 3: Configure Roles
      4. Step 4: Adjust Appearance
      5. Step 5: Save and Use
    3. Example: Syncing Hierarchies
      1. Step 1: Choose Graph Elements
      2. Step 2: Lay Out Elements
      3. Step 3: Configure Roles
      4. Step 4: Adjust Appearance
      5. Step 5: Save and Use
    4. Example: Creating a Chart with Overlays
      1. Step 1: Choose Graph Elements
      2. Step 2: Lay Out Elements
      3. Step 3: Configure Roles
      4. Step 4: Adjust Appearance
      5. Step 5: Save and Use
    5. Example: Using Overlays with a User-Defined Lattice
      1. Step 1: Choose Graph Elements
      2. Step 2: Lay Out Elements
      3. Step 3: Configure Roles
      4. Step 4: Adjust Appearance
      5. Step 5: Save and Use
    6. Example: Building a Custom Map
      1. Step 1: Choose Graph Elements
      2. Step 2: Lay Out Elements
      3. Step 3: Configure Roles
      4. Step 4: Adjust Appearance
      5. Step 5: Save and Use
    7. Example: Building a Custom Map with Polygon Layers
      1. Step 1: Choose Graph Elements
      2. Step 2: Lay Out Elements
      3. Step 3: Configure Roles
      4. Step 4: Adjust Appearance
      5. Step 5: Save and Use
  10. Chapter 8: Using Data-Driven Content to Create Custom Graphs
    1. Introduction
      1. Requirements
      2. Benefits
    2. Example: Using a Circle Packing Plot
    3. Example: Using and Modifying a Sunburst Plot
    4. Example: Creating a Visualization
      1. Displaying Sample Data
      2. Displaying JSON-Formatted Data
    5. Example: Incorporating a Visualization into SAS Visual Analytics
      1. Using Utilities
      2. Creating Dynamic Variables
      3. Setting Up Callback Functions
      4. Initializing and Validating Data
      5. Drawing/Updating the Visualization
      6. Viewing in SAS Visual Analytics
    6. Example: Using a Visualization as the Target of an Action
      1. Using Sample Data when No Data Is Available
      2. Updating the Visualization
      3. Viewing in SAS Visual Analytics
    7. Example: Highlighting Selected Values in the Visualization
      1. Updating CSS Styles
      2. Applying CSS Styles
      3. Viewing in SAS Visual Analytics
    8. Example: Using a Visualization as the Source of an Action
      1. Updating CSS Styles
      2. Deselecting All Elements
      3. Applying CSS Styles to Selected Elements
      4. Viewing in SAS Visual Analytics
    9. Additional Considerations
      1. Handling Axes
      2. Managing Resize Events
      3. Saving URL Mappings
  11. Chapter 9: Working with Jobs in SAS Visual Analytics
    1. Introduction
      1. Step 1: Create the SAS Program
      2. Step 2: Create the Job Definition
      3. Step 3: Create the Job Form
      4. Step 4: Execute and Test
    2. Example: Returning SAS Results
      1. Step 1: Create the SAS Program
      2. Step 2: Create the Job Definition
      3. Step 3: Create the Job Form
      4. Step 4: Execute and Test
    3. Example: Returning SAS Results Using an HTML Form
      1. Step 1: Create the SAS Program
      2. Step 2: Create the Job Definition
      3. Step 3: Create the Job Form
      4. Step 4: Execute and Test
    4. Example: Adding Data to a Table
      1. Step 1: Create the SAS Program
      2. Step 2: Create the Job Definition
      3. Step 3: Create the Job Form
      4. Step 4: Execute and Test
    5. Example: Updating Data in a Table
      1. Step 1: Create the SAS Program
      2. Step 2: Create the Job Definition
      3. Step 3: Create the Job Form
      4. Step 4: Execute and Test
    6. Example: Deleting Data from a Table
      1. Step 1: Create the SAS Program
      2. Step 2: Create the Job Definition
      3. Step 3: Create the Job Form
      4. Step 4: Execute and Test
    7. Additional Considerations
  12. Chapter 10: Sharing Reports
    1. Introduction
    2. Viewing Reports in SAS Visual Analytics
    3. SAS Visual Analytics Apps
    4. SAS Visual Analytics SDK
  13. Appendix A: Loading Geographic Polygon Data to CAS
  14. Appendix B: Working with Data-Driven Content
  15. Appendix C: Additional Resources

Product information

  • Title: Interactive Reports in SAS® Visual Analytics
  • Author(s): Nicole Ball
  • Release date: August 2021
  • Publisher(s): SAS Institute
  • ISBN: 9781953330550