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

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Benjamin, William E.
Autor Corporativo: Safari, an O'Reilly Media Company
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Cary, NC : SAS Institute, [2015]
Edición:First edition.
Temas:
SAS (Computer file)
Microsoft Excel (Computer file)
MATHEMATICS > Applied.
MATHEMATICS > Probability & Statistics > General.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares