Home
Contact
SAS Paper Search
SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PharmaSUG China papers
SAS:PhUSE papers
FDA/PhUSE CSS posters
SAS:PNWSUG papers
SAS:SCSUG papers
SAS:SESUG papers
SAS:SeUGI papers
SAS:SUGI papers
SAS:VIEWS papers
SAS:WUSS papers
SAS:CDISC papers
Fortune records
Marsh 1001
India
South America

Powered by SAS® 9.01.01M3P02162005.

Valid XHTML 1.0 Transitional

Titles
SAS SUGI proceedings: Datawarehouse (SUGI 31 and later), 207 papers
AF   Arrays   Datawarehouse   Enterprise Guide   Macros   FSP   ODS   Pharmaceutical   PROC FORMAT   PROC REPORT   Repeated measures   SQL   PROC TABULATE   Internet and the web   XML   SAS v9  


SAS Global Forum 2016   April 18-21, 2016 - Las Vegas, Nevada

tweet!  Bridging the Gap: Importing Health Indicators Warehouse Data into SAS® Visual Analytics Using SAS® Stored Processes and APIs
   Li Hui Chen  Manuel Figallo 
Keywords: healthcare warehouse
Pages: 12 Size: 1180 Kb 
tweet!  Integrating SAS®, Hadoop, and the Data Warehouse in a Single Solution
   Bob Matsey 
Keywords: warehouse
Pages: 1 Size: 457 Kb    Download the posterdownload (.pdf, 2525 Kb)

SAS Global Forum 2015   April 26-29, 2015 - Dallas, TX

tweet!  SAS® and SAP Business Warehouse on SAP HANA--What's in the Handshake?
   Tatyana Petrova 
Keywords: warehouse
Pages: 17 Size: 803 Kb 

SAS Global Forum 2013   April 28 - May 1, 2013 - San Francisco, California

tweet!  Adaptive In-Memory Analytics with Teradata: Extending Your Existing Data Warehouse to Enable SAS® High-Performance Analytics
   Greg Otto  Tom Weber 
Keywords: warehouse
Pages: 10 Size: 489 Kb 
tweet!  Implementation of Slowly Changing Dimension to Data Warehouse to Manage Marketing Campaigns in Banks
   Lihui Wang  Michelle Cheong  Murphy Choy 
Keywords: warehouse
Pages: 8 Size: 241 Kb 

    resource Additional resource: Video


SAS Global Forum 2012   April 22-25, 2012 - Orlando, Florida

tweet!  Developing a Flexible ETL Process to Let SAS® Capture Data Changes Efficiently in a Data Warehouse and Clean Up the Mess
   Stephen M. Overton 
Keywords: SAS warehouse
Pages: 8 Size: 646 Kb 

SAS Global Forum 2011   April 4-7, 2011 - Las Vegas, Nevada

tweet!  SAS® Global Users Group Data Warehouse: A Look Behind the Scenes
   Gregory Nelson 
Keywords: warehouse
Pages: 22 Size: 211 Kb 
tweet!  In Control of Your Data Warehouse Processes With the Help of SAS® Stored Processes and the SAS® Information Delivery Portal
   Ralf Vaessen  Danny Pannemans  Juan M. Quesada  Koen Vyverman 
Keywords: warehouse
Pages: 24 Size: 862 Kb 

SAS Global Forum 2010   April 11-14, 2010 - Seattle, Washington

tweet!  So You Need a Data Warehouse But Don't Have the Budget to Build One: What Now?
   Steve Morton 
Keywords: warehouse
Pages: 11 Size: 551 Kb 

SAS Global Forum 2009   March 22-25, 2009 - National Harbor, Maryland

tweet!  Innovation, Implementation, and Integration: Building a DataWarehouse with SAS® Data Integration Studio and MS SQL Server
   Soeren Junk 
Keywords: SQL warehouse
Pages: 11 Size: 170 Kb 
tweet!  Data Warehouse and SOA: Using Web Services in the Insurance Industry
   Janus Mens 
Keywords: internet warehouse
Pages: 1 Size: 16 Kb 
tweet!  Using SAS® to Build the Managed Care Data Warehouse at Community Care Behavioral Health Organization
   Mary Doyle  Qingfeng Liang  Gretchen Ciocco  Michele Mesiano  Shouqiang Wang 
Keywords: healthcare warehouse
Pages: 8 Size: 421 Kb 
tweet!  Change Data Capture and the Benefits to the Modern Enterprise Data Warehouse
   David Barkaway 
Keywords: warehouse
Pages: 1 Size: 17 Kb 
tweet!  SAS® as SaaS: The Benefits and Challenges of Implementing an Enterprise-Scale SAS Data Warehouse and Business Intelligence Shared Service
   Tim Walters 
Keywords: warehouse
Pages: 9 Size: 83 Kb 
tweet!  The Interactive Data Warehouse: Introducing Transactional Data Marts and “Smart Applications” to Interact with Data Warehouse Data
   Stein Arve Finnestad  Gisle Karlsen  Rune Lekve  Pål Navestad  Terje Strømstad  Odd Jarle Tednes 
Keywords: warehouse
Pages: 8 Size: 344 Kb 

SAS Global Forum 2008   March 16-19, 2008 - San Antonio, Texas

tweet!  Academic Business Intelligence System Development Using SAS Tools
   Azman B. Taa 
Keywords: Business Intelligence Data Warehouse SAS ETL SAS Enterprise Guide
Pages: 13 Size: 649 Kb 
tweet!  Migrating Information in the Amisys Data-Warehouse: Current to Advanced
   Anthony E. DeGance 
Keywords: warehouse
Pages: 10 Size: 106 Kb 
tweet!  You've Just Bought a Data Warehouse. Now What?
   Stanley Fogleman 
Keywords: Data Warehousing Data Integration Studio Microsoft ACCESS ETL warehouse
Pages: 5 Size: 38 Kb 
tweet!  Building OLAP Cubes with SAS® 9: A Hands-on Workshop
   Gregory Nelson 
Keywords: Data warehouse DI Studio OLAP Cube Studio star schema MDDB MDX
Pages: 27 Size: 4809 Kb 
tweet!  Exploiting OLAP Cubes with SAS® 9: A Hands on Workshop
   Gregory Nelson 
