Applied System Knowledge Ltd

Data Warehousing with the SAS® System

Copyright © 2016 Applied System Knowledge Ltd

SAS and all other SAS Institute Inc. product or service names are registered trademarks of SAS Intitute Inc. in the USA and other countries. ® indicates USA registration.

SAS Institute world-wide can be found at and in the UK at


Steve has written and presented many papers over the years, a selection of them are listed below.

A new download request facility will be here soon - in the meantime if you would like to have a copy of any of these papers please email to request it

How Am I Driving … My Business?
BI techniques from the Insurance industry that can be applied to other business areas to “drive” better performance.

[co-authored with Guy Garrett of Achieve Intelligence, Brighton, UK]
(Paper056, SAS Global Forum 2013, San Francisco)

A variety of examples of business monitoring and performance analysis are explored, showing how we used these to satisfy requirements from a range of users in insurance companies we have worked with in recent years. Similar techniques and methods would apply to many other commercial environments.

A Comparison of Lookup Techniques
Or why you really ought to try the Hash object

(Views newsletter 3rd Quarter 2006, Issue 35)

Lookup is a common requirement in many SAS programs, and in SAS 9 a new method was introduced (Hash object in the data step). This article compares it with ‘traditional’ SAS techniques. Hash is also the basis of the new Lookup transform in SAS Data Integration Studio.

Exploiting New Metadata with the SAS Data Step Interface

(Views newsletter 2nd Quarter 2005, Issue 29)

SAS 9 metadata is a rich repository of information that is available to XMLand Java interfaces. However, if you don’t have Java skills available SAS also offers an interface for data step programmers. This article illustrates how to utilise your existing SAS programming skills to access this new resource.

The Value of Metadata for ETL and Beyond

(SAS Forum UK, November 2004)

Metadata can be a great asset to a data warehouse – or just one more task to tick off the list. This paper outlines some of the ways to get value from your metadata assets and make the effort of recording it worthwhile.

How Many Dates Do You Want? The Multiple Personality of Time in Your Data Warehouse

(Paper110, SUGI 29, Montreal, April 2004)
This paper discusses the many ways in which dates and time appear in a data warehouse, and seeks to explain why you might want to use – or to avoid – certain date constructs in your data warehouse.

A Sense of Perspective: How to use a Star Schema Data Warehouse to see any historical view you want.

(SeUGi 20 - Paris, France, June 2002)

Covering the reasons why history is needed in a data warehouse, and the different Time perspectives that may be required to support the business need for a "true" presentation of past data, this paper highlights some of the crucial techniques involved in building and querying a fully historical data store using extended Star Schema designs. A potential "ultimate star schema" with all possible viewpoints available is also discussed.

Data Warehousing - What's It All About? Learning to Walk in Seven League Boots
(Paper 141, SUGI 27 - Orlando, Florida, April 2002 [invited speaker])

A high-level view of some the issues (and opportunities) in incrementally building an enterprise-wide data warehouse.

This paper examines some of the factors that help make data warehouses work (and some that can trip you up!), including:
• Can you call your project "data warehouse"?
• Maintaining a business focus - prioritising for value
• Incremental building - how big are your steps?
• The relationship between data marts and the enterprise data warehouse