Importing Local Data

To import data from a spreadsheet, delimited text file, or SAS data set, follow these steps:

Select FileImport Local Data, and then select the data file.
In the Import Local Data window, specify the following input file parameters:

Note: For SAS data sets, there are no parameters to specify.

Delimiter^{Applies to CSV}

Select the delimiter that is used in the text file to import. You can specify a single character to use as a user-defined delimiter.

Select worksheet^{Applies
to XLS}

Select All or the check boxes for the worksheets to import. For more information, see Working with Spreadsheets.

Use data in the first row as SAS variable names

Select this check box when the worksheet has the variable names in the first row.

When importing spreadsheets, if only one worksheet is used, or you are not appending the worksheets, the variable names are retrieved from the first non-empty row. When you are appending worksheets, the variable names are retrieved from the first non-empty row in the first worksheet that you select for import.

Trim spaces

Select this check box to remove leading spaces and trailing spaces from character variables.

Data records begin on row

The default is to import data records from the first row. If you select Use data in the first row as SAS variable names, then this value increments to 2. This check box is disabled if you import a spreadsheet and select multiple worksheets.

Encoding^{Applies to CSV}

Select the encoding of the file. If you are importing UTF-8 or UTF-16 data, make sure the SAS Application Server is a Unicode server or that all of the file contents can be successfully transcoded to the encoding of the SAS Application Server. If you are importing a UTF-16 (big-endian or little-endian) file, make sure it contains a BOM (byte-order mark).
(Optional) Click Preview to view the data. You can preview delimited text files and spreadsheets only.

Preview displays up to 500 rows from the first 2 MB of the file.

Review the Advanced properties, and adjust them if needed.

Field	Description
Name	Specify a table name for the imported data.
Location	Click , and select a metadata folder. The imported data is registered as a table in the specified location.
Library	Click , and select the library in which to import the data. If you select the Show SAS LASR Analytic Server libraries only check box, then the list is filtered to show those libraries only.

Click OK.