Help, I’ve Received a Spreadsheet File from StarOffice Calc…..!
£0.00
VIEWS Independent UK SAS User Group, London, UK – 20th May 2004
Abstract
We have been conditioned to accept spreadsheet files from Excel, which require SAS/ACCESS to
read (unless they have been saved as delimited files). When a spreadsheet file is sent to us from
StarOffice, or OpenOffice.org, Calc, we are likely to panic, but we should not even break into a
sweat, as Base SAS is more than enough to read all the data from this compressed XML format.
This paper will show you how to read text, numbers, percentages, currency values, dates and times
from this spreadsheet file format. If you want you will even be able to read the formulae too!
The introduction of the Output Delivery System (ODS) in the SAS® System version 7 gave programmers a consistent mechanism for formatting output from SAS Procedures and Data steps to printers and HTML. The defaults provided by ODS are more than adequate for formatting simple reports, but are not necessarily ideal for other types of reports, particularly if standards exist for company reporting.
This paper will discuss the different options for customising and standardising ODS-formatted HTML reports, using examples for PROC REPORT, PROC TABULATE and the Data step.
VIEWS Independent UK SAS User Group, London, UK – 25th September 2001
Reviews
There are no reviews yet.