Information Technology Reference
In-Depth Information
Checking the line number
containing the column heads
requires that you specify which
line it is in the box on the far
right of the screen.
Figure B11
The
Import Data
window.
When you have selected
Local Computer
, you will see the standard
Windows
Open File
screen. Navigate to the Excel file containing the data
that you have saved. Make sure the
Files of type
panel shows either
All
Files
or those with the
.xls
(Microsoft Excel 1997-2003) extension.
Selecting the Excel file results in an
Open Tables
window that asks
for the Excel sheet number. You probably used Sheet 1 in the Excel file
so double click that. You are then presented with an
Import Data
SAS
Enterprise Guide
window such as the window shown in Figure B11.
Note that in the far left panel are tabs indicating the information about
the data file that you might need to address. By default, the active tab is
Region to import
and is the only tab we need to deal with in this example.
Be sure that
Specify line touse as columnheadings
is checked (you should
always use headings in your Excel file to name your variables) and that the
value of
1
appears in the line number specification box at the far right of
the window. Then check the box corresponding to
Import entire file
and
click
Run
.
To “ r u n ” t h e
Import Data
routine means that
SAS Enterprise Guide
will transform the data file into the SAS format and will bring it into
a project. The screen that appears once the run has been successfully
completed is an
SAS Enterprise Guide
window shown in Figure B12.
There are two tabs available in this window, and they are located
just above the data file. Note that this window is associated with the