In Version 9.3 of the SAS system the Export Wizard supports both 64-bit and 32-bit Office applications. In order to use the Export Wizard on Windows X64 systems with 32-bit Office, follow these steps.
If you have Office 2003, Office 2007 or 32-bit Office 2010, you should install the SAS PC Files Server. This is documented in usage note 43802. If you have 64-bit Microsoft Office 2010, the PC Files Server is not required when running the 64-bit version of SAS for Windows. To check your version of Office, do the following:
To use the Export Wizard, follow these steps.
In this Windows dialog box select your SAS library libref and then select the member of the library, which is the SAS dataset. Always select the SAS library libref first. In this example we selected the SASHELP library libref and then selected a SAS dataset associated with the libref. After this is complete select the Next button.
A Select Export Type dialog box will appear as shown below:
A Connect to Excel dialog box will appear:
After you have entered in the name of the Excel file click on the OK and proceed to the table selection panel.
This panel allows you to enter the name of the worksheet that you wish to add to your Excel table. If the worksheet already exists you can select the down arrow on the right to select the sheet. If the sheet does not already exist or the table does not already exist then simply type the name of the worksheet and click either Next or Finish. If you click the next button you will have the opportunity for the wizard to create a SAS program for you. If you click Finish you will proceed beyond the next panel and you are done. In this case click the Next and you will see the next panel.
This panel allows you to store the SAS code that the wizard creates which is PROC EXPORT code. Enter the name of the SAS program including the full directory path in the Text entry box. You can also browse to existing SAS export programs if you want to replace an existing one. You can then select the Finish button.
If the workbook already exists you can receive the following message similar to what is shown below:
You can select the OK button to replace the contents of the existing worksheet in your workbook. If you do not want to replace the contents of the worksheet click the Cancel button. Then the process is complete.
|Product Family||Product||System||SAS Release|
|SAS System||SAS/ACCESS Interface to PC Files||Microsoft Windows Server 2003 Datacenter 64-bit Edition||9.2 TS2M3|
|Microsoft Windows Server 2003 Enterprise 64-bit Edition||9.2 TS2M3|
|Microsoft Windows XP 64-bit Edition||9.2 TS2M3|
|Microsoft Windows Server 2003 for x64||9.2 TS2M3|
|Microsoft Windows Server 2008 for x64||9.2 TS2M3|
|Windows 7 Enterprise x64||9.2 TS2M3|
|Windows 7 Home Premium x64||9.2 TS2M3|
|Windows 7 Professional x64||9.2 TS2M3|
|Windows 7 Ultimate x64||9.2 TS2M3|
|Windows Vista for x64||9.2 TS2M3|
|Microsoft® Windows® for x64||9.3 TS1M0|
|Microsoft Windows Server 2003 Datacenter Edition||9.3 TS1M0|
|Microsoft Windows Server 2003 Enterprise Edition||9.3 TS1M0|
|Microsoft Windows Server 2003 Standard Edition||9.3 TS1M0|
|Date Modified:||2012-01-31 14:52:26|
|Date Created:||2012-01-09 17:18:31|