Keywords: Data warehouse DI Studio OLAP Cube Studio star schema MDDB MDX SAS Add-in for Microsoft Office SAS Information Delivery Portal.
Pages: 13 Size: 861 Kb 
tweet!  "Styring" a Mission-Critical Solution for the Norwegian Post
   Truls Andersen  Lisbeth Laahne 
Keywords: Data Warehousing Business Intelligence Performance Management Quality Production Control
Pages: 1 Size: 18 Kb 
tweet!  New Architecture and Speed with a Netezza Data Warehouse Appliance
   Dana Rafiee 
Keywords: warehouse
Pages: 4 Size: 62 Kb 

SAS Global Forum 2007   April 16-19, 2007 - Orlando, Florida

tweet!  SAS Response: Impacts of New Services on Communication Services Providers
   Ken King 
Keywords: data warehouse
Pages: 1 Size: 17 Kb 
tweet!  Speed It Up - Active Warehousing with SAS® Data Integration: From Batch to Real-Time
   Nancy Rausch  Eric J. Hunley  Gary Mehler 
Keywords: Data Integration Real-time XML Web Services Active Data Warehouse DW Data Warehouse
Pages: 16 Size: 631 Kb 
tweet!  Performance-Driven Data Integration - An Optimized Approach
   Vijay Venugopal  Srinivas G. Bhat  Jim Fang 
Keywords: Table/View SAS/Access Denormalization SAS Data Mart Data Warehouse
Pages: 6 Size: 75 Kb 
tweet!  Planning for and Designing a Data Warehouse - A Hands-On Workshop
   Gregory S. Nelson 
Keywords: ETL Studio Data Integration Studio BASE SAS SQL data warehousing slowing changing dimensions change data capture transformations ETL warehouse
Pages: 16 Size: 158 Kb    Download the codedownload (.zip, 1227 Kb)
tweet!  SAS® Data Integration Studio Product Review
   Eric J. Hunley  Gary Mehler  Nancy Rausch 
Keywords: Data Integration DI Data Warehousing DW
Pages: 1 Size: 16 Kb 
tweet!  Getting the Most from PROC MEANS
   Andrew H. Karp 
Keywords: PROC MEANS data summarization ETL data marts data warehousing threading statistics
Pages: 9 Size: 65 Kb 

SUGI 31   March 26-29, 2006 - San Francisco, California

tweet!  Documentation-Driven Techniques for Building SAS® Data Warehouses
   Leonid Batkhan 
Keywords: code macro warehouse
Pages: 10 Size: 79 Kb 
tweet!  Stars and Models - How to Build and Maintain Star Schemas Using SAS® ETL Server
   Nancy Rausch 
Keywords: Star Schema Data Warehouse SAS 9 transformation data integration data management
Pages: 24 Size: 470 Kb 
tweet!  Base SAS® vs. SAS® Data Integration Studio Understanding ETL and the SAS® Tools Used to Support It
   Danny Grasse  Gregory S. Nelson 
Keywords: ETL Studio BASE SAS SQL data warehousing slowing changing dimensions ETL
Pages: 20 Size: 593 Kb 
tweet!  Using External Data Dictionary Files When Building SQL Queries in Base SAS®
   Mike D. Tangedal 
Keywords: Base SAS macro language SQL data dictionary warehouse
Pages: 10 Size: 133 Kb 
tweet!  Advanced Warehousing with SAS®9
   Gary Mehler 
Keywords: ETL warehousing mart performance configuration planning monitoring
Pages: 17 Size: 351 Kb 
tweet!  A Pragmatic Programmers Introduction to SAS® Data Integration Studio
   Gregory S. Nelson 
Keywords: ETL Studio Data Integration Studio data warehousing change data capture transformations ETL
Pages: 34 Size: 1977 Kb 
tweet!  "PROC Photo": A Generic Method to Capture Time-Stamped States of Operational Tables
   Richard Masse  Luc Simon 
Keywords: Macro DataWarehouse Oracle Versioning
Pages: 8 Size: 1383 Kb 
tweet!  Real Time: What Is It? What Are We Doing about It?
   Richard Phillips  Gregory S. Nelson 
Keywords: Data warehousing real time SAS solutions ETL
Pages: 14 Size: 132 Kb 

SUGI 30   April 10-13, 2005 - Philadelphia, Pennsylvania

tweet!  Best Practices in Enterprise Data Management
   Gary Mehler 
Keywords: warehousing ETL performance
Pages: 14 Size: 414 Kb 
tweet!  Simplify Existing Projects with Ideas from Data Warehousing
   Rick Aster 
Keywords: data warehousing project management applications development
Pages: 6 Size: 423 Kb 
Best Contributed Paper
tweet!  Taming Transformation: A Strategy for Metadata within the Warehouse
   Katherine Prairie 
Keywords: ETL metadata PROC SQL warehouse
Pages: 9 Size: 107 Kb 
tweet!  PreMIS: Pre-hospital Medical Information System
   Jeff Wright  Patrick H. Alston  Sharon Schiro  Tim Walters 
Keywords: healthcare warehousing reporting
Pages: 12 Size: 535 Kb 
tweet!  Environments Needed for the Successful Deployment of a Data Mart/Warehouse
   Mark G. Lucas 
Keywords: Warehouse Architecture Webdelivery
Pages: 5 Size: 303 Kb 

SUGI 29   May 9-12, 2004 - Montreal, Canada

tweet!  Balancing Data Quality Against Time and Money Constraints
   Susan B. Long  Linda Roberge  Jeff Lamicela  Mummoorthy Murugesan 
Keywords: data quality data warehouse data cleaning
Pages: 17 Size: 1097 Kb 
tweet!  Write Log (%WL) a Production Logging Utility for Data Warehouse Transactional Logs
   Brett C. Peppe 
Keywords: Data Warehouse data cleaning Transactional Loaders
Pages: 4 Size: 34 Kb 
tweet!  Data Quality Solution - A Technical Overview
   Eric J. Hunley 
Keywords: Data Quality DQ ETLQ Information Warehousing Warehouse Improve Cleane Cleanse Scrub Match
Pages: 13 Size: 735 Kb 
tweet!  Metadata for End Users - A Crucial Part of Your Data Warehouse Quality Policy
   Gad Kotler 
