What’s New in SAS Visual Data Builder 6.2

Enhancements to Working with Data

  • You can use in-memory tables from SAS LASR Analytic Server as input tables for a query.
  • You can join tables from more than one library.
  • You can import a SAS Information Map into a query. Maps that are based on tables are supported. Maps based on OLAP cubes are not supported.
  • For deployments that use Greenplum Data Computing Appliance, the generated SAS statements use the HPDS2 procedure to distribute data for staging tables. This enhancement is an efficient method for distributing data.

Enhancements to Importing Data

The import local data feature is enhanced as follows:
  • You can preview a spreadsheet or delimited file before you import it.
  • When you import a spreadsheet, you can also specify one or more worksheets to import. You can append the worksheets and import them as a single table or as individual tables.
  • When you import a delimited file, you can specify the encoding to use for reading the file.
  • You can import a SAS data set from your desktop.
  • You can import files up to 2 GB in size. The application reads the data in blocks and transfers them to the server.
You can import remote data by browsing for SAS data sets that are available to your SAS Application Server and load them to SAS LASR Analytic Server.

Enhancements to Customizing Code

  • You can add preprocessing and postprocessing SAS statements to your query.
  • You can view all the code for the query, including the SQL procedure statements and LIBNAME statements.
  • You can customize the code for the entire query when you unlock the code. In the previous release, you could modify the SELECT statement only.