To import data from
a file:
-
Select
File
Import Data and then select a file.
-
On the
Import
Data window, specify the following input file parameters:
DelimiterApplies to CSV
Select the delimiter
that is used in the text file to import. You can also specify a single
character to use as a user-defined delimiter.
Select worksheetApplies
to XLS
Select the worksheet
to import as a table.
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.
Trim spaces
Select this check box
to remove leading and trailing spaces from character variables.
Data records begin on row
The default is to import
records from the first row. If you select Use data in
the first row as SAS variable names, then this field
increments to 2.
-
Specify the output table
settings:
|
|
|
|
|
Specify a table name
for the imported data.
|
|
|
Click the  button and select the library to import the data
to.
If
you select a SAS LASR Analytic Server library, then you can
explore the data immediately after importing it.
|
|
|
Click the  button and select a metadata folder. The imported
data is registered as a table in the specified location.
|
-
If the SAS Folders tree
is open to the folder that was specified in the
Location field,
then close and open the folder or click
to see the table.