# Presentations:Prholland Papers and Presentations

From sasCommunity

These are papers presented by Philip R Holland at SAS conferences in Europe and America.

Any questions? Just email him.

- Accessing SAS Data without using SAS Code

Categories: Barclaycard SAS User Group 1997, DDE, ODBC, Presentations, Prholland Papers and Presentations, VIEWS Independent UK SAS User Group 1997

Recent developments in SAS® for Windows have provided users with routes to SAS data and applications without having to write SAS code using the SAS System. This paper describes two examples of these facilities, ODBC and DDE, which could place SAS at the centre of any application development ..→ - Are You at Odds with ODS?

Categories: HTML, Output Delivery System, Presentations, Prholland Papers and Presentations, VIEWS Independent UK SAS User Group 2001

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 ..→ - Could Enterprise Guide have been written in Java?

Categories: Java, Presentations, Prholland Papers and Presentations, SAS Enterprise Guide, VIEWS Independent UK SAS User Group 2004

While the title of this paper may suggest a controversial topic, the intention is to review the functionality of Enterprise Guide®, the Windows-based thin-client front-end for SAS®, which uses COM/DCOM or the IOM Bridge to communicate with SAS® Integration Technologies. ..→ - Developing ODS Templates for Non-Standard Graphs in SAS 9.2

Categories: GTL, ODS Graphics, Output Delivery System, PhUSE 2010, PhUSE SDE Brussels 2011, PhUSE SDE Frankfurt 2011, PhUSE SDE Uxbridge 2011, Presentations, Prholland Papers and Presentations, SAS Global Forum 2010, TEMPLATE Procedure

This paper will use the specific examples of split axis line plots and charts to explain how to approach the development of ODS Templates for standard and non-standard graphs in SAS® 9.2. - Distributing Organization Charts via the Web without SAS/IntrNet Software

Categories: HTML, Pearl SAS User Group 1999, Presentations, Prholland Papers and Presentations, SeUGI 1999

In large corporations the maintenance of organisation charts is a necessary operation. Staff need to have up-to-date information on who is working where. Printed organisation charts can only be distributed quickly enough in small companies, so intranets tend to be used in larger organisations. T ..→ - Everyday Uses for ODS

Categories: DOCUMENT Procedure, Output Delivery System, PSI Statistical Computing SIG 2005, Presentations, Prholland Papers and Presentations

This paper describes a number of uses for ODS HTML, ODS CSVALL and ODS DOCUMENT statements for reporting. - GTL (Graphics Template Language) in SAS 9.2

Categories: GTL, ODS Graphics, Output Delivery System, PhUSE 2008, PhUSE 2012, PhUSE SDE Brussels 2009, PhUSE SDE Frankfurt 2009, Presentations, Prholland Papers and Presentations, SAS Global Forum 2009, TEMPLATE Procedure

The production version of the GTL (Graphics Template Language) was introduced in SAS 9.2. This new language gives all users the ability to create high quality graphs using simple ODS Graph templates and structured data. This paper describes how to get started with this new language by ..→ - Knit Perl and SAS Software for DIY Web Applications

Categories: HTML, Perl, Presentations, Prholland Papers and Presentations, SeUGI 2000, VIEWS Independent UK SAS User Group 2000

If your organisation develops a web-based SAS® application for 30+ users, then the logical choice is to use SAS/IntrNetTM software for speed, reliability and cost-effectiveness. However, your whole organisation may have fewer than 30 employees, so is there a cost-effective alternative to ..→ - Outta Space with SAS Software?

Categories: Barclaycard SAS User Group 1997, MVS, Presentations, Prholland Papers and Presentations, SUGI 1999, WORK, Z/OS

When running SAS® programs on a PC, the user needs only to worry about how much free space there is on the PC they are using. However, when SAS programs are run under MVS on a mainframe machine, the correct use of disk space for WORK and permanent SAS Data Libraries is more complex, but ..→ - Running Clinical Trials Programs with Enterprise Guide

Categories: PhUSE/PSI SDE Marlow 2009, PhUSE 2007, Presentations, Prholland Papers and Presentations, SAS Enterprise Guide

Geographical distribution of SAS programming teams across continents and oceans impacts the access to study programs and data, so that it is only practical for local programmers to use direct GUI access to files, whereas remote programmers are forced to take copies of files onto their local ..→ - SAS to R to SAS

Categories: Output Delivery System, PhUSE 2005, Presentations, Prholland Papers and Presentations, R, SAS Forum UK SIGs 2005

The aim of this paper is to describe one method of passing SAS data from SAS to R, using R to produce a graph, then passing that graph back to SAS for inclusion in an ODS document. The R programming language provides a wide range of graphical functionality, some of which are unavailable, ..→ - Something for Nothing! Converting plots from SAS/GRAPH to ODS Graphics

