• Contents
  • About
  • What’s New in SAS Visual Data Builder 6.2
  • Accessibility Features of SAS Visual Data Builder
  • 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
    • Specifying Your Global 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
    • Print
    • Column Headings
  • Glossary


ProductRelease
SAS Visual Data Builder6.2
Type
Usage and Reference
Copyright Date
July 2013
Last Updated
08Jul2013