office suites and sas institute Resources

Sponsored White Papers, Webcasts, and Downloads

ePolicy Best Practices: A Business Guide to Clean & Compliant, Safe & Secure E-Mail and Web Usage and Content
The Online Shadow Economy: A Billion Dollar Market For Malware Authors

ZDNet Resources

I Want It All - Recovering Variable Labels When Importing Data From Microsoft Access: SAS/ACCESS offers a number of ways to retrieve data stored in a Microsoft Access table, but none of them lets one recover table field descriptions, Access's limited analog of SAS variable labels. A Visual Basic macro saves the day; called from Microsoft Word, it looks up field descriptions pertaining to...; Tags: Microsoft Access, SAS Institute, Microsoft Corp., SAS/ACCESS, Visual Basic Macro, Microsoft Office, Office Suites, Software; White papers 2007-05-14
How to Generate 10,000 Excel Spreadsheets in 10 Minutes (or Less): SAS programmers have traditionally used techniques such as proc export, DDE, Access to PC File Formats, excel libname engine, and ODS to generate Excel spreadsheets. Each one of these approaches, though, focuses on 'Pushing' the data Excel spreadsheets from SAS. A new .NET 'Pull' technique is presented in this paper....; Tags: Excel Spreadsheet, SAS Institute, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2007-05-14
Using Dynamic Data Exchange and Table-Driven Programming to Manage Excel Files: In clinical trials, Microsoft Excel is widely used to document programming requirements. Those documents are frequently updated over time. It is quite time consuming and often challenging for programmers to keep track the changes of the requirement documents. As a result, the requirement changes might not be communicated efficiently among...; Tags: SAS Institute, Programming, Excel Manager, Dynamic Data Exchange, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2007-05-14
Reading Excel Workbooks: The authors of this paper will explain some relational tables that are stored in a Microsoft Excel workbook using the LibName statement with the excel engine. The authors will look at standard techniques to specify worksheet names and read tables with no row headers. They will investigate and overcome various...; Tags: SAS Institute, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2007-05-14
Good Info Comes in Small Multiples: Creating Small Multiple Presentations of Data With SAS and Excel: Promoted by folks like visualization guru Edward Tufte, the use of small multiple presentations of data in charts or other forms to visualize information is rapidly gaining traction. Unfortunately, creating a large number of Excel Bar and Line Charts to present the summarized SAS data can be surprisingly labor intensive....; Tags: SAS Institute, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2007-05-14

