SAS Paper Search
SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PharmaSUG China papers
SAS:PhUSE papers
FDA/PhUSE CSS posters
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
South America

Powered by SAS® 9.01.01M3P02162005.

Valid XHTML 1.0 Transitional

SAS SUGI proceedings: Data Warehousing and Solutions (SUGI 31 and later), 236 papers

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

Data Warehousing, Management and Quality

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!  SAS® Data Integration Studio and SAS® Macro - Working in Harmony for Data Warehousing Projects
Tatyana Kovtun 
Keywords: macro
Pages: 10 Size: 475 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!  Simple and Effective - Using ODS Destinations to Facilitate Data Management
Paul Gorrell 
Keywords: Excel HTML metadata PDF usability
Pages: 16 Size: 1696 Kb 
Best Contributed Paper
tweet!  At the Controls - How We Set Up Security via SAS® Management Console
Lisa L. Frank 
Pages: 10 Size: 85 Kb 
tweet!  The Electronic Project: Effectively Using Metadata throughout the Project Life Cycle
Jeffrey M. Abolafia  Frank DiIorio 
Keywords: NDA submissions clinical trials pharmaceutical applications project management
Pages: 18 Size: 721 Kb 
tweet!  Squeaky Clean Data with SAS® Data Quality Server
Faron Kincheloe 
Pages: 10 Size: 96 Kb 
tweet!  Demeter in the Database
Paul D. Sherman 
Keywords: SQL query database beancounting data modeling
Pages: 8 Size: 187 Kb 
tweet!  Super Size It!!! Maximize the Performance of Your ETL Processes
Nancy Rausch  Nancy J. Wills 
Keywords: ETL Data Integration DI Performance Scalability
Pages: 14 Size: 521 Kb 

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

Data Warehousing, Management and Quality

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!  Quality of the ICT Service at KBC Group
Albert Jacobs 
Pages: 10 Size: 1017 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 
Best Contributed Paper
tweet!  A Strategy for Managing Data Integrity Using SAS®
Brett J. Peterson 
Keywords: data checks data cleaning data management
Pages: 9 Size: 102 Kb 
tweet!  The Design and Use of Metadata - Part Fine Art, Part Black Art
Frank DiIorio  Jeffrey M. Abolafia 
Keywords: metadata NDA submissions clinical trials pharmaceutical applications
Pages: 17 Size: 406 Kb 

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

Data Warehousing, Management and Quality

tweet!  Producing Multipurpose Metadata for Data Quality and a Data Dictionary
John E. Bentley 
Keywords: Data dictionary data quality data profiling
Pages: 19 Size: 226 Kb 
tweet!  Budget Living with Pseudo ETL: Creating Your Own ETL Tool through SAS
David Steves  Denise A. Figliozzi 
Keywords: SAS/Base SAS/Connect and SAS/Access to Oracle
Pages: 4 Size: 102 Kb 
tweet!  Best Practices in Enterprise Data Management
Gary Mehler 
Keywords: warehousing ETL performance
Pages: 14 Size: 414 Kb 
tweet!  Using XML Mapper and XMLMAP to Read Data Documented by Data Documentation Initiative (DDI) Files
Larry Hoyle 
Keywords: ICPSR xml
Pages: 10 Size: 273 Kb 
tweet!  Extreme Web Access: What to Do When FILENAME URL Is Not Enough
Garth Helf 
Keywords: Web browser extract ETL URL socket internet
Pages: 10 Size: 197 Kb 
Best Contributed Paper
tweet!  The SQL Optimizer Project: _Method and _Tree in SAS9.1
Russ Lavery 
Keywords: SQL Explain Plan method tree
Pages: 57 Size: 277 Kb 
tweet!  Data Profiling: Designing the Blueprint for Improved Data Quality
Brett Dorr  Pat Herbert 
Keywords: data profiling data quality data management data analysis
Pages: 10 Size: 79 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 

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

Data Warehousing, Management and Quality