Keywords: business logic warehouse
Pages: 4 Size: 399 Kb 
tweet!  Improving Peformance: Accessing DB2 Data with SAS 9
   Scott Fadden 
Keywords: DB2 SAS/ACCESS Base SAS Performance Tuning Database Data Warehouse
Pages: 16 Size: 120 Kb 
tweet!  Just How Many Dates Do You Want? The Multiple Personality of Time in Your Data Warehouse
   Steve Morton 
Keywords: data model 'slowly changing dimensions' SCD timespan warehouse
Pages: 12 Size: 111 Kb 
tweet!  Business Views of Building an Actuarial System Using SAS/Warehouse Administrator
   Dominic Roy  Josee Genois 
Keywords: actuaries worksheets complex calculations warehouse
Pages: 8 Size: 179 Kb 
tweet!  Next Generation Data Warehousing with SAS 9
   Gary Mehler 
Keywords: data warehouse ETL
Pages: 10 Size: 218 Kb 
tweet!  Building a Purchasing Data Warehouse for SRM from Disparate Procurement Systems
   Zeph G. Stemle 
Keywords: application macro warehouse
Pages: 9 Size: 188 Kb 
tweet!  8 Characteristics of a Successful Data Warehouse
   Martin Brown 
Keywords: Data Warehouse ETL Studio Warehouse Administrator
Pages: 5 Size: 113 Kb 
tweet!  A Day in the Life of an Analytical Warehouse
   Julian Anderson  Greg S. Barnes Nelson  Jeff Wright 
Keywords: data mart aix java process dependencies extract transform load warehouse
Pages: 15 Size: 386 Kb 
tweet!  Data Warehouse: ROI and Database Design
   Bill Inmon 
Keywords: warehouse
Pages: 19 Size: 1142 Kb 
tweet!  Bring the Data Warehouse to the Office with SAS Integration Technologies
   Peter W. Eberhardt 
Keywords: warehouse
Pages: 10 Size: 558 Kb 
Honorable Mention
tweet!  Architectural Views on Building an Actuarial System with SAS/Warehouse Administrator
   Dominic Roy  Alain Baillargeon 
Keywords: actuaries data warehouse object-oriented share
Pages: 9 Size: 193 Kb 

SUGI 28   March 30 - April 2, 2003 - Seattle, Washington

tweet!  Using Different Methods for Accessing Non-SAS® Data to Build and Incrementally Update That Data Warehouse
   Ben T. Cochran 
Keywords: SQL Data Warehouse SAS/ACCESS
Pages: 6 Size: 188 Kb 
tweet!  SAS/ACCESS® to External Databases: Wisdom for the Warehouse User
   Judy Loren 
Keywords: DB2 Access Oracle SQL warehouse
Pages: 9 Size: 205 Kb 
tweet!  Dynamically Building SQL Queries Using Metadata Tables and Macro Processing
   Michael J. Molter  Scott T. Millard  Steve B. Paciocco 
Keywords: warehouse SQL Access macro
Pages: 4 Size: 195 Kb 
tweet!  Data Warehouse Administrator: Step by Step
   Francesca Pierri 
Keywords: Data Warehouse
Pages: 10 Size: 1369 Kb 
tweet!  UNLOADing Data from Informix
   John E. Bentley  Bala Peddi 
Keywords: RDBMS Informix Data Warehousing SAS Access
Pages: 6 Size: 178 Kb 
tweet!  A Simplified and Efficient Way to Map Variables of a Clinical Data Warehouse
   Yanyun Shen 
Keywords: data warehouse mapping clinical
Pages: 6 Size: 234 Kb 
tweet!  Understanding SAS/Warehouse Administrator®
   Michael L. Davis 
Keywords: data warehousing SAS/Warehouse Administrator metadata
Pages: 10 Size: 473 Kb 
Honorable Mention
tweet!  Using Information Effectively to Make More Profitable Decisions: The Ten Letter Solution for Finance
   Frederick D. Busche  Tom Everly  Kirk Boothe 
Keywords: Banking Geography Data Warehouse Enterprise Miner Profitability GIS
Pages: 12 Size: 1114 Kb 
tweet!  The Value of ETL and Data Quality
   Tho Nguyen 
Keywords: ETL Data Quality Warehousing
Pages: 3 Size: 187 Kb 
tweet!  'How Do I Love Thee? Let Me Count the Ways.' SAS® Software as a Part of the Corporate Information Factory
   John E. Bentley 
Keywords: Data Warehousing
Pages: 10 Size: 910 Kb 
tweet!  Finding Time: SAS® and Data Warehouse Solutions for Determining Last Day of the Month
   Jennifer O'Neil  Laural Wierenga 
Keywords: Date Transformation Warehouse INTX MACRO
Pages: 4 Size: 179 Kb 
tweet!  Ring Charts
   David J. Corliss 
Keywords: Warehouse Warehousing Ring Chaos
Pages: 5 Size: 183 Kb 
tweet!  Next Generation Warehousing with Version 9
   Gary Mehler 
Keywords: Warehouse manageability ETL
Pages: 10 Size: 572 Kb 
tweet!  Transactional Records Access Clearinghouse: SAS® Based Warehouse and Mining Tools Keeps Tabs on U.S. Government
   Susan B. Long  Linda Roberge  Jeffrey T. Lamicela 
Keywords: web enabled data warehouse data mining government data
Pages: 6 Size: 1167 Kb 
tweet!  Metadata Application on Clinical Trial Data in Drug Development
   Julia Z. Zhang  David Chen  Tor-lai Wong 
Keywords: metadata data warehouse data definition table clinical
Pages: 3 Size: 200 Kb 
tweet!  An Overview of SAS Certification and the Test Development Process
   Linda Althouse 
Keywords: certification test development data warehousing exams
Pages: 8 Size: 138 Kb 

SUGI 27   April 14-17, 2002 - Orlando, Florida

tweet!  Customizing the SAS/MDDB® Report Viewer
   Phil Rhodes 
Keywords: Web enablement Reporting Data Warehousing
Pages: 3 Size: 148 Kb 
tweet!  Physicians Web Portal to Enterprise Information
   Ahmed Rahman  Rosa Cabanela  Priscilla Van Grevenhof 
