|
" Exchanging data between SAS and Microsoft Excel : "
William E. Benjamin, Jr.
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
615442
|
| Doc. No
|
:
|
dltt
|
| Main Entry
|
:
|
Benjamin, William E., Jr.
|
| Title & Author
|
:
|
Exchanging data between SAS and Microsoft Excel : : tips and techniques to transfer and manage data more efficiently /\ William E. Benjamin, Jr.
|
| Page. NO
|
:
|
xviii, 270 pages :: illustrations ;; 28 cm
|
| ISBN
|
:
|
1607649853
|
|
|
:
|
: 9781607649854
|
| Notes
|
:
|
Includes index.
|
| Contents
|
:
|
Easy data movement between SAS and Microsoft Excel -- Use PROC EXPORT to write SAS data to external files and Excel workbooks -- Use PROC IMPORT to read external data files and Excel Workbooks into SAS -- Using the SAS LIBNAME to process Excel files -- SAS Enterprise Guide methods and examples -- Using JMP to share data with Excel -- SAS Add-In for Microsoft Office (Excel) -- Creating output files with ODS for use by Excel -- Accessing Excel with OLE DB or ODBC application program interfaces (API methods) -- Using PROC SQL to access Excel files -- Using DDE to read and write to Excel workbooks -- Building a system of Excel macros executable by SAS -- Building a system of Microsoft Windows scripts to control Excel macros -- Create an Excel workbookt hat runs SAS programs.
|
| Subject
|
:
|
SAS (Computer file)
|
|
|
:
|
Microsoft Excel (Computer file)
|
| Added Entry
|
:
|
SAS Institute.
|
| |