Best Contributed Paper
tweet!  SAS Macros are the Cure for Quality Control Pains
Gary M. McQuown 
Keywords: SAS Macros Quality Control Cure Pains
Pages: 6 Size: 155 Kb 
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 
Honorable Mention
tweet!  Dirty Data? dfPower Studio to the Rescue!
Kimberly A. Todd  Catherine A. Lindsey  Kristin M. Debnar 
Pages: 8 Size: 47 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 
Best Contributed Paper
tweet!  SAS Macros for Large Scale Data Analysis and Quality Management of Corporate Actuarial Data Mart
Dennis Tang  Don Cooper 
Keywords: Quality Data Mart Analysis Macro
Pages: 7 Size: 142 Kb 
tweet!  Data Quality Management: The Most Critical Initiative You Can Implement
Jonathan G. Geiger 
Pages: 14 Size: 177 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!  Data Standardization Strategies Producing Rapid International Disease Surveillance and Intervention: The Challenge and Solution
Scott Optenberg 
Pages: 1 Size: 64 Kb 
tweet!  Good Data Makes Good Marketing: Using Data Management to Enhance the Effectiveness of Database Marketing Campaigns
John Walker  Gavin Day 
Keywords: Data quality data management
Pages: 8 Size: 540 Kb 
tweet!  Make Your Data a Strategic Asset
Ken Wright 
Keywords: data quality discovery integration augmentation profiling
Pages: 7 Size: 806 Kb 
tweet!  Designing Information Maps for Ad Hoc Reporting
Diane Hatcher 
Keywords: Information Maps ad-hoc reporting
Pages: 10 Size: 303 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 
Honorable Mention
tweet!  Methods of Storing SAS® Data into Oracle Tables
Lois Levin 
Keywords: SAS/ACCESS
Pages: 9 Size: 302 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!  Data Management in Analyzing Clinic Trial Data - Metadata Application
Julia Z. Zhang  David Chen 
Keywords: data management data handling metadata data application tool
Pages: 5 Size: 185 Kb 
tweet!  Real Time Decision Support: Creating a Flexible Architecture for Real Time Analytics
Greg S. Barnes Nelson 
Keywords: Business Activity Monitoring Scorecard/ Dashboard Performance Management Real-time decision support
Pages: 12 Size: 398 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!  Developing Data Marts and Web-Enabled OLAP for Actuarial and Underwriting Analysis
Michael Krumenaker  George Bukhbinder 
Keywords: macro Excel internet
Pages: 7 Size: 564 Kb 
tweet!  Why SAS is the Best Place to Put Your Clinical Data
Steven A. Wilson 
Keywords: Audit trail Integrity constraints Indexes Generation data group Compression Security Encryption Passwords clinical
Pages: 12 Size: 81 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 

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

Data Warehousing and Enterprise Solutions

tweet!  Scaling SAS® Data Access to Oracle RDBMS
Howard Plemmons  Andrew Holdsworth 
Keywords: Access Oracle Scalable
Pages: 6 Size: 165 Kb 
tweet!  Using SAS® Strategically: A Case Study
Timothy D. Brown 
Keywords: solutions strategic
Pages: 7 Size: 219 Kb 
Honorable Mention
tweet!  Integrating SAS® and Microsoft SQL Server 2000 for Better and Faster Reporting
Helen Kim 
Keywords: SQL
Pages: 1 Size: 133 Kb 
tweet!  SAS® Version 9 and the Corporate Information Factory - Consolidating Industry-leading Paradigms of Data Warehousing, Business Intelligence and Analytic Intelligence
Steve Miller 
Pages: 1 Size: 136 Kb 
tweet!  Understanding SAS/Warehouse Administrator®
Michael L. Davis 
Keywords: data warehousing SAS/Warehouse Administrator metadata
Pages: 10 Size: 473 Kb 
tweet!  How to Access PC File Data Objects Directly from UNIX
Howard Plemmons 
Keywords: Access PC Files UNIX
Pages: 4 Size: 142 Kb 
Best Contributed Paper
tweet!  SAS® in the Office - IT Works
Peter W. Eberhardt 
Keywords: office integration
Pages: 7 Size: 234 Kb 
tweet!  Multi-Center Study Data Management With A Distributed Application
Derek Morgan 
Keywords: Data Management Health
Pages: 6 Size: 308 Kb 
tweet!  Performance Tuning SAS/ACCESS® for DB2
Scott J. Fadden 
Keywords: SAS/Access DB2
Pages: 10 Size: 200 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!  The Horror of Bad Data Quality
Henri Theuwissen 
Keywords: Quality Cleaning
Pages: 7 Size: 145 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!  New Ways and Means to Summarize Files
Curtis A. Smith 
Pages: 6 Size: 344 Kb 
tweet!  Better Decisions Through Better Data
Tony Fisher  George Marinos 
Keywords: Data Quality Data Integration Enterprise Decision Making Data Management
Pages: 6 Size: 260 Kb 
tweet!  Deploying Enterprise Solutions: The Business and Technical Issues Faced by SAS® Technologists
Don Henderson  David Septoff  Joe Costanzo  Ben Zenick  Ralph Mittl 
Keywords: solution mid-tier architecture
Pages: 6 Size: 158 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!  Why SAS® is the Best Place to Put Your Clinical Data
Steven A. Wilson 
Keywords: DBMS Index Integrity Constraints Audit Trail Data Security Encryption clinical
Pages: 6 Size: 307 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 

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