Keywords: SAS MDDB WEBEIS SAS Intrnet Warehouse Enterprise internet
Pages: 5 Size: 127 Kb 
tweet!  Data Warehousing - What's It All About? Learning to Walk in Seven League Boots
   Steve Morton 
Keywords: data warehouse best practise data mart methodology
Pages: 7 Size: 451 Kb 
Best Contributed Paper
tweet!  The Benefits of Data Warehousing for an Insurance Company
   Wolfgang Hofbauer 
Keywords: Data Warehousing Data integrity Profitability analysis Decision-making Strategic Management Insurance Industry
Pages: 6 Size: 383 Kb 
tweet!  The Knowledge Warehouse: The Next Step Beyond the Data Warehouse
   Anthony M. Dymond 
Keywords: knowledge management business rules knowledge base object-oriented object-analysis warehouse
Pages: 8 Size: 136 Kb 
tweet!  Analyze the Stock Market Using the SAS® System
   Luis F. Soriano 
Keywords: Stocks Financial Warehousing Market Intranet Analysis
Pages: 6 Size: 161 Kb 
tweet!  Data Warehousing in the Modern World: A Case Study Revisited
   Mary K. Tucker 
Keywords: Data Warehousing
Pages: 8 Size: 270 Kb 
tweet!  MDDBs, HOLAP, Override Methods, SCL: What Worked and Did Not Work for the Review of Census 2000 Data
   Richard A. Denby  Lori A. Guido 
Keywords: MDDB HOLAP warehousing census
Pages: 4 Size: 338 Kb 
Best Contributed Paper
tweet!  From Data Warehouse to Reports Warehouse
   Gady Kotler 
Keywords: Portal Web ODS Reports SAS SIGMA warehouse
Pages: 4 Size: 671 Kb 
tweet!  From Manual to Automatic with Overdrive - Using SAS® to Automate Report Generation
   Faron Kincheloe 
Keywords: automation presentation data warehouse
Pages: 6 Size: 82 Kb 
tweet!  Autotrader.com: from Chevette to Corvette
   Jenine Eason  Jerry Johannesen  Lars Olufsen  Jeff Chang  Brad Goldman 
Keywords: Internet Web ODS HTML MDDB Warehouse
Pages: 10 Size: 1143 Kb 
tweet!  A Scorecard Approach to Improving Data Quality
   Phil Nousak  Rob Phelps 
Keywords: Data Quality Data Warehouse Scorecard
Pages: 9 Size: 220 Kb 
Honorable Mention
tweet!  Unit-of-Analysis Programming
   Vanessa C. Hayden 
Keywords: database denormalization data warehouse pharmaceuticals
Pages: 6 Size: 180 Kb 
tweet!  IDW - The Next Generation Data Warehouse
   Larry D. Bramblett 
Keywords: Data Warehouse Warehouse Administrator
Pages: 5 Size: 118 Kb 
tweet!  Managing SAS® Services: A System Administrator's Guide to Enterprise Applications
   Gregory Barnes Nelson 
Keywords: SAS/Share Data Warehouse Administrator SAS/IntrNet Java Application Server JSP Servlets
Pages: 1 Size: 10 Kb 
tweet!  Proper Architecture Considerations for DW Implementations
   Frank Nauta 
Keywords: Warehouse Warehosuing systems architecture
Pages: 2 Size: 126 Kb 

SUGI 26   April 22-25, 2001 - Long Beach, California

tweet!  STDINFO: From SAS/AF to SAS/IntrNet
   Reshma Kakkar  Raymond L. Ransom 
Keywords: Web-enablement SAS/IntrNet Metadata HtmSQL Decision Support System Data Warehousing af
Pages: 6 Size: 114 Kb 
tweet!  Data Warehousing at Baylor University: The Second Year
   Phil Rhodes  Sue Herring 
Keywords: data warehousing web enablement
Pages: 3 Size: 102 Kb 
tweet!  Everything I Need to Know About Data Warehousing I Learned From A U.S. Army Survival Guide
   Mary K. Tucker 
Keywords: Data Warehousing
Pages: 4 Size: 102 Kb 
tweet!  Data Warehousing Helps Enterprise Improve Quality Management
   Xiao Ji  Shichun Zhou  Jay Cao  Jianli Shao 
Keywords: Data Warehousing Quality Data Information
Pages: 4 Size: 151 Kb 
tweet!  Spinning Straw into Gold: Data Quality Tools and Techniques to Get the Most From Your Customer Warehouse
   Bob Brauer  Rob Stephens 
Keywords: warehouse customer information address standardization data quality
Pages: 5 Size: 122 Kb 
tweet!  Catch the Errors Early - On Generating Checking Routines Automatically
   Markku V. Suni 
Keywords: SAS DataWarehouse error checking generator clean data
Pages: 4 Size: 73 Kb 
tweet!  A Case Study in Data Warehousing and Data Mining Using the SAS System
   Mary K. Tucker 
Keywords: Data Warehousing Data Mining OLAP MDDB
Pages: 3 Size: 121 Kb 
tweet!  Building an Integrated Informational Backplane
   Mark Moorman 
Keywords: Warehousing data modeling information delivery design
Pages: 7 Size: 219 Kb 
tweet!  Metadata: Everyone Talks About It, But What Is It?
   John E. Bentley 
Keywords: Metadata Data Warehousing documentation Best Practices
Pages: 5 Size: 156 Kb 
tweet!  The Project Management Warehouse
   Charles Q. Rissmiller  Art Rerecich 
Keywords: Pharmacokinetics Data Warehousing pharmacodynamics meta data exploitation warehouse
Pages: 3 Size: 284 Kb 
tweet!  Data Modeling in Clinical Data Analysis Projects
   Gajanan Bhat 
Keywords: Clinical data data warehouse normalization
Pages: 6 Size: 29 Kb 
tweet!  Versioning an Existing Data Warehouse
   Jugdish K. Mistry  John Finianos 
Keywords: DW VERSIONING UPGRADE MODIFY warehouse
Pages: 4 Size: 127 Kb 
tweet!  WAP-Enabled SAS Apps
   S. David Riba 
Keywords: WAP Wireless Application Protocol webAF development data warehouse Quality Partner
Pages: 2 Size: 144 Kb 
tweet!  The Data Warehouse in Your Mobile Phone by Using WAP and SAS/IntrNet
   Andreas Saflund  Pontus Berg 
Keywords: WAP Mobile Internet SAS/IntrNet Warehouse Phone web
Pages: 10 Size: 436 Kb 
tweet!  A SAS/IML Macro for Goodness-of-Fit Testing in Logistic Regression Models With Sparse Data
   Oliver Kuss 
Keywords: reporting problem solutions datawarehouse report macro
Pages: 5 Size: 146 Kb 

SUGI 25   April 9-12, 2000 - Indianapolis, Indiana

tweet!  Implementing Public Sector Performance Management: A Balanced Scorecard Approach
   Kristin Nauta 
Keywords: balanced scorecard public sector scorecard data warehousing OLAP GPRA GMRA
Pages: 4 Size: 1429 Kb 
tweet!  Leveraging Your ERP Investment with the SAS System
   Steve Sober 
Keywords: ERP SAS/ACCESS software Data Warehouse SAP peoplesoft jd edwards
Pages: 10 Size: 1601 Kb 
tweet!  Production-Strength Data Mining Environment for Terabyte-Class Relational Data Warehouses
   Michael K. Nichols  John Zhao  John D. Campbell 
Keywords: Data Wahrehousing RDBMS SQL Generation SAS generation sampling warehouse
Pages: 9 Size: 460 Kb 
tweet!  New Features in SAS/Warehouse Administrator
   Ken Wright 
Keywords: Data Warehouse
Pages: 6 Size: 254 Kb 
tweet!  Information Delivery: Exploitation Strategies and Best Practices
   Hugh G. McCabe 
Keywords: managed care best practices data warehouse
Pages: 7 Size: 238 Kb 
tweet!  Constructing a Data Warehouse for Pharmacokinetic Data
   Stanley P. Koprowski  Dwight J. Fowler  Jeffrey S. Barrett 
Keywords: Pharmacokinetic Clinical data warehouse CANDA
Pages: 7 Size: 238 Kb 
tweet!  Data Warehouse Design Issues for ERP
   Mark Moorman 
Keywords: warehouse ERP SAP data business template
Pages: 5 Size: 256 Kb 
Best Contributed Paper
tweet!  Minimizing Development Risk While Maximizing Warehouse Performance on UNIX Systems
   Jeff LeSueur 
Keywords: testing throughput performance warehouse UNIX
Pages: 5 Size: 168 Kb 
tweet!  Building a System for Uniform Data Access in a Research Environment
   Julia L. Bienias  Woojeong Bang  Charles L. Owen 
Keywords: SAS/AF software FRAME entries SCL lists multiple databases data warehouse
Pages: 6 Size: 226 Kb 
tweet!  Power Indexing: A Guide to Using Indexes Effectively In Nashville Releases
   Diane Olson 
Keywords: performance index append data warehouse
Pages: 5 Size: 128 Kb 
tweet!  Riding the Information Wave to Marketing Success: Web Enabled On-Line Analytical Processing from Your Data Warehouse
   George Bukhbinder  Peter Babigian 
Keywords: Data Warehousing OLAP Telecommunications Marketing internet warehouse
Pages: 6 Size: 122 Kb 
tweet!  Providing Access to a University Data Warehouse via the Web
   Phil Rhodes  Faron Kincheloe 
Keywords: data warehousing Web tools internet warehouse
Pages: 4 Size: 293 Kb 
tweet!  Successful Information Delivery: Integrate Your Data Warehouse and Other SAS Applications with Enterprise Reporter Software
   Jens D. Mikkelsen 
Keywords: Enterprise Reporter Data Warehousing warehouse
Pages: 10 Size: 595 Kb 
tweet!  Private Detectives in a Data Warehouse: Key-Indexing, Bitmapping, and Hashing
   Paul M. Dorfman 
Keywords: array direct-addressing key-indexing bitmapping hashing warehouse
Pages: 10 Size: 183 Kb 
tweet!  Building a Low Cost SAS Data Warehouse on NT Workstation
   Zhuan (John) Xu 
Keywords: Warehouse NT User Interface Application Low Cost PC
Pages: 4 Size: 187 Kb 
tweet!  Data Warehousing for Manufacturing Yield Improvement
   Robert A. Rutledge 
Keywords: Data Warehouse SAS/IntrNet software Manufacturing Yield Quality
Pages: 10 Size: 443 Kb 
tweet!  Warehousing, Metadata, and Object-Based Analysis
   Thomas H. Burger  Philip M. Pochon 
Keywords: Warehousing Object-based Analysis Decision Support Relational DB Knowlege Formation
Pages: 5 Size: 136 Kb 
tweet!  Show Them Where It's At: Data Mine the Earth's Surface for Locational Significance of What's Hidden in Your Data Warehouse
   LeRoy Bessler 
Keywords: InfoGeographics Data Mining PROC GMAP Geographic Information Systems Macro Data Exploration warehouse
Pages: 6 Size: 124 Kb 
tweet!  Utilization of SAS Programs in the Business Environment
   Sunil K. Gupta  Charlie E. Shipp 
Keywords: business data warehouse data management data access data presentation
Pages: 5 Size: 74 Kb 
tweet!  Bring the Data Warehouse of Standardized Medical Costs to the Web
   Priscilla Van Grevenhof  Kirsten Hall Long  Judith L. Wagner  Ahmed S. Rahman  James M. Naessens  Roger W. Evans 
Keywords: data warehouse metadata Intranet internet
Pages: 3 Size: 930 Kb 
tweet!  Successful Information Delivery: Integrate Your Data Warehouse and Other SAS Applications with Enterprise Reporter Software
   Jens D. Mikkelsen 
Keywords: Enterprise Reporter Data Warehousing warehouse
Pages: 10 Size: 569 Kb 
tweet!  Application of SAS Software in the Establishment of a Data Mart for Quality Analysis System in the Metallurgical Industry
   Xiao Ji  Ge Yu  Jay Cao 
Keywords: data mart data warehouse star schema OLAP SAS software
Pages: 4 Size: 104 Kb 
tweet!  Analyzing Network Management Data with the SAS System
   Tracy L. Lord  Charles E. Keeler 
Keywords: network network management Information Warehouse network administration TCP/IP
Pages: 2 Size: 188 Kb 
tweet!  Extending the Data Warehouse: An Introduction to OLE DB
   S. David Riba 
Keywords: OLE DB MDDB Data Warehouse ODBC
Pages: 1 Size: 25 Kb 
tweet!  Summarizing Impossibly Large SAS Data Sets for the Data Warehouse Server Using Horizontal Summarization
   Michael A. Raithel 
Keywords: PROC SUMMARY Data Warehouse Mainframe horizontal summarization binary counter _TYPE_
Pages: 5 Size: 108 Kb 

SUGI 24   April 11-14, 1999 - Miami Beach, Florida

tweet!  Indexing and Compressing SAS Data Sets: How, Why and Why Not
   Andrew H. Karp 
Keywords: Indexing Compression Match-Merging Data Warehousing
Pages: 5 Size: 27 Kb 
tweet!  A SAS/AF Application for Parallel Extraction, Transformation, and Scoring of a Very Large Database
   Daniel Kohn  David Kuhn 
Keywords: Parallel Ddata Mart Warehouse extraction Performance RDBMS Data mart population af
Pages: 7 Size: 95 Kb 
tweet!  Constructing a Data Warehouse
   Curtis A. Smith 
Keywords: Warehouse Data Library File Storage Efficiencies
Pages: 6 Size: 178 Kb 
tweet!  Data Warehousing and Information Delivery: Success and Failure in Managed Care
   Hugh G. McCabe 
Keywords: Decision Support data warehouse managed card Web applications
Pages: 6 Size: 156 Kb 
tweet!  A Health Care Claims Data Mart: Construction and Exploitation
   Stuart Levine  Marge Scerbo 
Keywords: MDDB EIS Data Mart Warehouse Administrator healthcare
Pages: 7 Size: 311 Kb 
tweet!  Large Scale Data Warehousing with the SAS System
   Tony Brown  Leigh Ihnen  Jim Craig 
Keywords: warehouse performance metadata i/o Warehouse/Administrator
Pages: 10 Size: 63 Kb 
tweet!  Data Warehousing in Pharmaceuticals and Healthcare: An Industry Perspective
   M. Kumar Sagar  Himanshu Raval 
Keywords: data warehousing pharmaceuticals healthcare
Pages: 10 Size: 73 Kb 
Best Contributed Paper
tweet!  Just Enough Database for Manufacturing Yield Analysis
   Robert A. Rutledge  Linda H. Tai  Garth W. Helf 
Keywords: SAS/AF Data Warehouse Yield Management Manufacturing
Pages: 6 Size: 2305 Kb 
Honorable Mention
tweet!  Practical Tips and Techniques for Building an Enterprise Data Warehouse in an IBM Mainframe Environment
   Jugdish Mistry  John Finianos 
Keywords: Warehouse MVS Tips Techniques Loading lookup
Pages: 6 Size: 82 Kb 
tweet!  Data Warehousing on a Shoestring
   Richard J. Nicola 
Keywords: Data Warehousing Reporting AF summary
Pages: 6 Size: 47 Kb 
tweet!  The ABCs of MDDBs
   Marge Scerbo 
Keywords: mddb warehouse hierarchy dimension eis warehouse Adminitrator
Pages: 8 Size: 113 Kb 
tweet!  Administering OLAP with SAS/Warehouse Administrator
   Michael Burns 
Keywords: OLAP HOLAP Warehouse Administrator MDDB SUMMARY
Pages: 12 Size: 170 Kb 
tweet!  What's All This Metadata Good For, Anyway? Using Metadata to Dynamically Generate SQL
   Jonathan Stokes 
Keywords: SQL Generation metadata metabase data warehousing SQL pass-through
Pages: 5 Size: 48 Kb 
tweet!  Adding Extensions to the SAS/Warehouse Administrator
   Peter R. Welbrock 
Keywords: Data Mining Data Warehousing Enterprise Miner warehouse
Pages: 10 Size: 90 Kb 
tweet!  Data Mining at IMS Health, How We Turned a Mountain of Data into a Few Information-rich Molehills
   Jerry Kagan  Paul Kallukaran 
Keywords: SAS/AF Data Mining Client Server Neural Network Data Warehouse SAS/Connect healthcare
Pages: 8 Size: 52 Kb 
tweet!  The SAS Data Warehouse and Data Integration in SASOL Synthetic Fuels
   Pieter J. Venter 
Keywords: integration warehouse
Pages: 3 Size: 27 Kb 
tweet!  HR Vision Software - A Decision Support System for Human Resource Professionals
   Beverly Dudley 
Keywords: hr human resources data warehouse decision support
Pages: 2 Size: 17 Kb 
tweet!  Automating the Management of a Data Warehouse
   Sy J. Truong  Kathy Boussina 
Keywords: Electronic Reporting Submission Data Warehouse Intranet Hyperlink Clinical
Pages: 5 Size: 117 Kb 
tweet!  EPA's SAS Analytic Library on the Web
   Jay Jacob Wind  Chapman P. Gleason  Michael Yu  Kamau Njuguna  Myles Powers 
Keywords: Data Warehousing Denormalized SAS Datasets SAS/Share Servers Graphics SAS/Connect Environmental Data internet
Pages: 5 Size: 94 Kb 
tweet!  How and Why a SAS Data Warehouse Is Used to Manage the 2000 Decennial Census
   Gail S. Davidson 
Keywords: data warehouse design
Pages: 3 Size: 58 Kb 
tweet!  Web Enabled Graphics with a SAS Data Warehouse
   Diane E. Brown 
Keywords: Warehouse IntrNet Graph Web internet
Pages: 6 Size: 931 Kb 
tweet!  Unlocking SAP AG R/3 Data with the SAS System
   Eric Hunley  Craig Rubendall 
Keywords: ERP SAP R/3 ACCESS SAS/ACCESS DATA WAREHOUSING
Pages: 13 Size: 146 Kb 
tweet!  SAS Software MDDBs Solve Real-World Problems for 1997 Economic Census
   Shirin A. Ahmed  Kimberly D. Yarbrough 
Keywords: MDDB EIS Warehousing Reports NAICS SAS
Pages: 6 Size: 73 Kb 
tweet!  Visualising Large Data Volumes with SAS/MDDB Server, SAS/CONNECT Software, SAS/EIS Software and the HOLAP Add-Ins
   Daniel Morris 
Keywords: data warehouse EIS MDDB OLAP HOLAP
Pages: 4 Size: 206 Kb 
tweet!  The Art of Designing HOLAP Databases
   Mark Moorman 
Keywords: OLAP warehouse MDDB EIS HOLAP database
Pages: 5 Size: 75 Kb 
tweet!  The Quality Data Warehouse - Solving Problems for the Enterprise
   Brad Klenz  Donna Fulenwider 
Keywords: quality improvement quality data warehouse statistical process control
Pages: 8 Size: 143 Kb 
tweet!  Web Enabling a Large Data Warehouse: Improved Metadata for Expert Analysts and Wider Access to Management Information
   Clare Somerville  Colin Harris 
Keywords: Web Data warehousing metadata SAS/Intranet Internet/Intranet Data warehouse administration
Pages: 10 Size: 316 Kb 
tweet!  Realizing Baosteel's Technology & Quality Data Warehouse Based on SAS
   Zhang Yaochun 
Keywords: Baosteel SAS/DWA SAS DATA WAREHOUSE DSS MIS
Pages: 4 Size: 59 Kb 
Best Contributed Paper (2nd Place)
tweet!  Project RAPTOR: Implementation and Exploitation of a Manufacturing Data Warehouse
   Anne I. Brooks  Roger Thompson 
Keywords: datawarehouse metadata yield semiconductor Maestro
Pages: 6 Size: 186 Kb 
Honorable Mention
tweet!  Using SAS Software to Build a Data Warehouse of Standardized Medical Costs and Patient Utilization for Health Services Research
   Priscilla E. Van Grevenhof  Judith L. Wagner  James M. Naessens  Jill M. Killian  Roger W. Evans  Eva R. Helgeson 
Keywords: Data Warehouse healthcare
Pages: 2 Size: 21 Kb 
tweet!  A Windowed Application for Efficient Access to Data Warehouse DB2 Data with PROC SQL Pass-Through Facility and Macros
   James Yang 
Keywords: Windowed Application Macro Pass-Through Facility Efficiency Data Warehouse DB2 SQL
Pages: 6 Size: 35 Kb 
tweet!  Scalable Performance Data Server 2.1: Tuning and Performance
   Daniel M. Sargent 
Keywords: SPDS parallel processing warehousing performance client server
Pages: 2 Size: 36 Kb 
Best Contributed Paper
tweet!  Data Libraries on Tape
   Curtis A. Smith 
Keywords: Tape Library Warehouse Data Storage Device
Pages: 4 Size: 74 Kb 

SUGI 23   March 22-25, 1998 - Nashville, Tennessee

tweet!  Querying the Data Warehouse with the SQL Procedure SELECT Statement
   Kirk Paul Lafler 
Keywords: SQL warehouse
Pages: 5 Size: 81 Kb 
tweet!  Exploiting Key Answers from Your Data Warehouse using SAS Enterprise Reporter Software
   Donna Torrence  Juli Staub Perry 
Keywords: warehouse
Pages: 7 Size: 246 Kb 
tweet!  A Data Warehouse Implementation Using the Star Schema
   Maria Lupetin 
Keywords: warehouse
Pages: 5 Size: 54 Kb 
tweet!  Enterprise Data Management - Warehouse Integration Solutions
   Kim Foster 
Keywords: warehouse
Pages: 5 Size: 138 Kb 
tweet!  Data Warehouse Efficiency Techniques with the SAS System
   Tony R. Brown 
Keywords: warehouse
Pages: 10 Size: 139 Kb 
tweet!  Data Warehouse: How to Use SAS from Beginning to Almost Ending for Your Warehouse
   Akbar Golmirzaie 
Keywords: warehouse
Pages: 7 Size: 58 Kb 
tweet!  Optimizing SAS Access to an Oracle Database in a Large Data Warehouse
   Clare Somerville  Clive Cooper 
Keywords: warehouse
Pages: 10 Size: 78 Kb 
tweet!  Using the Data Warehouse Model to Streamline and Accelerate New Drug and Medical Device Development
   Martin J. Rosenberg 
Keywords: warehouse
Pages: 5 Size: 198 Kb 
tweet!  A Data Access Challenge: Build a SAS Frame Application for Access to an Informix Data Warehouse
   John E. Bentley 
Keywords: warehouse
Pages: 7 Size: 156 Kb 
Best Contributed Paper
tweet!  Taking an HTML Snapshot of a Data Warehouse: Just Say, Cheese!
   Eric Simms  Jerry Kagan 
Keywords: html warehouse
Pages: 6 Size: 617 Kb 
tweet!  A Guide to Managing a SAS Data Warehouse for Use Across an Intranet
   Charles W. Bininger 
Keywords: warehouse
Pages: 5 Size: 59 Kb 
tweet!  W-O-W: Data Warehouse, SAS/OR and the Web
   Art Rerecich 
Keywords: internet warehouse
Pages: 8 Size: 39 Kb 
tweet!  Is Your Data Warehouse Successful? Developing a Data Warehouse Process That Responds to the Needs of the Enterprise
   Peter R. Welbrock 
Keywords: warehouse
Pages: 10 Size: 62 Kb 
tweet!  Building Your Own SAS Data Warehouse and Developing a Tool Set for Managing It
   Di Meng  Charlie Bastnagel 
Keywords: warehouse
Pages: 6 Size: 479 Kb 
tweet!  Does a Data Warehouse Deliver the Goods?
   Glen Payne 
Keywords: warehouse
Pages: 3 Size: 33 Kb 
tweet!  Enhancements to SAS/Warehouse Administrator
   Terry L. Lewis 
Keywords: warehouse
Pages: 8 Size: 79 Kb 
tweet!  Clinical Warehouse Enhancement: A Methodology for Linking Heterogeneous Databases
   Sharon Kromhout-Schiro  Rose M. Reedy  Rob Lenderman  James Zadinsky  Vicki Harp 
Keywords: clinical warehouse
Pages: 4 Size: 22 Kb 
tweet!  Data Warehouse Administration: An Urgent Need for Technology to Emerge!
   Jan J. M. Roording  Steven F. M. J. van Agt 
Keywords: warehouse
Pages: 6 Size: 46 Kb 
tweet!  Open the Information Window of Your SAS Data Warehouse: A WEB Information Center Powered by SAS
   Di Meng 
