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.
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:
To use the Import Wizard, follow these steps.
Or b) Navigate to the directory and specify a new name for the SAS program file: somename*.sas
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.
|Product Family||Product||System||Product Release||SAS Release|
|SAS System||SAS/ACCESS Interface to PC Files||Microsoft® Windows® for x64||9.3||9.3 TS1M0|
|Microsoft Windows Server 2003 for x64||9.3||9.3 TS1M0|
|Microsoft Windows Server 2008 for x64||9.3||9.3 TS1M0|
|Windows 7 Enterprise x64||9.3||9.3 TS1M0|
|Windows 7 Home Premium 32 bit||9.3||9.3 TS1M0|
|Windows 7 Professional x64||9.3||9.3 TS1M0|
|Windows 7 Ultimate x64||9.3||9.3 TS1M0|
|Windows Vista for x64||9.3||9.3 TS1M0|
|Date Modified:||2012-01-31 14:53:24|
|Date Created:||2011-09-02 16:09:14|