Home
Contact
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
Loading
SAS SUGI proceedings: SQL (SUGI 31 and later), 203 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 2017   April 2-5, 2017 - Orlando, Florida

tweet!  Patching the Holes in SQL Systems with SAS®
   Chris Carson 
Keywords: SQL
Pages: 16 Size: 651 Kb 
tweet!  Quick Results with PROC SQL
   Kirk Paul Lafler 
Keywords: SAS, SQL, PROC SQL, sql basics, proc sql basics, intro sql, intro proc sql, quick results sql, quick results proc sql, query, sql query, case expression, case sql, view, join, sql join, join sql, i ...
Pages: 20 Size: 1124 Kb    Download the data filedownload (.zip, 3623 Kb)
tweet!  Advanced Programming Techniques with PROC SQL
   Kirk Paul Lafler 
Keywords: SAS, SQL, PROC SQL, sql basics, proc sql basics, intro sql, intro proc sql, quick results sql, quick results proc sql, query, sql query, case expression, case sql, view, join, sql join, join sql, i ...
Pages: 20 Size: 1125 Kb    Download the data filedownload (.zip, 3563 Kb)
tweet!  Something for Nothing? Adding Flag Variables Using Group Descriptive Statistics and PROC SQL
   Sunil Gupta 
Keywords: SQL
Pages: 8 Size: 768 Kb 

    resource Additional resource: Watch on Demand Video


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

tweet!  High-Performance Data Access with FedSQL and DS2
   Shaun Kaufmann 
Keywords: SQL
Pages: 13 Size: 65 Kb 
tweet!  The Fantastic Four: Running Your Report Using the TABULATE, TRANSPOSE, REPORT, or SQL Procedure
   Josh Horstman 
Keywords: SQL tabulate
Pages: 13 Size: 585 Kb 
tweet!  PROC SQL for SQL DieHards
   Barbara Ross  Jessica Bennett 
Keywords: QT06 SQL
Pages: 9 Size: 382 Kb 
tweet!  Architecting Data Management: Seven Principles Using SAS®, DataFlux®, and SQL
   Bob Janka 
Keywords: SQL
Pages: 20 Size: 492 Kb 
tweet!  PROC DS2 with Both Hands on the Wheel
   Peter Eberhardt  Xue Yao 
Keywords: DS2 method package array FCMP function null date SQL datatype
Pages: 32 Size: 1095 Kb 
tweet!  Mastering Data Summarization with PROC SQL
   Christianna Williams 
Keywords: SQL
Pages: 20 Size: 479 Kb 
tweet!  SAS® Debugging 101
   Kirk Paul Lafler 
Keywords: SAS, error, errors, warning, warnings, SAS log, log, debug, debugging, sas debugging, sas debugging techniques, Benchworkzz, consultant, sas consultant, sas consulting, sql, sql consultant, sql con ...
Pages: 13 Size: 1256 Kb 

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

tweet!  Something for Nothing? Adding Group Descriptive Statistics Using SAS® PROC SQL Subqueries II
   Sunil Gupta 
Keywords: SQL
Pages: 10 Size: 750 Kb 
tweet!  Hands-on SAS® Macro Programming Essentials for New Users
   Kirk Paul Lafler 
Keywords: SAS, Macro Language, macro, keyword macro, positional macro, SQL, SQL procedure, consultant, SAS consultant, consulting, SAS consulting, sql, sql consultant, sql consulting, author, sas author, sas ...
Pages: 10 Size: 608 Kb 
tweet!  DS2 with Both Hands on the Wheel
   Peter Eberhardt  Xue Yao 
Keywords: DS2 method package array FCMP function null date SQL datatype
Pages: 32 Size: 276 Kb 
tweet!  PROC SQL for PROC SUMMARY Stalwarts
   Christianna Williams 
Keywords: SQL
Pages: 19 Size: 490 Kb 
tweet!  Best Practices: Subset without Getting Upset
   Mary Rosenbloom  Kirk Paul Lafler 
Keywords: SAS subset subsetting by-group by-group processing subgroup analysis best practice SQL SAS SQL PROC SQL joins LEFT join Coalesce Rosenbloom Lafler
Pages: 17 Size: 190 Kb 
tweet!  Performing Efficient Transposes on Large Teradata Tables Using SQL Explicit Pass-Through
   Tao Cheng 
Keywords: SQL
Pages: 17 Size: 172 Kb 
tweet!  PROC RANK, PROC SQL, PROC FORMAT, and PROC GMAP Team Up and a (Map) Legend Is Born!
   Christianna Williams  Louise Hadden 
Keywords: SQL
Pages: 20 Size: 558 Kb 
tweet!  Working with PROC FEDSQL in SAS® 9.4
   Zabiulla Mohammed  Ganesh Kumar Gangarajula  Pradeep Reddy Kalakota 
Keywords: SQL
Pages: 8 Size: 294 Kb 
tweet!  Nifty Uses of SQL Reflexive Join and Subquery in SAS®
   Cynthia Trinidad 
Keywords: SQL
Pages: 5 Size: 58 Kb 