Keywords: internet warehouse
Pages: 4 Size: 462 Kb 
Honorable Mention
tweet!  Retrievals from DB2 BLOB (Binary Large Objects) Data Warehouse Using SAS
   Tracy L. Lord  Robert C. Pratt 
Keywords: warehouse
Pages: 5 Size: 33 Kb 

SUGI 22   March 16-19, 1997 - San Diego, California

tweet!  Using SAS with Oracle to Add a Replica of a Large Operational Database to a Data Warehouse
   Clive Cooper  Clare Somerville 
Keywords: warehouse
Pages: 7 Size: 51 Kb 
tweet!  Summarizing Impossibly Large SAS Data Sets for the Data Warehouse Server Using Horizontal Summarization
   Michael A. Raithel 
Keywords: warehouse
Pages: 5 Size: 26 Kb 
tweet!  Incorporating External Data Into the Data Warehouse
   Tim Walters 
Keywords: warehouse
Pages: 6 Size: 55 Kb 
tweet!  Round Pegs Into Square Holes: Data Warehouses for the Hardware Impaired
   Michael L. Davis 
Keywords: warehouse
Pages: 6 Size: 36 Kb 
Honorable Mention
tweet!  The Evolutionary Data Warehouse - An Object-Oriented Approach
   Amy Turske McNee 
Keywords: warehouse
Pages: 6 Size: 45 Kb 
tweet!  The Fast Food Approach to Data Warehouse Reporting: Using SAS/AF and FRAME to Build a Non-Technical User Interface.
   Grace La Torra  Esther Steiner 
Keywords: warehouse af
Pages: 6 Size: 462 Kb 
tweet!  The SAS Data Warehouse, a Real World Example.
   Martin P. Bourque 
Keywords: warehouse
Pages: 6 Size: 37 Kb 
tweet!  Implementing a Dimensional Data Warehouse with the SAS System.
   Gregory S. Barnes Nelson 
Keywords: warehouse
Pages: 10 Size: 1224 Kb 
tweet!  SAS/Warehouse Administrator Usage and Enhancements.
   Terry Lewis 
Keywords: warehouse
Pages: 11 Size: 402 Kb 
tweet!  Data Warehouse Implementation with the SAS System
   Tony Brown 
Keywords: warehouse
Pages: 11 Size: 48 Kb 
tweet!  How Many Good Fishes Are There in Our Net? Neural Networks as a Data Analysis Tool in CDE-Mondadori's Data Warehouse
   Guido Cuzzocrea  Alberto Saccardi  Giovanni Lux  Emilia Porta  Arianna Benatti 
Keywords: warehouse
Pages: 6 Size: 579 Kb 
tweet!  Data Warehouse: A Telecommunications Business Solution.
   Demetris Papaiacovou  Larry Bramblett  June Burgess 
Keywords: warehouse
Pages: 4 Size: 12 Kb 
tweet!  Meta Data Designer - A Tool for Setting Up Meta Data for a Data Warehouse
   Sy Truong 
Keywords: warehouse
Pages: 5 Size: 91 Kb 
tweet!  Mining the Data Warehouse: Statistical Analysis of Combined Tables of Categorical Data
   Gilbert W. Fellingham  H. Dennis Tolley 
Keywords: warehouse
Pages: 6 Size: 179 Kb 
tweet!  Data Mining the Original Data Warehouse: Twenty-Five Years and a Million Lines of SAS Later
   H. W. Barry Merrill 
Keywords: warehouse
Pages: 12 Size: 83 Kb 

SUGI 21   March 10-13, 1996 - Chicago, Illinois

tweet!  Delving into the Data Warehouse: Levels of Analysis for a Three-Tier Survey Analysis System
   David J. Ross 
Keywords: warehouse
Pages: 6 Size: 286 Kb 
tweet!  Tips and Techniques for Data Fixes in a Repository Data Warehouse
   Ty Lee 
Keywords: warehouse
Pages: 6 Size: 314 Kb 
tweet!  Building an Efficient Data Warehouse: Understanding the Issues of Data Summarization and Partitioning
   Robert Chu  Sue Tideman 
Keywords: warehouse
Pages: 8 Size: 563 Kb 
tweet!  Loading a Data Warehouse with Legacy Data
   Clive Cooper  Clare Somerville 
Keywords: warehouse
Pages: 6 Size: 358 Kb 
tweet!  Residence Data Warehouse: Pacific Bell "Jumps" to WARP Speed
   Larry D. Bramblett  Ann S. King 
Keywords: warehouse
Pages: 4 Size: 232 Kb 
tweet!  A Data Warehouse Using the SAS System
   Harriet Janes  Terry Lewis  Shirley Dixon 
Keywords: warehouse
Pages: 8 Size: 1594 Kb 
tweet!  Building a Data Warehouse with SAS Software: Recipe for Success
   Karen Grippo  John Chen 
Keywords: warehouse
Pages: 7 Size: 637 Kb 
tweet!  Warehouse NOW! Blasting through to Legacy Data with (Almost) No Programming
   Jay Jaffe 
Keywords: warehouse
Pages: 10 Size: 964 Kb 
tweet!  Newgard Bridging the Gap: Using ODBC to Grab Data Stored in a SAS Data Warehouse for Reporting in Microsoft Access
   Reesa Laws  Mary Longacre 
Keywords: warehouse
Pages: 5 Size: 2306 Kb 
tweet!  Using SAS/EIS Software to Front End and Exploit Your Data Warehouse
   Ben Cochran  James Alessio  Dennis Catley 
Keywords: warehouse
Pages: 6 Size: 1180 Kb 
tweet!  Unpacking the Boxes from the Data Warehouse
   Connie Boynton 
Keywords: warehouse
Pages: 4 Size: 271 Kb 
tweet!  Data Warehouse + Microsoft Windows NT = A Perfect Solution for Client/Server Computing
   Joe Wang 
Keywords: warehouse
Pages: 8 Size: 415 Kb 
Powered by SAS®.
SUGI and SAS Global Forum Proceedings are copyrighted to SAS Institute Inc. All rights are reserved.
Any unauthorized reproductions are prohibited.
SAS® and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries.
Copyright © 1999-2017 Lex Jansen. All rights reserved.