Database Reference
In-Depth Information
Figure 1.4.7: SAS V9.3 Import Wizard Running on a 32-bit Windows XP Operating System.
A sample of the code generated appears below. The code uses a DATAFILE statement to locate the input
file. You use the wizard windows to select this file. It must exist when the Import wizard runs.
PROC IMPORT OUT= WORK.Sample_import
DATAFILE= "F:\My_Excel_File\test_file_1.xls"
DBMS=EXCEL LABEL REPLACE;
RANGE="Shoes_Sheet_1";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
1.4.9 Using the Export / Import Wizards in a 32/64-Bit Mixed Environment
Special requirements exist when SAS, Excel, and your operating system do not all conform to the same
“bit” size for executing software. Many different combinations exist and not all of them are compatible. For
SAS 9.2 TS Level 2M3 and above running on a 64-bit Windows operating system with SAS/ACCESS
Interface to PC Files installed, there are a few minor differences. There is an option to use SAS PC Files
Server to read or write the Excel workbooks. The “Connect to MS Excel” window shown in Figure 1.4.8
will be displayed when either wizard needs to define a connection that uses SAS PC Files Server. This is
required because SAS PC Files Server translates 64-bit data requests into instructions that the 32-bit access
tools can understand. All other screens and output SAS code are generally the same. In both SAS 9.2 and
SAS 9.3, SAS PC Files Server performs this way; however, the two versions of SAS PC Files Server have
the same name and therefore cannot reside on the same computer. They also use different default port
numbers. SAS 9.2 uses the port number 8621, and SAS 9.3 uses the port number 9621. SAS 9.4 can also
operate in these mixed environments.
Search WWH ::
Custom Search