SAS Global Forum 2014   March 23-26, 2014 - Washington, DC

tweet!  Powerful and Hard-to-find PROC SQL Features
   Kirk Paul Lafler 
Keywords: SAS PROC SQL SQL queries case logic views Dictionary tables macro variables joins query performance tuning Lafler Kirk Lafler Kirk Paul Lafler @sasNerd
Pages: 19 Size: 1094 Kb 
tweet!  Adding Serial Numbers to SQL Data
   Howard Schreier 
Keywords: SQL
Pages: 14 Size: 250 Kb 
tweet!  I Object: SAS® Does Objects with DS2
   Peter Eberhardt  Xue Yao 
Keywords: DS2 method object oriented abstraction local global SQL HPA
Pages: 27 Size: 203 Kb 
tweet!  Exploring DATA Step Merges and PROC SQL Joins
   Kirk Paul Lafler 
Keywords: merge join merge vs. join DATA step PROC SQL SQL Cartesian Product match-merge outer join Hash hash hash object hash methods methods Lafler Kirk Lafler Kirk Paul Lafler @sasNerd
Pages: 14 Size: 1231 Kb 
tweet!  Top 10 SQL Tricks in SAS®
   Chao Huang 
Keywords: SQL
Pages: 4 Size: 275 Kb 
tweet!  Generating Dynamic Tables Using PROC SQL and PROC TABULATE
   Lovedeep Gondara 
Keywords: SQL tabulate
Pages: 8 Size: 533 Kb 

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

tweet!  The SQL Tuning Checklist: Making Slow Database Queries a Thing of the Past
   Jeff Bailey  Tatyana Petrova 
Keywords: SQL
Pages: 13 Size: 444 Kb 
tweet!  Hands-On SAS® Macro Programming Tips and Techniques
   Kirk Paul Lafler 
Keywords: SAS Macro Language macro keyword macro positional macro SQL SQL procedure Lafler Kirk Lafler Kirk Paul Lafler @sasNerd
Pages: 9 Size: 589 Kb 
tweet!  Ready to Become Really Productive Using PROC SQL?
   Sunil Gupta 
Keywords: Where IF SQL
Pages: 20 Size: 604 Kb 
tweet!  Exploring the PROC SQL _METHOD Option
   Charlie Shipp  Kirk Paul Lafler 
Keywords: 200-2013 SAS PROC SQL SQL SQL procedure _METHOD _METHOD option Log messages Lafler Kirk Lafler Kirk Paul Lafler @sasNerd Shipp Charlie Shipp Charles Edwin Shipp @ShippAhoy
Pages: 4 Size: 408 Kb    Download the posterdownload (.pdf, 469 Kb)

    resource Additional resource: sasCommunity.org

tweet!  Top 10 Most Powerful Functions for PROC SQL
   Chao Huang  Yu Fu 
Keywords: SQL
Pages: 5 Size: 324 Kb 

    resource Additional resource: Video

tweet!  Something for Nothing? Adding Group Descriptive Statistics Using PROC SQL Subqueries
   Sunil Gupta 
Keywords: SQL
Pages: 8 Size: 568 Kb 

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

tweet!  Three Simple Steps to Recovering and Inserting Data Using Do Loops, Indexed Macro Variables, and PROC SQL Update Statements
   Stacey D. Collins 
Keywords: SQL macro
Pages: 4 Size: 164 Kb 
tweet!  Queries, Joins, and WHERE Clauses, Oh My!! Demystifying PROC SQL
   Christianna Williams 
Keywords: SQL
Pages: 37 Size: 279 Kb 
tweet!  Exploring DATA Step Merges and PROC SQL Joins
   Kirk Paul Lafler 
Keywords: merge join merge vs. join DATA step SQL Cartesian Product match-merge outer join Hash hash hash object hash methods methods Lafler Kirk Lafler Kirk Paul Lafler
Pages: 14 Size: 899 Kb 

    resource Additional resource: Take Out Video


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

tweet!  Explicit SQL Pass-Through: Is It Still Useful?
   Frank Capobianco 
Keywords: SQL Pass-Through SAS/ACCESS
Pages: 5 Size: 80 Kb 
tweet!  To Hash or Not To Hash! That Is the Question!! When it Comes to SQL!!!
   Mustaq Ahmad 
Keywords: SQL
Pages: 12 Size: 279 Kb 
tweet!  Ready to Become Really Productive Using PROC SQL?
   Sunil Gupta 
Keywords: SQL
Pages: 18 Size: 160 Kb 
tweet!  What's Hot, What's Not: Skills for SAS® Professionals
   Kirk P. Lafler  Charles E. Shipp 
Keywords: SAS skills, what's hot, what's not so Hot, Enterprise Guide, hash objects, ODS, PROC SQL, PROC REPORT, Macro Language, Dictionary Tables, BI, SAS/XML, sasCommunity, SAS-L, certification, JMP softwa ...
Pages: 6 Size: 426 Kb 

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

tweet!  Eliminating Redundant Custom Formats (or How to Really Take Advantage of PROC SQL, PROC CATALOG, and the DATA Step)
   Philip A. Wright 
Keywords: SQL
Pages: 18 Size: 152 Kb 
tweet!  Yes, PROC SQL Is Great, But I Love DATA Step Programming: What's a SAS® User to Do?
   Mira Shapiro 
Keywords: SQL
Pages: 4 Size: 78 Kb 
tweet!  Using the SQL Procedure to Summarize and Transpose Data
   Kevin Chung 
Keywords: SQL
Pages: 8 Size: 86 Kb 
tweet!  Exploring Powerful Features in PROC SQL
   Kirk P. Lafler 
Keywords: SQL
Pages: 17 Size: 740 Kb 
tweet!  Look What's New in SAS/ACCESS®: New Engines and SQL Optimization
   Howard Plemmons 
Keywords: SQL
Pages: 16 Size: 388 Kb 

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

tweet!  So, You've Got Data Enterprise Wide (SAS®, ACCESS, EXCEL, MySQL, and Others); Well, Let SAS® Enterprise Guide® Software Point-n-Click Your Way to Using It
   William E. Benjamin Jr 
Keywords: SQL enterprise guide
Pages: 10 Size: 1632 Kb 
tweet!  Exploring PROC SQL Joins and Join Algorithms
   Kirk P. Lafler 
Keywords: SQL
Pages: 6 Size: 57 Kb 
tweet!  MERGING vs. JOINING: Comparing the DATA Step with SQL
   Malachy (Mal) Foley 
Keywords: SQL
Pages: 17 Size: 57 Kb 
tweet!  Let SQL Write SQL Scripts for You – Counts Report
   Christine Teng 
Keywords: SQL
Pages: 5 Size: 81 Kb 
tweet!  A Propaedeutics for PROC SQL Joins
   Lisa A. Mendez  Toby Dunn 
Keywords: SQL
Pages: 9 Size: 109 Kb 
tweet!  Exploring the Undocumented PROC SQL _METHOD Option
   Kirk P. Lafler 
Keywords: SQL
Pages: 2 Size: 38 Kb 
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!  Simple Applications of SQL
   Howard Schreier 
Keywords: SQL
Pages: 17 Size: 95 Kb 
tweet!  PROC SQL and SAS® Macro: Beyond the Basics
   Louie Huang 
Keywords: SQL macro
Pages: 8 Size: 118 Kb 
tweet!  Dear Ms. SAS® Answers: A Guide to Efficient PROC SQL Coding
   Linda Jolley  Jane Stroupe 
Keywords: SQL
Pages: 1 Size: 17 Kb    Download the updated paperdownload (.pdf, 3403 Kb)

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

tweet!  Getting Started with SAS/IntrNet® - A Quick and Dirty Tutorial
   Gabe Cano 
Keywords: APPSTART.SAS SAS/SHARE htmSQL web
Pages: 11 Size: 358 Kb 
tweet!  Using Excel XP to Display SDTM Metadata and More
   Christine Teng  Shaoan Yu 
Keywords: ExcelXP Tagset SAS Dictionary PROC SQL
Pages: 8 Size: 182 Kb 
tweet!  Existential Moments in Database Programming: SAS® PROC SQL EXISTS and NOT EXISTS Quantifiers, and More
   Sigurd Hermansen  Stanley E. Legum 
Keywords: UPDATE query predicate logic logical conditions SQL
Pages: 6 Size: 75 Kb 
tweet!  Labor-Saving SQL Constructs
   Brian Fairfield-Carter  David Carr 
Keywords: SQL
Pages: 10 Size: 231 Kb 
tweet!  It's a Bird, It's a Plane, It's SQL Transpose!
   Ted Conway 
Keywords: sql transpose database
Pages: 5 Size: 489 Kb 
tweet!  Exploring the Undocumented PROC SQL _METHOD Option
   Kirk P. Lafler 
Keywords: PROC SQL SQL _METHOD query tuning
Pages: 2 Size: 40 Kb 
tweet!  Using the SAS® DATA Step and PROC SQL to Create Macro Arrays
   Stuart Long  Edward Heaton 
Keywords: Macro Array SQL
Pages: 11 Size: 69 Kb 
tweet!  The Perfect Baby Name: One Dad's Quest Using SAS®
   Chris Hemedinger 
Keywords: enterprise guide query social security sql
Pages: 7 Size: 183 Kb 
Best Contributed Paper
tweet!  Getting SAS® to Play Nice with Others: Connecting SAS® to a Microsoft SQL Server with an ODBC Connection
   Candice Riley 
Keywords: SQL
Pages: 6 Size: 41 Kb 
tweet!  Joining Data: DATA Step Merge or SQL?
   Faisal Dosani  Harry Droogendyk 
Keywords: SQL
Pages: 19 Size: 270 Kb 
tweet!  Hidden Tools You Didn't Know You Had: Code-Generating Windows
   Janet Stuelpner 
Keywords: SQL Query Report Import Export Wizard
Pages: 6 Size: 371 Kb 
tweet!  PROC SQL for DATA Step Die-Hards
   Christianna Williams 
