University:
Boston University
Course:
QST SM 101 | Introduction to Management
Academic year:

2022
Views:

439

Pages:

19
Author:

Deja Hood

Using ODS (Output Delivery System) Layout to Enhance Reporting Output Delivery System Boston University Slideshow Title Goes Here  Create datasets from procedure output  Generate high quality graphs  Direct output to non-listing destinations  Control format and style of output 27 ODS Destinations Boston University Slideshow Title Goes Here Category SAS Formatted Third-Party Formatted Destinations Results DOCUMENT ODS document LISTING SAS output listing OUTPUT SAS data set HTML HTML file for online viewing MARKUP Markup language tagsets PRINTER Printable output in one of three different formats: PCL, PDF, or PS (PostScript) RTF Output written in Rich Text Format for use with Microsoft Word 2000 28 Directing Output with ODS Boston University Slideshow Title Goes Here  Syntax ods file="\"; ; ods close;  Examples  ods rtf file="C:\Example.rtf"; ; ods rtf close;  ods pdf file="C:\Example.pdf"; ; ods pdf close; 29 Helpful Options for Directing Output Boston University Slideshow Title Goes Here  Columns =     Specify number of columns on page HTML, RTF and Printer (PDF) destinations Titles and footnotes unaffected, maintain normal positions Graphs resize, tables wrap to fit  Startpage =  Control page breaks  RTF and Printer (PDF) destinations  Only one title per page 30 Helpful Options: Columns = Boston University Slideshow Title Goes Here options orientation=landscape nodate nonumber; ods pdf file=“\" columns=2; Title "New York Shoe Sales"; proc print data = NYShoes noobs label; var Product Sales; run; proc sgplot data = NYShoes; where product ne 'Total'; yaxis label="Sales per Store"; vbar product / response=sales_store; title; run; ods pdf close; 31 Boston University Slideshow Title Goes Here Helpful Options: Startpage = Boston University Slideshow Title Goes Here options orientation=portrait nodate nonumber; ods pdf file=“\" startpage=no; Title "New York Shoe Sales"; proc print data = NYShoes noobs label; var Product Sales; run; proc sgplot data = NYShoes; where product ne 'Total'; yaxis label="Sales per Store"; vbar product / response=sales_store; title; run; ods pdf close; Boston University Slideshow Title Goes Here ODS Layout Boston University Slideshow Title Goes Here  Absolute Layout     Explicitly specify location and dimensions of output regions Printer (PDF) destinations only Restricted to one page per layout Good for static reports or where precise layout is required  Gridded Layout  Specify gridded output dimensions with columns= and rows=  HTML and Printer (PDF) destinations  Good for reports where dynamic sizing is required Boston University Slideshow Title Goes Here 36 Absolute Layout: Structure Boston University Slideshow Title Goes Here ods pdf file="\.pdf"; /*Layout Container*/ ods layout start x=0.5in y=0.5in width=7.5in height=9in; /*Top Left Region Container*/ ods region x=0in y=0in width=3.5in height=4.25in; /*Top Right Region Container*/ ods region x=4in y=0in width=3.5in height=4.25in; /*Bottom Left Region Container*/ ods region x=0in y=4.0in width=3.25in height=4.25in; /*Bottom Right Region Container*/ ods region x=3.5in y=4.0in width=3.25in height=4.25in; ods layout end; ods pdf close; 37 Absolute Layout: Detail (Top Left) Boston University Slideshow Title Goes Here options orientation=portrait nodate nonumber; ods pdf file="\.pdf"; Title "New York Shoe Sales"; /*Layout Container*/ ods layout start x=0.5in y=0.5in width=7.5in height=9in; /*Top Left Region Container*/ ods region x=0in y=0in width=3.5in height=4.25in; proc print data = NYShoes noobs label; var Product Sales; run; 38 Absolute Layout: Detail (Top Right) Boston University Slideshow Title Goes Here /*Top Right Region Container*/ ods region x=4in y=0in width=3.5in height=4.25in; ods pdf text = "This report summarizes shoe sale data for the New York subsidiary for the 2012 calendar year. Men's casual shoes accounted for the highest total sales as well as the highest total sales per store. Sandals accounted for the lowest total sales as well as the lowest total sales per store. Sport shoe sales were among the lowest in terms of total sales per store, though they are also among the most commonly available (sold in 23 stores)."; Absolute Layout: Detail (Bottom Left) Boston University Slideshow Title Goes Here /*Bottom Left Region Container*/ ods region x=0in y=4.0in width=3.25in height=4.25in;; proc sgplot data = NYShoes; where product ne 'Total'; yaxis label="Sales per Store"; vbar product / response=sales_store; title; run; Absolute Layout: Detail (Bottom Right) Boston University Slideshow Title Goes Here /*Bottom Right Region Container*/ ods region x=3.5in y=4.0in width=3.25in height=4.25in;; proc sgplot data = NYShoes; where product ne 'Total'; yaxis label="Stores"; vbar product / response=stores; title; run; ods layout end; ods pdf close; Boston University Slideshow Title Goes Here Gridded Layout: Structure Boston University Slideshow Title Goes Here ods pdf file="\.pdf"; /*Layout Container*/ ods layout start columns=2 rows=2 /*column_widths=(3.5in 3.5in)*/; /*Top Left Region Container*/ ods region width=3.5in; /*Top Right Region Container*/ ods region width=3.5in; /*Bottom Left Region Container*/ ods region width=3.5in; /*Bottom Right Region Container*/ ods region width=3.5in; ods layout end; ods pdf close; Boston University Slideshow Title Goes Here