About the Import Data Features

Why Use the Import Data Features?

The import data features enable you to perform self-service, ad hoc data analysis. You can take a Microsoft Excel spreadsheet, delimited text file, or SAS data set from your desktop and transfer it to SAS LASR Analytic Server. Or, you can add the data as a SAS data set, a database table, or SAS Data in HDFS table.
If you have SAS data sets that are stored remotely with a SAS Application Server, you can load them to memory on SAS LASR Analytic Server.
The imported data can be used to enrich existing data that is already available in your SAS deployment. You can import data directly to memory on a SAS LASR Analytic Server.
After the data is in memory, you can explore the data and create visualizations with SAS Visual Analytics Explorer. You can use the powerful reporting capabilities of SAS Visual Analytics Designer.

What is Local Data and Remote Data?

To understand the difference between local data and remote data, consider the following:
local data
is available from the file systems on your desktop. This includes local file systems such as C:\ on Windows machines and paths such as /home/$USER on UNIX machines. Network file systems and shares are also included, such as UNC paths like \\nas\spreadsheets.
remote data
is not available from the file systems on your desktop. You can direct the SAS Application Server to access the data that is available through file systems on the remote machine.

Default Values

The import data features for both local data and remote data are configured with default values to load data to SAS LASR Analytic Server.
If you want to use a library other than the default SAS LASR Analytic Server library, you can specify different values in the Advanced section of the import windows. You can specify a different SAS LASR Analytic Server library, a different library type (for imported local data only, imported remote data is restricted to SAS LASR Analytic Server libraries), and a different location for the table.

Importing Large Local Data Files

When you import local data (spreadsheets, SAS data sets, or delimited text files), memory on the client PC is used to access the data files. For data files that are larger than 1G, make sure that the client machine meets the following requirements:
When using a 64-bit web browser and Adobe Flash Player, the theoretical limit for importing local data files is 2G.
Note: Be aware that importing large local data files can require a long time to transfer and process the data. A progress indicator is provided to help you track the import.

Working with Spreadsheets

Multiple Worksheets

When you import a spreadsheet (from your PC) that has multiple worksheets, the data builder offers to append the worksheets into a single table. SAS no longer supports this feature in SAS Visual Analytics 6.2 because rows with column names on subsequent worksheets cause all of the variables to be read as character data.
If you have more than one worksheet, clear the Append worksheets together check box so that each worksheet is imported as a separate table. You can then create a query for each of the tables to append all table content to a single table and achieve the same outcome.
Tip
When you append to tables, make sure that the column names, data types, and lengths all match.

Special Characters and Missing Values

When you import a spreadsheet that uses special characters or has missing values, keep in mind the following considerations:
  • If the filename or worksheet names use special characters, the import can fail.
    Tip
    Table names are restricted by the VALIDMEMNAME= SAS system option. Column names are restricted by the VALIDVARNAME= SAS system option.
  • If a column has no values, it is skipped during the import process.
  • If a row has missing values, but the cells are formatted (for example, Text), the import can introduce an error. The data builder combines the row with missing values with values from the following row. You can avoid this problem by formatting the cells as General.

Pivot Tables

Importing pivot tables is not supported.