Exchanging data between SAS® and Microsoft Excel : tips and techniques to transfer and manage data more efficiently /

Master simple-to-complex techniques for transporting and managing data between SAS and Excel William Benjamin's Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently describes many of the options and methods that enable a SAS programme...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Benjamin, William E.
Corporate Author: Safari, an O'Reilly Media Company
Format: Electronic eBook
Language:Inglés
Published: Cary, NC : SAS Institute, [2015]
Edition:First edition.
Subjects:
SAS (Computer file)
Microsoft Excel (Computer file)
MATHEMATICS > Applied.
MATHEMATICS > Probability & Statistics > General.
Online Access:Texto completo (Requiere registro previo con correo institucional)
Table of 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 workbook that runs SAS programs.

Similar Items