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...

Description complète

Détails bibliographiques
Cote:Libro Electrónico
Auteur principal: Benjamin, William E.
Collectivité auteur: Safari, an O'Reilly Media Company
Format: Électronique eBook
Langue:Inglés
Publié: Cary, NC : SAS Institute, [2015]
Édition:First edition.
Sujets:
SAS (Computer file)
Microsoft Excel (Computer file)
MATHEMATICS > Applied.
MATHEMATICS > Probability & Statistics > General.
Accès en ligne:Texto completo (Requiere registro previo con correo institucional)
Table des matières:
  • 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.

Documents similaires