How to Import an Excel File . Using the SAS Import Wizard SAS 9 for Windows. Go to the File menu and select “Import Data”. Choose the file type. Note: Click on the arrow at right of file format box to get a list of file types. Select the appropriate file type, then click “Next”.
Using the SAS Import Wizard
SAS 9 for Windows
Note: Click on the arrow at right of file format box to get a list of
file types. Select the appropriate file type, then click “Next”.
Browse to the folder where you saved the Excel files.
Note: You will see a list of files to select. If you have selected the file type as Excel, you will only see files that have the filename extension “.xls” .After selecting group1.xls, click on “Open”.
Verify your file selection by clicking on “OK”.
The arrow at the right provides a pull-down list of available sheets.
Select the correct sheet, and then click on “Next>”.
The library selected may be WORK, or another library you have
previously defined. Type the SAS data set name in the “Member:” box.
Click on “Finish” to implement the import, or “Next” to save commands
for importing. Use “Next” for homework 1.
If you selected “Next” you may now save SAS statements in a command file to use later. After specifying the file name, click “Finish”. For homework 1, you will save a command file called homework1.sas. Be sure you remember where you save the file, so you can pull it up later.
For homework 1, you should see a NOTE: that says “WORK.group1” was successfully created.
For homework 1, you would open homework1.sas from the Enhanced Program Editor window.
For homework 1, you would open the command file, homework1.sas,
from the folder where you previously saved it.
You will copy and paste the commands for each Excel file.
In the Program Editor Window, highlight the commands to import the data for
all of the 8 groups. Submit by clicking on the running figure icon.
Highlight and submit the data step commands.
Check the SAS log to make sure your commands worked properly.