As many of us know, many users prefer their SAS data in MS® Excel spreadsheet. And many of us also may know there are numerous ways to deliver it from SAS to Excel spreadsheet. The various methods depend on your OS and whether you have SAS/Access or some other SAS software licenses and end user’s technical ability. Here are few methods…and the list is not comprehensive at all. • Export/Import Wizards
- Proc export/Import
- Data step
- Proc Print
- Proc Printto
- SAS libname to EXCEL
- ODS CSV /ODS CSVALL /ODS CSBYLINE
- ODS HTML • ODS Markup
- DDE
- ODBC
- OLE DB
- SAS Intr/Net
- %ds2csv macro
- SAS Add-in for MS Office (AMO)
This presentation focuses on using the SAS® AMO, one of the client-tool in SAS® Enterprise BI bundle, and SAS® stored processes. Based on Family Care Inc.’s user responses, they like this method because the SAS reports are easy to locate, easy to execute and easy to work with the data once the SAS data is in their familiar territory –in MS® Excel! Lastly and equally important, the user does not need to have any SAS skill at all.
As a developer and SAS administrator, this method is easy to administer because the code for the stored process is maintained on a SAS server and its security is managed by SAS® Metadata Server. And because the reports are parameterized, it allows many users to customize the same report to their individual needs, without any additional administration effort.
conference:
