| Description |
1 online resource (290 pages) : illustrations |
|
text file |
|
29.99 |
| Bibliography |
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 workbook that runs SAS programs. |
| Summary |
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 programmer to transport data between SAS and Excel. The book includes examples that all levels of SAS and Excel users can apply to their everyday programming tasks. Because the book makes no assumptions about the skill levels of either SAS or Excel users, it has a wide-ranging application, providing detailed instructions about how to apply the techniques shown. It contains sections that gather instructional and syntactical information together that are otherwise widely dispersed, and it provides detailed examples about how to apply the software to everyday applications. These examples enable novice users and power developers alike the chance to expand their capabilities and enhance their skillsets. By moving from simple-to-complex applications and examples, the layout of the book allows it to be used as both a training and a reference tool. Excel users and SAS programmers are presented with tools that will assist in the integration of SAS and Excel processes in order to automate reporting and programming interfaces. This enables programming staff to request their own reports or processes and, in turn, support a much larger community. |
| Subject |
SAS (Computer file)
|
|
Microsoft Excel (Computer file)
|
|
SAS (Computer file) |
|
Microsoft Excel (Computer file) |
| Added Author |
Safari, an O'Reilly Media Company.
|
| Added Title |
Tips and techniques to transfer and manage data more efficiently |
| ISBN |
9781629596891 (electronic bk.) |
|
1629596892 (electronic bk.) |
|
1607649853 (Trade Paper) |
|
9781607649854 |
| Standard No. |
9781607649854 |
|
More Resources