Categories: ODS Graphics, Output Delivery System, Presentations, Prholland Papers and Presentations, SAS/GRAPH, SAS Global Forum 2014

All the documentation about the creation of graphs with SAS® software states that ODS Graphics is not intended to replace SAS/GRAPH®. However, ODS Graphics is included in the Base SAS® license from SAS® 9.3, but SAS/GRAPH still requires an additional component license, so there is definitely a ..→ - Standard Graph Templates

Categories: GTL, ODS Graphics, Output Delivery System, PhUSE 2007, Presentations, Prholland Papers and Presentations, SAS Global Forum 2008, TEMPLATE Procedure

Outsourced tables and listings can be fairly easily defined using table shells to explain how clinical trials data should be tabulated, and ODS templates supplied to control the basic appearance of the output. Outsourced graphs, particularly if they have been heavily customised, are not so easy to ..→ - The Pros and Cons of PROC DOCUMENT

Categories: DOCUMENT Procedure, Output Delivery System, PhUSE 2007, Presentations, Prholland Papers and Presentations, SAS Global Forum 2009

Reports generated by a program using the ODS DOCUMENT destination can be stored, prior to printing, in a single file. This file can then be used with PROC DOCUMENT to generate reports selectively to 1 or more ODS destinations without the need to re-run the original data processing. This paper ..→ - Using Just SAS 9.1 to Draw Trellis Graphs

Categories: GTL, ODS Graphics, Output Delivery System, PhUSE 2006, Presentations, Prholland Papers and Presentations, WIILSU

In SAS 9.2 some new features of production ODS Graphics will be introduced, which will make trellis graphs easy to draw. These graphs were previously only readily available in R and S-Plus, as demonstrated in my PhUSE 2005 paper. However, SAS 9.2 will not be available until the middle of 2007, so ..→ - Using ODS Tables - PROC REPORT not needed!

Categories: Output Delivery System, PhUSE 2008, Presentations, Prholland Papers and Presentations, TEMPLATE Procedure

ODS Style templates can be used to control the basic appearance of the output, and, typically, PROC REPORT is used to build the tables that use these styles. ODS Table templates take this standardising to a new level, where the data just has to be prepared in a particular structure, and the ..→ - Using SAS/SHARE Software More Efficiently

Categories: Presentations, Prholland Papers and Presentations, SAS/SHARE, SeUGI 1997

SAS/SHARE® is a very powerful product which allows concurrent access to SAS® Datasets for read and writing. However, if not used with care, it can also be the cause of significant system-wide performance problems. Although the product is widely used, its impact is not widely understood. ..→ - Using the ODS Graphics Designer to Create Your Own Templates in SAS 9.2

Categories: GTL, ODS Graphics, ODS Graphics Designer, Output Delivery System, PhUSE 2009, PhUSE SDE Copenhagen 2010, PhUSE SDE Welwyn GC 2010, Presentations, Prholland Papers and Presentations, SAS Global Forum 2010

The pre-production release of the ODS Graphics Designer in SAS® 9.2 Phase 2 provides a GUI interface for building ODS templates for graphs. This paper shows how to make use of this tool to build a basic ODS Template for almost all types of graphs. Having built a template, the steps required to ..→ - What is Efficient SAS Coding?

Categories: PSI Statistical Computing SIG 2007, PhUSE 2006, PhUSE SDE Basel 2008, PhUSE SDE London 2008, Presentations, Prholland Papers and Presentations, WIILSU

Coding efficiency is generally measured in CPU time, disk space or memory usage. This is perfectly reasonable for SAS code that will be submitted many more times than it will be updated. However, there are coding environments where SAS programs are being written for single production runs, and ..→ - Why Does My Job Run Soooo Sloooowly...?

Categories: Barclaycard SAS User Group 1997, Presentations, Prholland Papers and Presentations, SAS/ACCESS, SQL Procedure

Almost every operation you are able to perform using SAS® software can be achieved in many different ways, each with their own advantages and disadvantages. It is not always possible to predict the disadvantages, as a basic operation may be suitable in one circumstance, but may be totally ..→ - Why Not Use SAS/PRESENTS Software Instead...?

Categories: Pearl SAS User Group 1998, Presentations, Prholland Papers and Presentations, SAS/EIS, SAS/PRESENTS, SUGI 1999, SeUGI 1998

Most of the papers at SUGI and other SAS® conferences are presented using Microsoft PowerPoint, and a few more are presented with Lotus Freelance Graphics. Both presentation tools are very powerful, and can produce very impressive final results, but both suffer from the same flaw when ..→