tips and techniques to transfer and manage data more efficiently /
First Statement of Responsibility
William E. Benjamin, Jr.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
xviii, 270 pages :
Other Physical Details
illustrations ;
Dimensions
28 cm
GENERAL NOTES
Text of Note
Includes index.
CONTENTS NOTE
Text of Note
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.