Creating Multi-Sheet Excel Workbooks the Easy Way With SAS: Transferring SAS data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper discusses using the new XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). The reader will...; Tags: SAS Institute, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2007-05-14
7 Bulletproof Steps - The Quickest Way to Programmatically Generate a Dynamic Excel Graph From SAS: If one is thinking, "Jeezz? not another way to create an Excel graph?", the author highly encourages the user to continue reading this paper. While there are several proven techniques that allow the user to programmatically create a dynamic Excel graph based on N observations from a SAS data set,...; Tags: Technique, SAS Institute, Microsoft Excel, Productivity, Microsoft Office, Office Suites, Software; White papers 2007-05-14
Delivering SAS to Excel Jockeys: The ubiquity of Microsoft Excel and Word on desktop computers has made it a default entry point for many users to view and edit their information. Once Excel was included into the MS Office suite in 1993, it became the killer app overtaking other spreadsheet heavy weights such as Lotus...; Tags: SAS Institute, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2007-05-14
SAS-With-Excel Application Development: Tools and Techniques: The commonest non-SAS tool for data presentation, and working with data, is Microsoft Excel. Other people may want a developer's SAS report formatted as a spreadsheet. Dynamic Data Exchange DDE can empower and augment a developer's use of SAS with Excel. A developer can develop SAS programs to load worksheets,...; Tags: Technique, Developer, SAS Institute, Tool, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2006-03-28
Creating And Importing Multi-Sheet Excel Workbooks the Easy Way With SAS: Transferring data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper discusses using XML support in Base SAS 9.1 software to move data between SAS and Microsoft Excel (versions 2002 and later). Through this paper one...; Tags: SAS Institute, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2006-02-28
De-Mystifying the SAS Libname Engine in Microsoft Excel: A Practical Guide: This paper is a "How-to" guide exploring the SAS v9 Excel libname engine. It focuses on the application of the Excel engine including an introduction and some suggestions on its use. The practical advantages and shortcomings of the engine are discussed. Readers will learn how to use the libname statement...; Tags: SAS Institute, Microsoft Corp., Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2006-02-28
Batch Job to Create and Send Mass Excel Reports Using REXX, SAS, HTML(XML) and Email System: The paper presents a computing architecture and related problems of a batch job to create and send mass Excel reports to a lot of users using REXX, SAS Base, HTML, MSO XML and Email system. The paper addresses an application of a SAS parameterized program invoked multiple times from REXX...; Tags: Job, HTML, SAS Institute, XML, E-mail, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2006-02-28
Sur La Table: Creating Microsoft Excel PivotTables in a Jiffy From SAS Data: Creating good looking Excel Pivot Tables to hold an individual's nicely summarized SAS data can be surprisingly labor intensive. This paper presents a technique and macro that combine Base SAS with Visual Basic Scripting to make possible to fully automate the creation of custom formatted Excel Pivot Tables from SAS...; Tags: SAS Institute, Microsoft Corp., Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2006-02-28
SAS to Publishable Excel... Seamlessly - Using ODS, XML, and Other Tricks: There are an abundance of tools and approaches to moving data from SAS into Excel. Each approach has an intended purpose along with a long list of advantages and disadvantages. Since the authors understand and recognize from personal experience that time and resources don't always permit a total rewrite of...; Tags: SAS Institute, XML, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2006-02-28
Reading Microsoft Word XML Files With SAS: In 2005 Microsoft announced that the new default format for documents created in Microsoft Office will be XML-based. The ability of SAS to read XML offers a convenient method for extracting structured information from Microsoft Word documents. This paper examines three scenarios where information from a Word document is read...; Tags: SAS Institute, Microsoft Corp., XML File, Microsoft Word, Microsoft Office, Office Suites, Software; White papers 2006-02-28
State Agency Personnel Information Reports: A SAS/IntrNet Project: Sometimes auditors need information pertaining to the employment status or authorized salary of certain individuals, as of a particular date. The source data for responding to such queries are contained in three different databases that are maintained by the State Comptroller's Office. Instead of executing a separate query against the...; Tags: Agency, SAS Institute, Intranet, Microsoft Office, Office Suites, Software; White papers 2006-02-28
Make the Invisible Visible: A Case Study of Importing Multiple Worksheet Files by Using the SAS9 LIBNAME Engine in Microsoft Excel: When multiple worksheets need to be imported, it adds more complexity to the already painful job. One of the tedious things SAS programmers have to do is to specify the different sheet names by hard coding, so that the sheet names are visible to the SAS system. Unfortunately, in most...; Tags: SAS Institute, Microsoft Corp., Sheet Name, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2006-02-28
So, Your Data Are in Excel!: Excel is not a relational database; it's a spreadsheet. A relational database contains tables where each column holds the value for an attribute. Every value in that column holds the same attribute, but for a different entity. Each row holds the attributes for a single entity. SAS expects its datasets...; Tags: SAS Institute, RDBMS, Microsoft Excel, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management; White papers 2006-01-23
Using Single-Purpose SAS Macros to Format EXCEL Spreadsheets With DDE: Single-purpose macros for formatting EXCEL spreadsheets are described in this paper. The paper also discusses the DDE triplet and doublet and with a more in-depth look at X4ML commands that are used for formatting EXCEL spreadsheets from inside SAS. The macros exemplify modularity which reduces complexity by hiding internal X4ML...; Tags: Excel Spreadsheet, SAS Institute, Macro, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2005-03-09
How to Get SAS Data Into PowerPoint Using SAS9: SAS interacts well with Microsoft Word and Excel. ODS will output Word and Excel. A developer may also use the new SAS Microsoft Addins to shuttle data back and forth from SAS to Word and Excel. However, SAS provides no tools for creating or otherwise interacting with another popular Office...; Tags: SAS Institute, Microsoft PowerPoint, Microsoft Office, Office Suites, Software; White papers 2005-03-09