Keywords: SQL
Pages: 17 Size: 141 Kb 
tweet!  New SQL Performance Optimizations to Enhance Your SAS® Client and Solution Access to the Database
   Mike Whitcher 
Keywords: Implicit pass-thru SQL
Pages: 1 Size: 17 Kb 

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

tweet!  Journeyman's Tools: Data Review Macro FREQALL - Using PROC SQL List Processing with Dictionary.Columns to Eliminate Macro DO Loops
   Ronald J. Fehd 
Keywords: data review dynamic programming list processing do loop macro SQL
Pages: 10 Size: 137 Kb    Download the LATEX Beamer presentationdownload (.pdf, 129 Kb)
Best Contributed Paper
tweet!  Changing Data Set Variables into Macro Variables
   William C. Murphy 
Keywords: Macro CALL SET %SYSFUNC CALL SYMPUT DATA _NULL_ PROC SQL
Pages: 4 Size: 63 Kb 
tweet!  Data on Demand with SAS® Enterprise Guide®: A Cheap and Easy Approach to Real-Time Database Access
   Richard F. Pless 
Keywords: ODBC Enterprise Guide SQL Server
Pages: 11 Size: 1082 Kb 
tweet!  PROC SQL - The Dark Side of SAS®?
   Kirsty R. Lauderdale 
Keywords: SET MERGE IF OUTER JOIN FULL JOIN INNER JOIN RIGHT JOIN LEFT JOIN CASE and INTO SQL
Pages: 5 Size: 200 Kb 
tweet!  Calculating Statistics Using PROC MEANS versus PROC SQL
   Jyotheeswara N. Yellanki 
Keywords: FREQ VAR WAYS WEIGHT GROUP BY ORDER BY DISTINCT SQL
Pages: 8 Size: 130 Kb 
tweet!  Demeter in the Database
   Paul D. Sherman 
Keywords: SQL query database beancounting data modeling
Pages: 8 Size: 187 Kb 
tweet!  A Hands-On Tour inside the World of PROC SQL
   Kirk P. Lafler  Ben T. Cochran 