Data Warehousing and Enterprise Solutions

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!  Data Warehousing for the Enterprise
Gary Mehler 
Keywords: dw enterprise
Pages: 8 Size: 317 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!  Strategic Procurement: The SAS® Solution for Supplier Relationship Management
Fritz Lehman 
Keywords: SRM
Pages: 6 Size: 303 Kb 
tweet!  Data Warehousing in the Modern World: A Case Study Revisited
Mary K. Tucker 
Keywords: Data Warehousing
Pages: 8 Size: 270 Kb 
tweet!  The Joy of Table-driven Information Delivery Systems
Jonathon Hagerman 
Keywords: intranet dynamic information delivery maintainable
Pages: 4 Size: 215 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 
tweet!  Migrating a Publicly Available Web Database to a SAS® Solution: Building Multidimensional Databases (MDDBs)
Teresa L. Grimes  Heidi L. Clark 
Keywords: MDDB EIS OLAP multidimensional database internet
Pages: 3 Size: 110 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!  Mining Web Server Logs: Tracking Users and Building Sessions
Don Koch  John Brocklebank  Richard Roach 
Keywords: weblog mining e-commerce tracking sessions internet
Pages: 4 Size: 140 Kb 
tweet!  Can't Relate? A Primer on Using SAS® with Your Relational Database
Garth W. Helf 
Keywords: SAS/Access DBMS SQL DB2 dbkey Oracle
Pages: 10 Size: 205 Kb 
tweet!  From the Tactical to the Strategic: Transforming Data Into Knowledge for Use in an Enterprise Performance Management System
Aiman Zeid 
Keywords: Performance EPM Strategy HR Financial Management
Pages: 7 Size: 731 Kb 
tweet!  Balanced Scorecards: The Integration Point between Enterprise Information and Performance Monitoring
Don Henderson  Gary Young  Ralph Mittl 
Keywords: balanced scorecard pharmaceutical strategic vision
Pages: 7 Size: 260 Kb 
tweet!  A Scorecard Approach to Improving Data Quality
Phil Nousak  Rob Phelps 
Keywords: Data Quality Data Warehouse Scorecard
Pages: 9 Size: 220 Kb 
tweet!  Easy Access to Public Health Data Colorado Health Information Dataset (CoHID)
Huiyun Xiang 
Keywords: SAS Intrnet SAS Web Health Data Public Health healthcare
Pages: 3 Size: 112 Kb 
Honorable Mention
tweet!  Unit-of-Analysis Programming
Vanessa C. Hayden 
Keywords: database denormalization data warehouse pharmaceuticals
Pages: 6 Size: 180 Kb 

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

Data Warehousing and Solutions

tweet!  Using the SAS/ACCESS Libname Technology to Get Improvements in Performance and Optimizations in SAS/SQL Queries
Fred Levine 
Keywords: SAS/Access Performance SQL Optimization
Pages: 8 Size: 191 Kb 
tweet!  E-Volution of the Customer: Increasing Customer Loyalty Through An Intelligent Campaign Solution
Ellen Joyner 
Keywords: eintelligence CRM campaign management eCRM customer loyalty
Pages: 6 Size: 102 Kb 
tweet!  Pulitzer Programming: How Investigative Reporters are Using SAS
Stephen K. Doig  Richard O'Reilly 
Keywords: journalism newspapers Pulitzer Hurricane Andrew Census 2000
Pages: 1 Size: 71 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!  Informational System for Planning and Consolidation
Eugene A. Grishenkoff 
Keywords: MDDB Planning Consolidation
Pages: 7 Size: 215 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!  When PROC ACCESS Says NO to Excel 97/2000, DDE Says YES Still
Eric T. Sun  Eric Kammer 
Keywords: SAS Macro Proc Access DDE Excel97
Pages: 5 Size: 59 Kb 
tweet!  Integrating SAS and OMR Data Scanning Technology to Improve Efficiency with Database Management
Peter H. Coulson 
Keywords: Integrating Eefficincy analyze
Pages: 3 Size: 63 Kb 
tweet!  A Sort of a Mess - Sorting Large Datasets on Multiple Keys
David L. Cassell 
Keywords: compression sorting indexing multi-key datasets
Pages: 4 Size: 105 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!  Querying Star and Snowflake Schemas in SAS
Bart Heinsius 
Keywords: star snowflake query olap eis schema
Pages: 5 Size: 140 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!  Migrate to Oracle? I Need My SAS!!
Dianne L. Rhodes 
Keywords: Oracle Connect Normalization OLAP/OLTP RDBMS
Pages: 5 Size: 89 Kb 
tweet!  Joining SAS and DBMS Tables Efficiently
Garth W. Helf 
Keywords: dbkey dbindex index DBMS SQL join
Pages: 6 Size: 162 Kb 
tweet!  Quick Disk Table Look-up via Hybrid Indexing into a Directly Addressed SAS Data Set
Paul M. Dorfman 
Keywords: hybrid indexing direct addressing table lookup hash table index distribution
Pages: 6 Size: 91 Kb 
tweet!  Preparing the SAS Software Programming Environment for Regulatory Submission
Sunil K. Gupta 
Keywords: Environment Regulatory Pharmaceutical Reporting Analysis Standards
Pages: 9 Size: 179 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!  Digging for Gold: SAS Tools for Extracting Clinical Study Information from Oracle Clinical
Nancy Brucken 
Keywords: SQL Macro clinical
Pages: 3 Size: 107 Kb 
tweet!  Versioning an Existing Data Warehouse
Jugdish K. Mistry  John Finianos 
Pages: 4 Size: 127 Kb 

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

Data Warehousing

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!  Efficiency Techniques for Accessing Large Data Files
Andrew Wilcox  Manoj Kulwal 
Keywords: efficiency technqiues programming performance
Pages: 5 Size: 71 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 
tweet!  Data Warehousing for Data Mining: A Case Study
C. Olivia Rud 
Keywords: Data Mining Model
Pages: 9 Size: 104 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!  LabOne's Production Reporting Environment - Pre-Historic to Pre-Web
Steven D. Beakley 
Keywords: Production Macro Language internet
Pages: 6 Size: 154 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!  Implementing a Financial Balance Scorecard on Top of SAP R/3 Using CFO Vision as Interface
Ida Carapelle  Sophie De Baets 
Keywords: SAP SAS/ACCESS to R/3 CFO Vision software Finance Balance scorecard R/3 SAS/ACCESS
Pages: 6 Size: 419 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 Data Mart on top of SAP R/3-HR
Christ D'haeveloose 
Keywords: SAP R/3 Human Resource Business Template Balanced Scorecard Data Mart SAS/ACCESS to R3
Pages: 6 Size: 34 Kb 
Best Contributed Paper
tweet!  Migrate to ORACLE? I Need My SAS Software!
Dianne L. Rhodes 
Keywords: relational DBMS OLAP Oracle normalization integrity SAS/ACCESS software
Pages: 5 Size: 105 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!  The Power of Hybrid OLAP in a Multidimensional World
Ann Weinberger  Matthias Ender 
Pages: 5 Size: 205 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!  Convert Your Model T into a Ferrari - Unleash the MDDB
Ian J. Sutton 
Keywords: MDDB Opimization Performance
Pages: 7 Size: 115 Kb 

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

Data Warehousing

tweet!  Constructing a Data Warehouse
Curtis A. Smith 
Keywords: Warehouse Data Library File Storage Efficiencies
Pages: 6 Size: 178 Kb 
tweet!  Knowledge Management-Integrated Solutions for Information Delivery
Kim Foster 
Keywords: EDM Enterprise Data Management Business Intelligence Knowledge Management Data Access Database
Pages: 8 Size: 495 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!  Using Decision Support Services to Fight Crime
Nina Du Thaler  Alexander Stefan 
Pages: 14 Size: 143 Kb 
tweet!  CRM 101:Maximizing Return on Investment with the SAS Solution for CRM
Drury Jenkins 
Keywords: CRM
Pages: 5 Size: 34 Kb 
tweet!  The ABCs of MDDBs
Marge Scerbo 
Keywords: mddb warehouse hierarchy dimension eis warehouse Adminitrator
Pages: 8 Size: 113 Kb 
Best Contributed Paper
tweet!  Using SAS Software as a Decision Support System on Top of SAP FI Financial Accounting Module
Ida R. Carapelle 
Keywords: SAP-FI SAP Financial Accounting
Pages: 5 Size: 52 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!  MDDB Support in Scalable Performance Data Server 2.5
Amitava Ghosh 
Keywords: MDDB SPDS
Pages: 2 Size: 40 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!  An Investigation of Quality-of-Life Issues in Patient Treatment Using Enterprise Miner
Patricia B. Cerrito  Kelly McMasters  Vicki Viar 
Keywords: Medical Decision Making Quality-of-Life Enterprise Miner
Pages: 6 Size: 166 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 
Pages: 13 Size: 146 Kb 
tweet!  What's Up with OLE DB?
Thomas Cox 
Pages: 10 Size: 261 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!  Integrating SAS Products Using Common Metadata
Catherine A. Phipps 
Keywords: metadata repository
Pages: 3 Size: 47 Kb 

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

Data Warehousing

tweet!  Successful Data Warehousing for Telecommunications Business Solutions (The Philos Method)
Demetris Papaiacovou 
Pages: 6 Size: 39 Kb 
tweet!  The ABCs of MDDBs
Marge Scerbo 
Pages: 6 Size: 148 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!  Mining the Data Mart: A Case Study with Stock Market Data
James A. Cox  Tonya L. Etchison 
Pages: 11 Size: 249 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!  Accessing Data from Your PC Using Version 7 of the SAS System, Presented by Michael Ho, SAS Institute Inc.
Roger E. Sanders 
Pages: 1 Size: 19 Kb 
tweet!  Data Extraction Methods in Medium and Large Databases
Anthony M. Dymond 
Pages: 6 Size: 69 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!  Enhanced Data Support Methodology (EDSM): Using Technology for Competitive Advantage for Managed Health Care
William J. Glosenmeyer 
Keywords: healthcare
Pages: 7 Size: 118 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!  Monitoring a Cohort of Blood Donors and Recipients Using SAS/AF Frame
Monique Bryher 
Keywords: af
Pages: 6 Size: 235 Kb 
tweet!  Dun & Bradstreet: Using SAS Software to Solve Customer Purchasing Problems
Christine C. Kelly  Michael B. Smart 
Pages: 6 Size: 44 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!  Data Warehousing and the Web
Jim Davis 
Keywords: internet
Pages: 4 Size: 610 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!  Effective Use and Management of Metadata
Cathy Phipps  Jim Davis 
Pages: 4 Size: 131 Kb 
tweet!  Does a Data Warehouse Deliver the Goods?
Glen Payne 
Keywords: warehouse
Pages: 3 Size: 33 Kb 
Best Contributed Paper
tweet!  Using SAS/CONNECT to Control a Distributed Application
Roger Williams 
Pages: 6 Size: 57 Kb 
tweet!  Building the Framework for Enterprise Data Analysis in the Semiconductor Industry
John T. Stokes  Roger Thompson 
Pages: 6 Size: 46 Kb 
tweet!  Enhancements to SAS/Warehouse Administrator
Terry L. Lewis 
Keywords: warehouse
Pages: 8 Size: 79 Kb 
tweet!  A Flexible System for Conversion of DBF Tables into SAS
Mel Widawski 
Pages: 6 Size: 82 Kb 
tweet!  Version 7 Enhancements to SAS/ACCESS Software
Vino Gona  Jana Van Wyk 
Pages: 10 Size: 123 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!  Developing Risk-Adjustment Models Using SAS Software: An Application in Home Health Care
Ding Alonzo  Albert Alva 
Keywords: healthcare
Pages: 4 Size: 40 Kb 
tweet!  The Future Interface to the SAS System for PCs - A First Glance
Carol Rigsbee 
Pages: 2 Size: 22 Kb 

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

