9'2 ODS Enhancements

1
9.2 ODS Enhancements

• Chris Olinger colinger_at_d-wise.com
• d-Wise Technologies, Inc.

2
9.2 Goodness

• Special thanks to Kevin Smith at SAS
• March 2007? Fall 2007? Spring 2008!
• Fixes a host of issues in ODS
• The following slides are overviews, in order of
  descending goodness

3
RTF Tagset -

• Measured Tagset (RTF, LaTeX)
• New RTF destination
• New style ods tagsets.rtf file"test.rtf"
• Old style ods rtf file"test.rtf"
• Why do I care?
• I can change the tagset!
• SAS now knows where the page breaks are

4
RTF

• Panel Control
• Increase readability
• Pagepanels
• Tablerows
• Spacing Control in documents
• PARSKIP style element
• Repeating row headers (tabulate)
• Continued

5
RTF

• Column header control
• Insert RTF codes into data stream
• TRHDR, TROWHDRCELL, TROWD
• Set using OPTIONS()
• Border control in style
• Cell borderrightside, borderrightcolor attribute
• Table tableheadercontainer, tablefootercontainer
  element

6
RTF Inline Formatting/Functions

• nbspace 3, newline 2,
• raw \cf12 RAW, unicode 03B1
• style foregroundred of super unicode
  ALPHA style foregroundgreen Nested
  Formatting and Scoping"
• super style foregroundred red style
  foregroundgreen green and style
  foregroundblue blue

7
Example
8
Stat Graph

• Production
• Proc SGRENDER
• SVG Scalable Vendor Graphics
• Infinitely scalable

9
(No Transcript)
10
Example
11
Style/Template Changes

• Fixes the mistakes of the original styles
• Replace statement is deprecated! Inheritance
  model is fixed
• Multiple style elements can be defined on a
  single statement
• Style X, Y, Z from _self_ / colorred
• Class X, Y, Z / colorred
• SAS Formats for attributes backgroundcolorfmt.

12
Style/Template Changes

• CSS support!
• New attributes to better correspond to CSS color
• Import CSS
• define style mystyle import mycssfile.css
  print end
• CSSSTYLE
• ods html cssstylemycssfile.css
• Style Editor in EG
• CSS element names must match style names!
• No more style templates (if you want)!

13
Style/Template Changes
14
Style/Template Changes

• Implicit parent templates
• Base.Template.Table
• Base.Template.Column
• Base.Template.Header
• Base.Template.Footer
• Cellstyle AS
• _col_, _dataname_, _label_, _row_, _style_
• Style info merges correctly now

15
(No Transcript)
16
ExcelXP/OpenOffice

• Great tagset for Excel interoperability
• CSV delimiter option OPTION(delimiter)
• Flyover style attribute support, Rotated headers
  support
• Column width settings, Page break formatting
• Embedded titles/footnotes
• Formula/equation support
• Filters
• Multiple worksheets, data driven
• Page setup options
• Table of contents support

17
PDF and Text

• PDF Security has been added
• options pdfsecurityhigh pdfpw(openpassword)
• Table of contents has more control
• options pdftoc2
• New embeddable Unicode fonts
• Thorndale AMT Times New Roman
• Albany AMT Arial
• Cumberland AMT Courier New

18
PDF and Text

• Support for inline styles (similar to RTF)
• Text decoration
• style textdecorationunderline text
• Underline, Overline, Strike through
• Unicode character support
• unicode 2603

19
(No Transcript)
20
(No Transcript)
21
PDF and Text

• Ods texthello world
• Is written to all open output destinations

22
Proc Document

• List by values in list statement
• Bygroups option
• Show the source of a template referenced by an
  output object
• Obtempl option
• Replay, delete, copy, move conditionally with a
  where clause
• Where clause
• Proc Report works!

23
ODS Select/Exclude

• Use a where clause on the select statement
• ods select where(_label_ 'Hello')
• Query open destinations
• sashelp.vdest
• dictionary.destinations

24
Base Proc Additions

• Tabulate
• Name lists table x1-x10
• Mode statistic
• Report
• Mode statistic
• Style merge option
• Spanrows option for group and order, across pages
• Contents option for break, rbreak, and define

25
(No Transcript)
26
Base Proc Additions

• Proc Freq
• Crosstabs template Base.Freq.CrossTabFreqs
• Print
• Blankline(count3 stylebackgroundred)
• Sumlabel use the label of the sum variable

27
Conclusion

• 9.2 ODS enhancements are a vast improvement over
  9.1
• Particular hats off go to measured RTF and Style
  fixes/changes
• 9.2 is downloadable from SAS right now!