Keywords: SQL PROC SQL queries case logic views joins
Pages: 13 Size: 76 Kb    Download the codedownload (.zip, 318 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!  How Do I Look It Up If I Don't Know How to Spell It? An Introduction to SAS® DICTIONARY Tables
   Peter W. Eberhardt  Ilene K. Brill 
Keywords: SQL MACRO BASE DICTIONARY
Pages: 14 Size: 70 Kb 
tweet!  DATA Step vs. PROC SQL - What's a Neophyte to Do?
   Ray Pass  Michael L. Davis  Craig Dickstein 
Keywords: data sql programmer step proc
Pages: 12 Size: 185 Kb 
tweet!  Talking to Your RDBMS Using SAS/ACCESS®
   Dianne Louise Rhodes 
Keywords: Access SQL Pass-Through Hints Bulkload
Pages: 15 Size: 143 Kb 

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

tweet!  Making Your Own Balanced Scorecard Using the SAS® Information Delivery Portal
   Paul Smeekens  Erwin van Dongen 
Keywords: SQL .Net SAS AppDev Studio
Pages: 10 Size: 790 Kb 
tweet!  The SQL Procedure: When and How to Use It
   Ying Feng 
Keywords: PROC SQL DATA Step SAS
Pages: 7 Size: 66 Kb 
tweet!  Using Metadata and Project Data for Data-Driven Programming
   Brian K. Varney 
Keywords: Macro SQL Stored Processes Base SAS
Pages: 10 Size: 143 Kb 
tweet!  DIGITS and DATES - The SQL Procedure Goes "Loopy"
   Jack Hamilton 
Keywords: SQL DIGITS DATES
Pages: 11 Size: 71 Kb 
tweet!  A Powerful Macro to Control Title Appearance in SAS/GRAPH® Output
   Louie Huang 
Keywords: SAS/GRAPH Macro PDF CGM PORC IMPORT PROC SQL
Pages: 8 Size: 225 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!  Intermediate and Advanced SAS® Macros
   Steven J. First  Katie M. Ronk 
Keywords: macro sql
Pages: 16 Size: 53 Kb 
tweet!  A Hands-On Tour Inside the World of PROC SQL
   Kirk P. Lafler 
Keywords: SQL PROC SQL case logic queries views joins
Pages: 11 Size: 70 Kb 
tweet!  Using Data Set Options in PROC SQL
   Kenneth W. Borowiak 
Keywords: natural join in-line view SQL
Pages: 10 Size: 140 Kb 
tweet!  Getting Your Random Sample in PROC SQL
   Richard Severino 
Keywords: SQL
Pages: 14 Size: 3653 Kb 
tweet!  PROC SQL: A Powerful Tool to Improve Your Data Quality
   Keh-Dong Shiang 
Keywords: Data Validation Data Audit Quality Assurance SQL
Pages: 10 Size: 112 Kb 
tweet!  SQL Set Operators: So Handy Venn You Need Them
   Howard Schreier 
Keywords: SQL
Pages: 18 Size: 225 Kb 
tweet!  The SQL Procedure - A Primer for SAS® Programmers
   Jimmy A. DeFoor 
Keywords: SQL Having Clauses Equijoins Inner Joins Outer Joins Cartesian Joins Subqueries In-Line Views Case Statements Match-Merges Sum functions
Pages: 17 Size: 288 Kb 
tweet!  How Do I Look It Up If I Cannot Spell It: An Introduction to SAS® DICTIONARY Tables
   Peter W. Eberhardt  Ilene K. Brill 
Keywords: base SQL
Pages: 11 Size: 68 Kb 

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

tweet!  Spicing Up SAS/IntrNet Applications
   Jonah P. Turner 
Keywords: htmSQL ODS web
Pages: 15 Size: 482 Kb 
tweet!  Storing and Using a List of Values in a Macro Variable
   Art Carpenter 
Keywords: Macro variables %SCAN &&VAR&I PROC SQL INTO CALL SYMPUT
Pages: 6 Size: 130 Kb 
tweet!  What Would I Do without PROC SQL and the Macro Language?
   Jeffrey M. Abolafia 
Keywords: Base SAS SQL macro
Pages: 5 Size: 204 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 
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!  An Introduction to SQL in SAS®
   Pete Lund 
Keywords: SQL
Pages: 22 Size: 999 Kb 
tweet!  Manipulating Data with PROC SQL
   Kirk Paul Lafler 
Keywords: PROC SQL data manipulation
Pages: 8 Size: 286 Kb 
tweet!  Rules for Tools - The SAS Utility Primer
   Frank DiIorio 
Keywords: utilities macros sql dictionary tables program design
Pages: 19 Size: 396 Kb 

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

tweet!  Developing a System with SAS/IntrNet, Accessing an Oracle Database, Some ODS and a Whole Lot of Problems
   Gabriel Cano  Bob Cameron  Kevin McGowan  Jean Orelien 
Keywords: SAS/IntrNet SQL ODS web
Pages: 11 Size: 217 Kb 
tweet!  Top Ten Reasons to Use PROC SQL
   Weiming Hu 
Keywords: SQL ORACLE
Pages: 6 Size: 221 Kb 
tweet!  Creating Efficient SQL - Union Join without the Union Clause
   Paul D. Sherman 
Keywords: RDBMS SQL
Pages: 8 Size: 170 Kb 
Honorable Mention
tweet!  Subsetting SAS Data Set by Using PROC SQL Self-join with Compound Key
   Zizhong Fan 
Keywords: SQL self-join
Pages: 4 Size: 255 Kb 
tweet!  ARRAY: Construction and Usage of Arrays of Macro Variables
   Ronald Fehd 
Keywords: array Array Contents delimiter loop macro ParmBuff scan Qscan symput SysPbuff until SQL
Pages: 6 Size: 101 Kb 
tweet!  Linking Unlinked Data: PROCs SQL and SORT Can Do It
   Merle E. Hamburger  Thomas Sukalac 
Keywords: Longitudinal data SQL
Pages: 4 Size: 26 Kb 
tweet!  Efficiency Techniques for Beginning PROC SQL Users
   Kirk Paul Lafler 
Keywords: SQL queries efficiency
Pages: 10 Size: 57 Kb 
tweet!  Bells and Whistles for One-Line Text Box to Create a Smarter Where Clause
   Ted J. Guo 
Keywords: SAS/IntrNet htmSQL Application Dispatcher JavaScript
Pages: 12 Size: 104 Kb 
Best Contributed Paper
tweet!  SAS Enterprise Guide - A Quick Overview of Developing, Creating, and Successfully Delivering a Simple Project
   Ajaz (AJ) E. Farooqi 
Keywords: Enterprise Guide SQL Data Step FTP Point-and-Click
Pages: 8 Size: 175 Kb 
tweet!  Dictionary Tables and Views: Essential Tools for Serious Applications
   Jeffrey Martin Abolafia  Frank DiIorio 
Keywords: SQL MACRO
Pages: 19 Size: 484 Kb 
tweet!  Using Meta and Project Data for Data Driven Programming (Updated for SAS 8 & SAS 9)
   Brian K. Varney 
Keywords: sql macro scl pipes
Pages: 8 Size: 35 Kb 
tweet!  Introduction to PROC SQL
   Katie M Ronk 
Keywords: SQL
Pages: 13 Size: 83 Kb 
tweet!  DATA Step vs. PROC SQL: What's a Neophyte to Do?
   Craig Dickstein  Ray Pass 
Keywords: PROC SQL Data Step RDBMS
Pages: 12 Size: 101 Kb 
tweet!  Improve Your Queries: Hints and Tips for Using SQL
   Marje Fecht  Linda A. Mitterling 
Keywords: SQL JOINS
Pages: 10 Size: 265 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!  Undocumented and Hard-to-Find SQL Features
   Kirk Paul Lafler 
Keywords: SQL
Pages: 6 Size: 270 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!  Make Your SAS/ACCESS® Query More Efficient
   Jianming He  Dinesh Jain  Cheng Wang 
Keywords: Data query SQL Relational Database SYBASE
Pages: 3 Size: 183 Kb 
tweet!  Comparative Efficiency of SQL and Base Code When Reading from Database Tables and Existing Data Sets
   Steven Feder 
Keywords: SQL Efficiency Base Benchmark
Pages: 5 Size: 173 Kb 
tweet!  Automatically Combining the Data from a Variety of DBMSs with ODBC and PROC SQL
   Han Wu  Jason Au  Craig Toyota 
Keywords: ODBC PROC SQL DBMS
Pages: 3 Size: 194 Kb 
tweet!  Automatic Data File Retrieval from Different Database Engines
   Xin Zhang  Chuanchieh Hsu 
Keywords: SAS/ACCESS PROC SQL ODBC macro
Pages: 3 Size: 196 Kb 
tweet!  PROC SQL vs. Merge - The Miller Lite Question of 2002 and Beyond
   Kevin J. Smith  Muhammad Z. Khan  Yadong Zhang 
Keywords: SQL Merge Benchmark Performance Hashing Efficiency
Pages: 4 Size: 178 Kb 
tweet!  An Efficient Approach to Combine SAS® Data Sets with Voluminous Variables That Need Name and Other Changes
   Grace Chiu  Edward Heaton 
Keywords: rename sql append
Pages: 5 Size: 168 Kb 
tweet!  Combining Summary Level Data with Individual Records
   Frank J. Ivis 
Keywords: summary records SET SQL
Pages: 3 Size: 158 Kb 
tweet!  Renaming All Variables in a SAS® Data Set Using the Information from PROC SQL's Dictionary Tables
   Prasad S. Ravi 
Keywords: PROC SQL DICTIONARY TABLES DICTIONARY COLUMNS PROC DATASETS
Pages: 3 Size: 143 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 

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

tweet!  Table Look-up: Techniques Beyond the Obvious
   Henri Theuwissen  Nancy Croonen 
Keywords: Efficiency Table Look-Up Macro Call Execute SQL
Pages: 9 Size: 160 Kb 
tweet!  Improve Your Queries: Hints and Tips for Using SQL
   Marje Fecht  Linda A. Walters 
Keywords: SQL Efficiency
Pages: 1 Size: 67 Kb 
Honorable Mention
tweet!  Ask DSS ... Using HTML, JavaScript, htmSQL, and SAS® to Create Dynamic Web Applications
   Karen L. Wyland 
Keywords: SAS/IntrNet htmSQL Javascript internet html
Pages: 6 Size: 261 Kb 
tweet!  A Secure Online Data Validation & Collection System for HEDIS Survey Data
   Christopher A. Roper 
Keywords: HEDIS Web Data Validation ASP SQL Server
Pages: 9 Size: 93 Kb 
tweet!  DATA Step vs. PROC SQL: What's a Neophyte to Do?
   Craig Dickstein  Ray Pass 
Keywords: SQL Data Step data management
Pages: 9 Size: 194 Kb 
tweet!  An Introduction to SAS® PROC SQL
   Timothy J. Harrington 
Keywords: SQL Create Join View Dictionary
Pages: 6 Size: 41 Kb 
tweet!  Using the Magical Keyword 'INTO:' in PROC SQL
   Thiru Satchi 
Keywords: INTO: host-variable macro arrays SQL
Pages: 7 Size: 146 Kb 
Best Contributed Paper
tweet!  A Visual Introduction to SQL Joins
   Kirk P. Lafler 
Keywords: SQL joins Cartesian Product Inner join combining data queries
Pages: 3 Size: 134 Kb 
tweet!  Creating Efficient SQL - Four Steps to a Quick Query
   Paul D. Sherman 
Keywords: SQL query pass-through table select
Pages: 5 Size: 156 Kb 
tweet!  Taking Advantage of Missing Values in PROC SQL
   Ya Huang 
Keywords: Proc SQL Summary function missing value
Pages: 3 Size: 116 Kb 
tweet!  Finally - An Easy Way to Compare Two SAS® Files!
   Doug Zirbel 
Keywords: SQL Dictionary
Pages: 5 Size: 90 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!  An Introduction to PROC SQL
   Steven First  Katie Minten Ronk 
Keywords: sql base
Pages: 11 Size: 90 Kb 
tweet!  Table Look-up Using Techniques Other Than the Matched Merge DATA Step
   Sandra L. Aker 
Keywords: merge index SQL format
Pages: 6 Size: 137 Kb 
tweet!  Making SAS® Dates from All Your Character Dates ... No Pixie Dust Required
   Jeanina M. Worden 
Keywords: date macro SYMPUT LOOP SQL dictionary table
Pages: 2 Size: 111 Kb 
tweet!  10 Things Experienced SAS® Programmers Don't Know - But Should
   Doug Zirbel 
Keywords: SQL Dictionary
Pages: 2 Size: 91 Kb 

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

tweet!  You Could Look It Up: An Introduction to SASHELP Dictionary Views
   Michael L. Davis 
Keywords: SASHELP views dictionary SQL
Pages: 10 Size: 67 Kb 
tweet!  Walk Our Children to School: An Internet Data Management Application
   Carol A. Martell 
Keywords: SAS/IntrNet htmSQL dispatcher web graph imagemap internet
Pages: 6 Size: 404 Kb 
tweet!  Using ORACLE XSQL Servlet to Access a SAS Database: Simplifying the XML Development Process
   Michael W. Deines 
Keywords: XML XSL Servlet Oracle SAS/SHARE SQL
Pages: 3 Size: 21 Kb 
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!  PROC SQL - Is It a Required Tool of Good SAS Programming?
   Ian Whitlock 
Keywords: SQL Macro List processing
Pages: 6 Size: 53 Kb 
tweet!  DATA Step vs. PROC SQL: What's a Neophyte to Do?
   Craig Dickstein  Ray Pass 
Keywords: data step proc sql
Pages: 9 Size: 204 Kb 
tweet!  A SAS Macro to Isolate All Date Values from a Data Library into a SAS Dataset
   Michael L. White 
Keywords: SQL Macro SAS dates
Pages: 2 Size: 32 Kb 
tweet!  Merging Tables in DATA Step vs. PROC SQL: Convenience and Efficiency Issues
   Gajanan Bhat  Raj Suligavi 
Keywords: Efficiency SQL Data Step
Pages: 4 Size: 44 Kb 
tweet!  Tips for Using PROC SQL to Extract Information from Medical Claims Data Sets
   Clayton Wells 
Keywords: SQL transpose count function
Pages: 4 Size: 121 Kb 
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!  Joining SAS and DBMS Tables Efficiently
   Garth W. Helf 
Keywords: dbkey dbindex index DBMS SQL join
Pages: 6 Size: 162 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!  An Introduction to PROC SQL
   David Beam 
Keywords: SQL select join
Pages: 10 Size: 164 Kb 

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

tweet!  Notes from the Outer Limits of 4GL RDBMS/SQL: The SAS System to the Rescue
   Sigurd W. Hermansen 
Keywords: SAS SQL RDBMS database
Pages: 6 Size: 126 Kb 
tweet!  Version 8 Base SAS Performance: How Does It Stack Up?
   Robert Ray 
Keywords: SAS base Performance DATA Step SQL SORT SUMMARY
Pages: 7 Size: 351 Kb 
tweet!  Introduction to PROC SQL
   Rosalind K. Gusinow 
Keywords: PROC SQL Join Percent
Pages: 11 Size: 116 Kb 
tweet!  Using Metadata for Data Driven Programming
   Brian K. Varney 
Keywords: dictionary tables macro SQL Version 8
Pages: 4 Size: 60 Kb 
tweet!  Removing Duplicates: PROC SQL Can Help You 'See'
   Vicki J. Siemers  Brian F. Nash 
Keywords: Duplicates PROC SQL
Pages: 2 Size: 98 Kb 
tweet!  Make Room for Me
   Gregory E. Taylor 
Keywords: Macro PROC SQL Dictionary.Tables Dictionary.Columns Charlib1
Pages: 3 Size: 43 Kb 
tweet!  Merges and Joins
   Timothy J. Harrington 
Keywords: merge join key sql
Pages: 6 Size: 100 Kb 
tweet!  Scaling Mount GCHART: Using a MACRO to Dynamically Reset the Scale
   Nina L. Werner 
Keywords: MACRO GCHART SQL MAX SAS/ACCESS to Sybase SAS/CONNECT software
Pages: 5 Size: 170 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!  Security on the Web using SAS/IntrNet Software and HTML
   Ming C. Lee 
Keywords: Security Web Internet SQL html
Pages: 5 Size: 209 Kb 
tweet!  Using the Magical Keyword 'INTO:' in PROC SQL
   Thiru Satchi 
Keywords: SQL INTO: Macro List
Pages: 8 Size: 196 Kb 
tweet!  Automating the Selection of Controls in Case-Control Studies
   Thiru Satchi  Edgar L. Mounib 
Keywords: case-control study matching macro SQL
Pages: 6 Size: 191 Kb 

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

tweet!  Relational Database Schemes and SAS Software SQL Solutions
   Sigurd W. Hermansen 
Keywords: SQL database design model integrity key
Pages: 9 Size: 56 Kb 
tweet!  SQL Query Window Classes: How to Incorporate the SQL Column Expression Builder Class In Custom SAS/AF Applications
   Christopher A. Roper 
Keywords: SQL Query Calculated Column Builder af
Pages: 5 Size: 56 Kb 
tweet!  Performance Enhancements to PROC SQL in Version 7 of the SAS System
   Lewis Church 
Keywords: PROC SQL
Pages: 6 Size: 36 Kb 
tweet!  What Your Mother Never Told You About the Query Window
   Janet E. Stuelpner 
Keywords: SQL Query Window
Pages: 3 Size: 21 Kb 
tweet!  An Introduction to PROC SQL
   David E. Beam 
Keywords: SQL WHERE SELECT HAVING GROUP
Pages: 10 Size: 68 Kb 
tweet!  Use PROC SQL to Collapse Cells - It's Easy
   Tamara M. Hagemeier  Yue-Hwa C. Chang 
Keywords: SQL Collapsing Cells
Pages: 4 Size: 40 Kb 
Honorable Mention
tweet!  Managing Your SAS Web Applications by Using Web Page Counters Created Through SAS/IntrNet Software
   Heather M. Tavel 
Keywords: SAS/Intrnet htmSQL Application Dispatcher internet web
Pages: 3 Size: 25 Kb 
tweet!  Efficiency Techniques: SQL vs. Retain Variables
   Danielle Gao 
Keywords: SQL vs. Traditional Programming
Pages: 3 Size: 27 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!  An Introduction to PROC SQL
   David E. Beam 
Keywords: SQL WHERE SELECT HAVING GROUP
Pages: 10 Size: 68 Kb 
Honorable Mention
tweet!  An SQL List Macro to Retrieve Data from Large SAS/DB2 Databases
   Thiru Satchi 
Keywords: SAS/ACCESS Pass Through DB2 SAS Macro SQL
Pages: 6 Size: 51 Kb 
tweet!  Submitting a Batch SAS Job within the Display Manager Mode under UNIX
   Jingren Shi  Shiling Zhang 
Keywords: batch sql
Pages: 2 Size: 20 Kb 
tweet!  Creating Data Driven Programs with the Macro Language
   Brian K. Varney 
Keywords: macro sql sysfunc
Pages: 4 Size: 26 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 

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

tweet!  SQL Step by Step: An Advanced Tutorial for Business Users
   Judy Loren  Gregory S. Barnes Nelson 
Keywords: SQL
Pages: 10 Size: 93 Kb 
tweet!  Intermediate PROC SQL
   Thomas J. Winn Jr. 
Keywords: SQL
Pages: 7 Size: 47 Kb 
tweet!  Querying the Data Warehouse with the SQL Procedure SELECT Statement
   Kirk Paul Lafler 
Keywords: SQL warehouse
Pages: 5 Size: 81 Kb 
tweet!  An Introduction to PROC SQL
   Rosalind K. Gusinow  J. Michael Miscisin 
Keywords: SQL
Pages: 10 Size: 2012 Kb 
tweet!  An Introduction to PROC SQL
   Rosalind K. Gusinow  J. Michael Miscisin 
Keywords: SQL
Pages: 12 Size: 50 Kb 
tweet!  Ten Great Reasons to Learn SAS Software's SQL Procedure
   Kirk Paul Lafler 
Keywords: SQL
Pages: 6 Size: 42 Kb 
tweet!  Developing Web Applications with htmSQL
   Jason Thomas 
Keywords: SQL internet
Pages: 1 Size: 9 Kb 
tweet!  An Investigation of the Efficiency of SQL DML Operations Performed on an ORACLE DBMS using SAS/ACCESS Software
   Annie Guo 
Keywords: SQL
Pages: 5 Size: 38 Kb 

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

tweet!  Ten Good Reasons to Learn SAS Software's SQL Procedure
   Sigurd Hermansen 
Keywords: SQL
Pages: 5 Size: 47 Kb 
tweet!  Building a Simple SAS Macro to Generate SQL Instructions in Frequently Used DB2 Tables
   Monique Bryher 
Keywords: SQL macro
Pages: 5 Size: 25 Kb 
tweet!  Introduction to Using PROC SQL
   Thomas J. Winn Jr. 
Keywords: SQL
Pages: 7 Size: 556 Kb 
tweet!  Overcoming Kainophobia: Replacing Complex Merges with PROC SQL.
   Brenda M. Barber 
Keywords: SQL
Pages: 6 Size: 16 Kb 

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

tweet!  SELECT ITEMS FROM PROC SQL WHERE ITEMS>BASIC
   Alan Dickson  Ray Pass 
Keywords: SQL
Pages: 10 Size: 635 Kb 
tweet!  An SQL Tutorial -Some Random Tips
   Paul Kent 
Keywords: SQL
Pages: 5 Size: 1663 Kb 
tweet!  Solving Business Problems with the SQL Procedure
   Kirk Paul Lafler  Sunil K. Gupta 
Keywords: SQL
Pages: 4 Size: 205 Kb 
tweet!  Creating SQL Stored Procedures with Text Templates
   J. Michael Morrill 
Keywords: SQL
Pages: 4 Size: 306 Kb 
tweet!  An Introduction to PROC SQL
   Kim L. Kolbe Ritzow 
Keywords: SQL
Pages: 9 Size: 347 Kb 
tweet!  FRAME Your View of Data with the SQL Procedure
   Kirk Paul Lafler 
Keywords: SQL
Pages: 4 Size: 256 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 
tweet!  SELECT ITEMS FROM PROC SQL WHERE ITEMS >BASICS;
   Alan Dickson  Ray Pass 
Keywords: SQL
Pages: 1 Size: 12 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.