Database Reference
In-Depth Information
Argument / (Alias)
Required
Definition of the Function of the Argument
DBMS
No
See the examples below for specific options
relating to the individual DBMS identifier
values
.
Options are based upon the file types being
processed and direct the actions of the SAS
PROC EXPORT features.
LABEL
/(DBLABEL)
No
When either “LABEL” or “DBLABEL” is
present, then SAS will use the SAS variable's
label value as the column title in row one of the
output Excel file.
REPLACE
No
When “REPLACE” is present, then SAS will
overwrite an existing output file. A new file will
be created if the requested file name does not
exist.
2.4 Data Access Methods for Excel Files Supported by PROC EXPORT
The data access methods listed in Figure 2.1 are used to create output files Excel has the ability to read.
When you select a DBMS mode, it determines which utility will be used to process the SAS dataset to
create an output file. The output file may be a text file or an Excel spreadsheet. See the documents listed
above for more details about the SAS software version you are using. Some of these data access methods
(the DBMS=modes) require SAS/ACCESS Interface to PC Files software to function. You must have
SAS/ACCESS Interface to PC Files licensed before you can export files directly to Microsoft Excel
workbooks. Some features relating to Microsoft Excel 2007, Excel 2010, and Excel 2013 when using
Microsoft Windows, LINUX, and UNIX operating systems may not be available in SAS versions prior to
the third maintenance release of SAS 9.2. Because the number of SAS, Excel, and operating system
versions is large, I once again suggest that you refer to
SAS/ACCESS Interface to PC Files: Reference
for
the version of SAS that you have installed.
Here would also be a good place to introduce the SAS PC Files Server. This is a software tool used by SAS
to convert data when the computing environment you are using includes hardware and software of different
“bit” configurations. For a human like you and me, this would be equivalent to learning a new language
with more letters and more complex words. For a computer, this change is from processing data units with
32-bits (1s and 0s) to using 64-bits. These are the elements that are changing: SAS software can be either
32- or 64-bit software, Excel programs can be 32- or 64-bit software, the computer operating system can be
32- or 64- bit software, or the computer can be 32- or 64-bit hardware. Here I will say contact your IT
Department. The SAS PC Files Server helps clear up some of the confusion.
Figure 2.1: DBMS Output Formats Generated.
DBMS
Identifier
SAS/ACCESS
Interface to PC Files
Required
General Description of the DBMS Output File
CSV
N
Text file with a comma delimiter
TAB
N
Text file with a tab delimiter
DLM
N
Text file with a user defined delimiter
EXCEL
Y
Excel workbook referenced by a LIBNAME
EXCELCS
Y
Excel workbook referenced by using the SAS PC Files
Server
EXCEL4
Y
Excel workbook
EXCEL5
Y
Excel workbook
Search WWH ::
Custom Search