This workshop presents the most effective techniques for exporting SAS tables or procedure output from Base SAS into Excel spreadsheets. The course uses examples to show the basics of the SAS Excel LIBNAME engine, the EXPORT procedure, and ODS to create CSV, HTML, and XML files that can be opened by Excel. You will learn how to use the EXPORT procedure to create Microsoft Excel files from SAS tables, use the LIBNAME engine to create Microsoft Excel files from SAS tables, use ODS to create comma-separated-values files and HTML files for Microsoft Excel, and use ODS to create Spreadsheet Markup Language files for Microsoft Excel. This is a hands-on workshop.

Space Race Ita on this page. This workshop is available to UC researchers only.

• Introduction The OpenDocument Format (ODF) is an XML-based file format for representing electronic documents such as spreadsheets, charts, presentations and word processing documents. The standard was developed by the OASIS (Organization for the Advancement of Structured Information Standards), and it is a free and open format.

The Output Delivery System (ODS). By using ODS, you can now create various types of. In addition to the output file, HTML can also generate files to support frames. (ODS) you can output your graphs to web-enabled HTML files. Using the flexibility of ODS, you can include the graphs as static GIF or JPEG files, or create interactive, customizable graphs for web distribution using ActiveX controls and JAVA applets. This is really cool stuff. With a few little tricks, you can go a step below a simple HTML graph. Yes, you can add drill-down capability to your HTML graphs.

The OpenDocument format is used in free software and in proprietary software. Originally, the format was implemented by the OpenOffice.org office suite and, with Office 2007 SP2, Microsoft also supports ODF subset. This article will explain the basics of ODF format, and specifically its implementation in spreadsheet applications ( OpenOffice.org Calc and Microsoft Office Excel 2007 SP2). Presented is a demo application which writes/reads tabular data to/from.ods files. The application is written in C# using Visual Studio 2010.

Created.ods files can be opened using Excel 2007 SP2 or greater and OpenOffice.org Calc. ODF Format OpenDocument format supports document representation: • As a single XML document • As a collection of several subdocuments within a package Office applications use the second approach, so we will explain in detail. Every ODF file is a collection of several subdocuments within a package (ZIP file), each of which stores part of the complete document. Each subdocument stores a particular aspect of the document. For example, one subdocument contains the style information and another subdocument contains the content of the document. This approach has the following benefits: • You don't need to process the entire file in order to extract specific data. • Images and multimedia are now encoded in native format, not as text streams.