SAS Visual Analytics
offers a variety of ways to bring your data into the SAS Visual Analytics
environment, which enables you to work with your data quickly. The
following list summarizes the different ways:
Import data from a file
When you are creating
data queries, explorations, or reports, you can import data from a
Microsoft Excel spreadsheet, a delimited text file (CSV), or a SAS
data set. After you import the data, it is ready to use.
Autoload
Instead of using your
browser to import a file, you can transfer the file to a directory
that acts as a drop box. A scheduled job imports the file from the
directory. The process requires some setup before autoload can be
used.
Import SAS data set on a server
You can direct the
SAS Application Server to import a SAS data set that is already on
the server. The import process is optimized and you can import large
files when a SAS data set is already on the server.
Import a database table
After providing connection
information, you can transfer a table from a database to a SAS LASR
Analytic Server. Afterward, you can use the in-memory table as is
for reports and explorations, or you can prepare it for analysis with
the data builder.
Note: Your site must license and
configure the related SAS/ACCESS engine to use this feature.
Import tweets from Twitter
After authenticating
with Twitter and providing search criteria, you can import tweets
into memory on a SAS LASR Analytic Server. You can then use the unstructured
data with the explorer. A typical exploration of Twitter data can
perform text analysis to look for patterns and trends in the tweets.
Tip
The self-service import feature
keeps track of your most recently used values for each import type
to simplify repeated import actions. If you clear your browser’s
cache, then your most recently used values are forgotten.