Data Warehousing

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!  DW + DM = $avings
Robert J. Scharl  Paul M. Centric 
Pages: 7 Size: 21 Kb 
tweet!  Loading SAS Data in Informix: An Integrated Approach
M. Kumar Sagar 
Pages: 6 Size: 27 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!  Beyond Field Validation: Incorporating the Batch Edit Into the Total Data System
John Quarantillo  Judy Rayner 
Pages: 3 Size: 23 Kb 
tweet!  Using SAS/AF for Managing Clinical Data
Carl R. Haske 
Keywords: clinical af
Pages: 6 Size: 156 Kb 
tweet!  On Time and Under Budget: Guidelines for Success Using the SAS System with Traditional Structured Techniques
Marc Daniels  Clark Roberts 
Pages: 4 Size: 697 Kb 
tweet!  Survival Strategies and Solutions for the New Millennium - Year 2000
Kirk P. Lafler  Sunil K. Gupta  Charles E. Shipp 
Pages: 5 Size: 27 Kb 
tweet!  The SAS Data Warehouse, a Real World Example.
Martin P. Bourque 
Keywords: warehouse
Pages: 6 Size: 37 Kb 
tweet!  Data Mining
Mark Brown  John Brocklebank 
Pages: 4 Size: 11 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!  Structuring Your Data Warehousing Project: Moving from the Concept to the Reality
Peter R. Welbrock 
Pages: 8 Size: 737 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!  Introduction to SAS/ACCESS Software.
Dana Rafiee 
Pages: 2 Size: 143 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 
Best Contributed Paper
tweet!  Information Delivery - A Project Management Approach
Kim Foster 
Pages: 6 Size: 46 Kb 

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

Database Management Facilities

tweet!  A Relational Database Primer for SAS Programmers
Paul Dalberth 
Pages: 8 Size: 468 Kb 
tweet!  Using SAS Views for Data Source Visualization
Steve A. Wilson 
Pages: 10 Size: 726 Kb 
tweet!  FRAME Your View of Data with the SQL Procedure
Kirk Paul Lafler 
Keywords: SQL
Pages: 4 Size: 256 Kb 
tweet!  SAS Connections to DB2: Tools and Techniques
Judy Loren 
Pages: 10 Size: 542 Kb 
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!  Joining Strategies Access to All Data
Caroline Bahler  Stephen Clos 
Pages: 5 Size: 272 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!  Data Transfer between SAS Software and Other PC Software
Michael Miscisin 
Pages: 5 Size: 345 Kb 
tweet!  ODBC: Windows to the Outside World
David Riba  Elisabeth A. Riba 
Pages: 10 Size: 4058 Kb 
tweet!  Configuring and Using ODBC with SAS/ACCESS Software
Forrest Boozer 
Pages: 10 Size: 2535 Kb 
tweet!  Rollback of SAS Relational Databases to Former Historical States
Keith Adams 
Pages: 5 Size: 326 Kb 
tweet!  Strategic Uses of SAS DATA Step Programming and SQL Passthrough to Query ORACLE Databases
Henry W. Buffum 
Keywords: SQL
Pages: 6 Size: 341 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.