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.
Copyright © SAS Institute Inc. All rights reserved.