Usage Note 44197: Using the Import Wizard with the SAS® PC Files Server on Windows X64 systems in SAS® 9.3
In SAS 9.3, the Import Wizard supports both 64-bit Office applications and 32-bit Office applications. In order to use the Wizard, follow these steps.
Section 1: Checking your version of Microsoft Office
If you have Office 2003 or Office 2007, you should install the SAS PC Files Server. This is documented in usage note 43802. These versions are 32-bit. If you have 64-bit Microsoft Office 2010, the PC Files Server is not required if you are running the 64-bit version of SAS for Windows. To check your version of Office, do the following:
In Office 2010, click the File menu.
Click Help, which is on the left.
The version of Excel is shown under About Excel on the right.
If you have 32-bit Excel and the SAS PC Files Server is installed, proceed to "Section 2: Using the Wizard with the SAS PC Files Server and 32-bit Office."
If you have 64-bit Excel and you are running SAS for Windows, stop here. You do not need the SAS PC Files Server.
Section 2: Using the Import Wizard with the SAS PC Files Server and 32-bit version of Microsoft Office
To use the Import Wizard, follow these steps.
Select File ►Import Data.
Do not select Microsoft Excel Workbook. This is for 64-bit Office, not 32-bit Office.
Select Microsoft Excel on PC Files Server, as shown in this image, and click Next.
The Connect to Ms Excel dialog box appears. Click Browse.
The following menu appears. From the Files of type drop-down list, select the file extension of the Excel file. If you do not know the extension type, select All Files.
Navigate to the location of the Excel file and click the Open button.
The Import Wizard - Select table dialog box gives you a drop-down list of worksheets or tables to read. From the drop-down list, select the table that you want to read.
Clicking the Options button brings up the Excel Options dialog box. These options are set by default. If you have datetime data in a column of your workbook (such as 01jan2008:08:13:22), deselect the Use DATE.format for a Date/Time column check box. Otherwise, you get only the date.
You can also adjust the 1024 setting to capture column text lengths in your spreadsheet that are longer than 1024 characters. The maximum value is 32,767 characters. Click OK to close the Excel Options dialog box. Then, back on the Import Wizard - Select table dialog box, click Next.
Now select the location to store the Excel worksheet in a SAS data set. Choose the SAS libref in which you want to store the SAS data set. If you want the data set to be removed after you exit SAS, select the default WORK library. If you want the data set to remain after you exit SAS, then select another library, such as SASUSER. If the SAS data set does not exist, enter the name in the Member field of the panel. If the SAS data set already exists, choose the member to replace and click Next.
The next dialog box, Import Wizard - Create SAS statements, enables you to create your own SAS PROC IMPORT code. You can do either of two things: a) Enter the full location of where you want to store the SAS code as shown in the following image:
Or b) Navigate to the directory and specify a new name for the SAS program file: somename*.sas
Then you can use the PROC IMPORT code in your programs without using the wizard.
Then click Finish and you are done.
In the log, you see a message similar to the following:
NOTE: WORK.MYSASDATA data set was successfully created.
NOTE: The data set WORK.MYSASDATA has 175 observations and 22 variables.
Operating System and Release Information
SAS/ACCESS Interface to PC Files
Microsoft® Windows® for x64
Microsoft Windows Server 2003 for x64
Microsoft Windows Server 2008 for x64
Windows 7 Enterprise x64
Windows 7 Home Premium 32 bit
Windows 7 Professional x64
Windows 7 Ultimate x64
Windows Vista for x64
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
This usage note details how to use the Import Wizard on X64 systems in SAS 9.3. The choices that are made depend on the version of Office and whether it is 32-bit or 64-bit.