| PHUSE US |
2026 |
Where are my Agents? Automating Cohort Building with a Dynamic Cohort Builder |
Mary Dolegowski, Sherrine Eid |
source presentation source |
12 |
| MWSUG |
2025 |
Code Smarter, Not Harder: The 5 C's of ChatGPT for the SASsy Professional |
Kirk Paul Lafler, Charu Shankar |
source |
49 |
| SESUG |
2025 |
Give it a ReST! Working with APIs in SAS |
Mark L. Jordan |
|
18 |
| SESUG |
2025 |
Visualizing SQL Join Types with Venn Diagrams |
Kirk Paul Lafler |
|
8 |
| PharmaSUG |
2025 |
Code Smarter, Not Harder: The 5 C's of ChatGPT for the SASsy Professional |
Charu Shankar, Kirk Paul Lafler |
source |
49 |
| PharmaSUG |
2025 |
The Many Ways to Build Cohorts to Effectively Generate Real World Evidence and Bring Drugs to Patients Faster |
Sherrine Eid, Mary Dolegowski |
source |
8 |
| MWSUG |
2024 |
Stacking Up: Horizontal or Vertical with PROC SQL or DATA Step [presentation] |
Charu Shankar |
source |
59 |
| SESUG |
2024 |
The Battle of the Titans: DATA Step versus PROC SQL |
Kirk Paul Lafler, Charu Shankar, Richann J. Watson, Joshua M. Horstman |
source |
22 |
| SESUG |
2024 |
Unanticipated Results: Uncovering Five Unexpected Outcomes in PROC SQL Joins |
Kiran Venna |
source |
15 |
| WUSS |
2023 |
The Battle of the Titans: DATA Step versus PROC SQL |
Kirk Paul Lafler, Richann J. Watson, Joshua M. Horstman, Charu Shankar |
source |
22 |
| SESUG |
2023 |
The Battle of the Titans: DATA Step versus PROC SQL |
Kirk Paul Lafler, Richann J. Watson, Joshua M. Horstman, Charu Shankar |
source |
22 |
| PharmaSUG |
2023 |
A Macro to Identify Repeating SAS BY Variables in a MERGE |
Timothy J. Harrington |
source |
9 |
| SESUG |
2022 |
Demystifying PROC SQL Join Algorithms |
Kirk Paul Lafler |
source |
7 |
| SESUG |
2020 |
Joining SAS and a Complex, Sparsely Populated Database for Machine Learning/Data Mining |
Thomas E. Billings |
source |
9 |
| SGF |
2020 |
Joinless Join: The Impossible Dream Come True Using SAS Enterprise Guide, PROC SQL, and DATA Step |
Ronda Phelps |
source |
17 |
| SGF |
2020 |
SAS and Amazon Redshift: Overview of Current Capabilities |
Nicolas Robert |
source |
20 |
| SGF |
2020 |
Step-by-Step SQL Procedure |
Charu Shankar |
source |
17 |
| PharmaSUG |
2020 |
Sometimes SQL Really Is Better: A Beginner's Guide to SQL Coding for DATA Step Users |
Brett Jepson |
source |
16 |
| MWSUG |
2019 |
Powerful and "Sometimes" Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
|
14 |
| MWSUG |
2019 |
The SAS EG Process Flow: A Customizable Data Mining Tool in the Search for Healthcare Fraud |
Andrea McLain |
|
6 |
| SGF |
2019 |
Cool SQL Tricks |
Russell M. Lavery |
source |
53 |
| SESUG |
2018 |
Proc SQL in Twenty Minutes |
John J. Cohen |
source |
11 |
| MWSUG |
2018 |
The Joinless Join ~ The Impossible Dream Come True Using SAS Enterprise Guide and Base SAS PROC SQL and DATA Step; Expand the Power of SAS Enterprise Guide and Base SAS in New Ways |
Kent Phelps, Ronda Phelps |
|
18 |
| WUSS |
2018 |
Combined Predictor Selection for Multiple Clinical Outcomes Using PHREG |
L. Grisell Diaz-Ramirez, Siqi Gan, Sei J. Lee, Alexander Smith, John Boscardin |
source |
14 |
| PharmaSUG |
2018 |
Exploring techniques of using multiple SET statements in a DATA step |
Yizhong Huang |
source |
10 |
| SGF |
2018 |
BI Centralization: The Benefits of Implementing a Report Encyclopedia for Your Organization |
John Mattox |
source |
13 |
| SGF |
2018 |
Cool SQL Tricks |
Russell M. Lavery |
source |
35 |
| SGF |
2018 |
Efficiently Join a SAS Data Set with External Database Tables |
Dadong Li, Michael Cantor |
source |
6 |
| SGF |
2018 |
Tools Designed to Aid in Quality Control of Administrative Data Research Projects |
Matthew Keller, Katelin B. Nickel |
source |
10 |
| SGF |
2018 |
Working Together for Public Health: Using SAS , Esri, and Tableau to Enhance Data Presentation |
Jennifer L. Han, Miriam McGaugh |
source |
135 |
| SESUG |
2017 |
Beyond the Standard Map Alternate Methods for Visualizing Location Data |
Seth W. Hoffman |
source |
10 |
| SESUG |
2017 |
Joining Data: Data Step Merge or SQL? |
Harry Droogendyk |
source |
19 |
| SESUG |
2017 |
One-to-One, One-to-Many, and Many-to-Many Joins Using PROC SQL |
Kirk Paul Lafler |
source |
19 |
| SCSUG |
2017 |
One-to-One, One-to-Many, and Many-to-Many Joins Using PROC SQL |
Charu Shankar, Kirk Paul Lafler |
source |
19 |
| PHUSE EU |
2017 |
Detecting Treatment Emergent Adverse Events (TEAEs) |
Matthias Lehrkamp |
source presentation source |
12 |
| WUSS |
2017 |
One-to-One, One-to-Many, and Many-to-Many Joins Using PROC SQL |
Charu Shankar, Kirk Paul Lafler |
source |
19 |
| SGF |
2017 |
Advanced Programming Techniques with PROC SQL |
Kirk Paul Lafler |
source zip |
20 |
| SGF |
2017 |
Jumping and Cutting: Using the Hash Object to Implement a Polygon Clipping Algorithm |
Seth W. Hoffman |
source |
10 |
| SGF |
2017 |
Patching the Holes in SQL Systems with SAS |
Chris Carson |
source |
16 |
| SGF |
2017 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
source zip |
20 |
| SGF |
2017 |
What's Love Gotta Do WITH It |
Jason O'Day |
source pdf |
12 |
| PHUSE EU |
2016 |
Reflect on Your Data |
Peter Tormay, Henrik Drews |
source presentation source |
9 |
| MWSUG |
2016 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
20 |
| MWSUG |
2016 |
The Joinless Join ~ The Impossible Dream Come True; Expand the Power of Base SAS and SAS Enterprise Guide in a New Way |
Kent Phelps, Ronda Phelps |
|
49 |
| WUSS |
2016 |
Advanced Programming Techniques with PROC SQL |
Kirk Paul Lafler |
source |
20 |
| SCSUG |
2015 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
source |
20 |
| MWSUG |
2015 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
20 |
| MWSUG |
2015 |
Need Help Finding Something? Why Not Ask Your (Virtual) Community! A Collaborative Filtering Based Recommendation Engine in SAS |
Ben Elbert |
|
12 |
| MWSUG |
2015 |
The Joinless Join ~ The Impossible Dream Come True; Expanding the Power of SAS Enterprise Guide in a New Way |
Kent Phelps, Ronda Phelps |
|
37 |
| PHUSE EU |
2015 |
Dynamic, Powerful, User-friendly SQL Joins Made Easy with %VARLIST, a Generic SAS Macro Function |
Jean-Michel Bodart |
source presentation source |
8 |
| SESUG |
2015 |
Application Development Techniques Using PROC SQL |
Kirk Paul Lafler |
source |
20 |
| SESUG |
2015 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
source |
20 |
| PharmaSUG |
2015 |
Application Development Techniques Using PROC SQL |
Kirk Paul Lafler |
source |
20 |
| SCSUG |
2014 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
20 |
| SCSUG |
2014 |
Using Enterprise Guide for Table Joins and Sets |
Warren Schlechte, John Barry Taylor |
|
13 |
| SESUG |
2014 |
Application Development Techniques Using PROC SQL |
Kirk Paul Lafler |
source |
17 |
| MWSUG |
2014 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
20 |
| MWSUG |
2014 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
|
22 |
| MWSUG |
2014 |
SAS and Relational Databases: What You Should Know Before You Code |
Patricia Hettinger |
|
15 |
| MWSUG |
2014 |
The Joinless Join; Expand the Power of SAS Enterprise Guide in a New Way |
Kent Phelps, Ronda Phelps, Kirk Paul Lafler |
|
37 |
| WUSS |
2014 |
SAS Essentials II (or How to Train Your SAS Data Sets) |
Tasha Chapman |
source |
12 |
| SGF |
2014 |
Exploring DATA Step Merges and PROC SQL Joins |
Kirk Paul Lafler |
source |
14 |
| SGF |
2014 |
Powerful and Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
source |
19 |
| WUSS |
2013 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
source |
17 |
| SCSUG |
2013 |
Demystifying PROC SQL Join Algorithms |
Kirk Paul Lafler |
source |
6 |
| MWSUG |
2013 |
SAS: Tips and Tricks |
Audrey Yeo |
|
11 |
| MWSUG |
2013 |
The Joinless Join; Expand the Power of SAS Enterprise Guide in a New Way |
Kent Phelps, Ronda Phelps, Kirk Paul Lafler |
|
25 |
| NESUG |
2013 |
Continuous Enrollment Requirements in Epidemiologic Studies |
Jennifer R. Popovic |
|
12 |
| NESUG |
2013 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
|
17 |
| PharmaSUG |
2013 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
source |
17 |
| SGF |
2013 |
Consistent and Organized Analysis: Moving Beyond Pie-in-the-Sky to Actual Implementation via SAS Enterprise Guide |
Amber Schmitz |
source |
8 |
| SGF |
2013 |
Finally, a Tool for Business Users! A Step-By-Step Practical Approach to Pharma Sales Reporting Using SAS Enterprise Guide 4.3 |
Airaha Chelvakkanthan Manickam, Ramya Purushothaman |
source |
18 |
| NESUG |
2012 |
Pharma Sales Reporting Using SAS Enterprise Guide 4.3 - A Step-by-Step Practical Approach |
Airaha Chelvakkanthan Manickam, Ramya Purushothaman |
|
18 |
| NESUG |
2012 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
|
20 |
| NESUG |
2012 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
|
17 |
| SESUG |
2012 |
Queries, Joins, and WHERE Clauses, Oh My!! Demystifying PROC SQL |
Christianna S. Williams |
source |
37 |
| MWSUG |
2012 |
Get SASsy with PROC SQL |
Amie Bissonett |
|
12 |
| WUSS |
2012 |
Demystifying PROC SQL Join Algorithms |
Kirk Paul Lafler |
source |
6 |
| PharmaSUG |
2012 |
Exploring DATA Step Merges and PROC SQL Joins |
Kirk Paul Lafler |
source |
14 |
| PharmaSUG |
2012 |
From InForm EDC Data to SAS Datasets using SAS Clinical Data Integration - Real Time |
Jitesh Nagaria |
source |
12 |
| PharmaSUG |
2012 |
Get SASsy with PROC SQL |
Amie Bissonett |
source |
12 |
| PharmaSUG |
2012 |
Merge vs. Join vs. Hash Objects: A Comparison using "Big" Medical Device Data |
James R. Johnson |
source |
6 |
| SGF |
2012 |
Exploring DATA Step Merges and PROC SQL Joins |
Kirk Paul Lafler |
source |
14 |
| SGF |
2012 |
Optimizing That Which cannot be optimized. Superfast SAS 9.2 + Searches and Fuzzy Linkage of Large Data Sets |
Sigurd W. Hermansen |
source |
7 |
| SGF |
2012 |
Queries, Joins, and WHERE Clauses, Oh My!! Demystifying PROC SQL |
Christianna S. Williams |
source |
37 |
| SESUG |
2011 |
Misquoting Jane Austen in the Name of Quality Assurance |
Deborah Posner |
source |
11 |
| WUSS |
2011 |
Powerful and "Sometimes" Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
source |
17 |
| WUSS |
2011 |
Probabilistic Record Linkage in SAS |
Glenn Wright |
source |
13 |
| WUSS |
2011 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
source |
17 |
| PHUSE EU |
2011 |
Many too many, too many performance tests |
Christoph Baumer |
source |
13 |
| MWSUG |
2011 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
|
17 |
| NESUG |
2011 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
|
22 |
| NESUG |
2011 |
Using SQL joins to Perform Fuzzy Matches on Multiple Identifiers |
Jedediah J. Teres |
|
6 |
| PharmaSUG |
2011 |
Exploring DATA Step Merges and PROC SQL Joins |
Kirk Paul Lafler |
source |
11 |
| PharmaSUG |
2011 |
Powerful and "Sometimes" Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
source |
17 |
| NESUG |
2010 |
Misquoting Jane Austen in the Name of Quality Assurance |
Deborah Posner |
|
12 |
| NESUG |
2010 |
PROC SQL: Tips and Translations |
Gail Jorgensen, Susan P. Marcella |
|
23 |
| SCSUG |
2010 |
Exploring DATA Step Merges and PROC SQL Joins |
Kirk Paul Lafler |
source |
11 |
| SCSUG |
2010 |
Exploring Joins with EG |
J. Warren Schlechte |
source |
14 |
| WUSS |
2010 |
An Excel Framework to Convert Clinical Data to CDISC SDTM Leveraging SAS Technology |
Ale Gicqueau |
source |
12 |
| MWSUG |
2010 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
17 |
| MWSUG |
2010 |
DATA Step and PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
14 |
| MWSUG |
2010 |
Hard-to-find, But Powerful, PROC SQL Features |
Kirk Paul Lafler |
|
17 |
| SESUG |
2010 |
Merging into Hash: Some Practical Examples of Converting MERGE Statements into Hash Objects |
Ying Liu |
source |
23 |
| SGF |
2010 |
Complex Data Combinations on Large Volumes: How to Get the Best Performance |
Henri Theuwissen |
source |
22 |
| SGF |
2010 |
Exploring Powerful Features in PROC SQL |
Kirk Paul Lafler |
source |
17 |
| SCSUG |
2009 |
A Propaedeutics for PROC SQL Joins |
Toby Dunn, Lisa A. Mendez |
|
9 |
| SCSUG |
2009 |
Dear Ms. SAS Answers: A Guide to Efficient PROC SQL Coding |
Linda T. Jolley, Jane Stroupe |
|
14 |
| SESUG |
2009 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
17 |
| SESUG |
2009 |
DATA Step versus PROC SQL Programming Techniques |
Kirk Paul Lafler |
source |
14 |
| MWSUG |
2009 |
Dear Miss SASAnswers: A Guide to Efficient PROC SQL Coding |
Jane Stroupe, Linda T. Jolley |
|
14 |
| MWSUG |
2009 |
Exploring DATA Step and PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
14 |
| PNWSUG |
2009 |
DATA Step versus PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
14 |
| NESUG |
2009 |
Ad Hoc Data Preparation for Analysis Using SAS Enterprise Guide |
I-Kong B. Fu |
|
11 |
| NESUG |
2009 |
Crossing the environment chasm - better queries between SAS and DB2 |
Mark Sanderson |
|
6 |
| NESUG |
2009 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
|
19 |
| NESUG |
2009 |
PROC SQL Tips and Techniques |
Gail Jorgensen, Susan P. Marcella |
|
23 |
| NESUG |
2009 |
Using DATA STEP MERGE and PROC SQL JOIN to Combine SAS Datasets |
Dalia C. Kahane |
|
15 |
| NESUG |
2009 |
Using DataSets to Define Macro Loops and Local Macro Variables |
Steven M. Ruegsegger |
|
10 |
| NESUG |
2009 |
Using SQL Joins to Perform Weighted Matches on Multiple Identifiers |
Jedediah J. Teres |
|
8 |
| WUSS |
2009 |
Base SAS Tips, Tricks and Techniques |
Kirk Paul Lafler |
source |
14 |
| PharmaSUG |
2009 |
Demystifying PROC SQL Join Algorithms |
Kirk Paul Lafler |
|
6 |
| SGF |
2009 |
A Propaedeutics for PROC SQL Joins |
Lisa A. Mendez, Toby Dunn |
source |
9 |
| SGF |
2009 |
Ad Hoc Data Preparation for Analysis Using SAS Enterprise Guide |
I-Kong B. Fu, Wayne Thompson, Mike Porter |
source |
11 |
| SGF |
2009 |
Exploring PROC SQL Joins and Join Algorithms |
Kirk Paul Lafler |
source |
6 |
| SGF |
2009 |
MERGING vs. JOINING: Comparing the DATA Step with SQL |
Malachy J. Foley |
source |
17 |
| SGF |
2009 |
Simple Applications of SQL |
Howard L. Schreier |
source |
17 |
| WUSS |
2008 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
17 |
| WUSS |
2008 |
Demystifying PROC SQL Join Algorithms |
Kirk Paul Lafler |
source |
6 |
| WUSS |
2008 |
Getting SAS to Play Nice With Others: Connecting SAS to Microsoft SQL Server |
Candice Miller |
source |
6 |
| SCSUG |
2008 |
A Propaedeutics for PROC SQL Joins |
Lisa A. Mendez, Toby Dunn |
|
9 |
| SESUG |
2008 |
A Propaedeutics for PROC SQL Joins |
Lisa A. Mendez, Toby Dunn |
source |
9 |
| SESUG |
2008 |
Joins: How to Put it All Together |
Janet E. Stuelpner |
source |
10 |
| SESUG |
2008 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
source |
17 |
| SESUG |
2008 |
Undocumented and Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
source |
17 |
| PNWSUG |
2008 |
Exploring PROC SQL Joins and Join Algorithms |
Kirk Paul Lafler |
|
6 |
| NESUG |
2008 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
17 |
| NESUG |
2008 |
A PROC SQL Primer |
Matthew Taylor |
|
11 |
| NESUG |
2008 |
Another Helping of HASH |
Lee Dodoo, Stephen J. Rhoades |
|
18 |
| NESUG |
2008 |
Effective Use of SQL in SAS Programming |
Yi Zhao |
|
8 |
| NESUG |
2008 |
Using DATA STEP MERGE and PROC SQL JOIN to Combine SAS Datasets |
Dalia C. Kahane |
|
15 |
| PharmaSUG |
2008 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
18 |
| SGF |
2008 |
Getting SAS to Play Nice with Others: Connecting SAS to a Microsoft SQL Server with an ODBC Connection |
Candice Riley |
source |
6 |
| SGF |
2008 |
Joining Data: Data Step Merge or SQL? |
Faisal Dosani, Harry Droogendyk |
source |
19 |
| SGF |
2008 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
source |
17 |
| SGF |
2008 |
Using Table Lookup Techniques Efficiently |
Linda T. Jolley, Jane Stroupe |
source |
11 |
| NESUG |
2007 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
18 |
| WUSS |
2007 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
13 |
| WUSS |
2007 |
Exploring the World of PROC SQL Joins |
Kirk Paul Lafler |
source |
6 |
| PHUSE EU |
2007 |
Comparison of different ways using table lookups on huge tables |
Ralf Minkenberg |
source |
6 |
| SCSUG |
2007 |
Adapting SQL for SAS - A few ways to Maximize Performance |
Rena Manning |
|
11 |
| SCSUG |
2007 |
Exploring the World of PROC SQL Joins |
Kirk Paul Lafler |
|
6 |
| SCSUG |
2007 |
PROC SQL for New Users |
Kirk Paul Lafler |
|
13 |
| PNWSUG |
2007 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
13 |
| PharmaSUG |
2007 |
Proc SQL versus The DATA Step |
JoAnn R. Matthews |
|
39 |
| SGF |
2007 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler, Ben Cochran |
source |
13 |
| SGF |
2007 |
DATA Step vs. PROC SQL: What's a Neophyte to Do? |
Ray Davis, Michael L. Dickstein, Craig Pass |
source |
12 |
| SGF |
2007 |
Demeter in the Database |
Paul D. Sherman |
source |
8 |
| SGF |
2007 |
Super Size It!!! Maximize the Performance of Your ETL Processes |
Nancy A. Rausch, Nancy J. Wills |
source |
14 |
| PHUSE EU |
2006 |
An Introduction to PROC SQL |
Anthony Cooper |
source |
20 |
| SESUG |
2006 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
source |
17 |
| WUSS |
2006 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
11 |
| NESUG |
2006 |
A Hash Alternative to the PROC SQL Left Join |
Kenneth W. Borowiak |
|
9 |
| NESUG |
2006 |
Combining, Combining, Combining, Splitting, Splitting, Splitting |
Emmy V Pahmer |
|
9 |
| NESUG |
2006 |
Proc SQL versus The DATA Step |
JoAnn R. Matthews |
|
35 |
| SUGI |
2006 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
11 |
| SUGI |
2006 |
Using Data Set Options in PROC SQL |
Kenneth W. Borowiak |
source |
10 |
| SUGI |
2006 |
Using SAS Enterprise Guide to Code When You're Not a Programmer |
Britta K. August |
source |
6 |
| SESUG |
2005 |
The SQL Optimizer Project: _Method and _Tree in SAS 9.1 |
Russell M. Lavery |
source |
57 |
| SCSUG |
2005 |
MERGING vs. JOINING: Comparing the DATA Step with SQL |
Malachy J. Foley |
|
17 |
| MWSUG |
2005 |
MERGING vs. JOINING: Comparing the DATA Step with SQL |
Malachy J. Foley |
|
17 |
| WUSS |
2005 |
A Hands-On Tour of the 5 Most Exciting Features Found in PROC SQL |
Kirk Paul Lafler |
source |
10 |
| WUSS |
2005 |
Get Going with PROC SQL |
Richard Severino |
source |
20 |
| WUSS |
2005 |
The Optimizer Project: WHERE The Statement Is Not The Clause |
Paul D. Sherman, Russell M. Lavery |
source |
15 |
| NESUG |
2005 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
|
20 |
| PharmaSUG |
2005 |
Creating Efficient SQL - The De-normalize Transpose |
Paul D. Sherman |
|
14 |
| SUGI |
2005 |
Merging versus Joining: Comparing the DATA Step with SQL |
Malachy J. Foley |
source |
18 |
| SUGI |
2005 |
The SQL Optimizer Project: _Method and _Tree in SAS 9.1 (broken file) |
Russell M. Lavery |
source |
57 |
| NESUG |
2004 |
How to develop SAS data mart in one day (with code examples!) |
Tanya Kolosova, Samuel Berestizhevsky |
|
10 |
| WUSS |
2004 |
Creating Efficient SQL - Four Steps to a Quick Query |
Paul D. Sherman |
source |
8 |
| SUGI |
2004 |
DATA Step vs. PROC SQL: What's a Neophyte to Do? |
Craig Dickstein, Ray Pass |
source |
13 |
| SUGI |
2004 |
Improve Your Queries: Hints and Tips for Using SQL |
Marje Fecht, Linda A. Mitterling |
source |
11 |
| SUGI |
2004 |
Mainframe SAS for the 21st Century |
Kryn Krautheim |
source |
9 |
| SCSUG |
2003 |
SQL - Intermediate |
Destiny Corporation (a company) |
|
19 |
| SESUG |
2003 |
Sublime Secrets of the SAS SQLheads |
Sigurd W. Hermansen |
source |
6 |
| SEUGI |
2003 |
SAS Information Maps: Cornerstone for SAS Business Intelligence [presentation] |
Ingrid Hertel |
source |
22 |
| PharmaSUG |
2003 |
SQL for People Who Don't Think They Need SQL |
Erin M. Christen |
|
8 |
| SCSUG |
2002 |
MERGING: Comparing the DATA Step with SQL |
Malachy J. Foley |
|
11 |
| NESUG |
2002 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
|
10 |
| NESUG |
2002 |
PROC SQL vs. Pass-Thru SQL on DB2 or How I found an extra day |
Jeffrey Cohen |
|
4 |
| SESUG |
2002 |
MERGING: Comparing the DATA Step with SQL |
Malachy J. Foley |
source |
10 |
| SESUG |
2002 |
Problem Solving Techniques with SQL |
Kirk Paul Lafler |
source |
6 |
| SESUG |
2002 |
Putting It Together - The Poster A Data Set Joining Primer |
Janet E. Stuelpner, Caroline C. Bahler |
source |
4 |
| SESUG |
2002 |
Putting It Together - The Tutorial A Data Set Joining Primer |
Janet E. Stuelpner, Caroline C. Bahler |
source |
9 |
| SESUG |
2002 |
Structured Query Language: Logic, Structure, and Syntax |
Sigurd W. Hermansen |
source |
10 |
| SUGI |
2002 |
Creating Efficient SQL - Four Steps to a Quick Query |
Paul D. Sherman |
source |
5 |
| SUGI |
2002 |
DATA Step vs. PROC SQL: What's a Neophyte to Do? |
Craig Dickstein, Ray Pass |
source |
9 |
| SUGI |
2002 |
Table Look-up: Techniques Beyond the Obvious |
Henri Theuwissen, Nancy Croonen |
source |
9 |
| SESUG |
2001 |
Problem Solving Techniques with SQL |
Kirk Paul Lafler |
source |
4 |
| SCSUG |
2001 |
Optimizing Data Extraction from Oracle Tables |
Caroline C. Bahler |
|
9 |
| SCSUG |
2001 |
Problem Solving Techniques with SQL |
Kirk Paul Lafler |
|
4 |
| SUGI |
2001 |
DATA Step vs. PROC SQL: What's a Neophyte to Do? |
Craig Dickstein |
source |
9 |
| SCSUG |
2000 |
Many-to-Many Matching Using the Inner Join |
Thomas J. Winn Jr. |
|
3 |
| SESUG |
2000 |
A Join for All Seasons |
Caroline C. Bahler |
source |
10 |
| NESUG |
2000 |
SQL Summary Functions, Unions, and Aliases to Define a Risk Cohort and Risk Variables from a Record-based Study |
Janet Wikoff, Lori Maiwald |
|
9 |
| MWSUG |
2000 |
Merges and Joins |
Timothy J. Harrington |
|
6 |
| SEUGI |
2000 |
A PC Interface for Mainframe SAS Datawarehouse [presentation] |
Heidi Fog |
source |
19 |
| SUGI |
2000 |
Merges and Joins |
Timothy J. Harrington |
source |
6 |
| SCSUG |
1999 |
Introduction to Using PROC SQL |
Thomas J. Winn Jr. |
|
7 |
| NESUG |
1999 |
Alternatives to Merging SAS Data Sets But Be Careful |
Michael J. Wieczkowski |
|
7 |
| NESUG |
1999 |
PROC SQL for DATA Step Die-Hards |
Christianna S. Williams |
|
10 |
| NESUG |
1999 |
The Magic of PROC SQL |
John Hotaling |
|
3 |
| NESUG |
1998 |
Handling Missing Values in the SQL Procedure |
Danbo Yi |
|
8 |
| PharmaSUG |
1997 |
Some Less Known but Powerful Proc SQL Features |
Jun Zhao |
|
4 |
| SUGI |
1997 |
Introduction to Using PROC SQL |
Thomas J. Winn Jr. |
source |
7 |
| SUGI |
1997 |
It Takes at Least Two to Tango - A Data Set Joining Primer |
Caroline C. Bahler |
source |
9 |
| SCSUG |
1996 |
Introduction to PROC SQL |
Thomas J. Winn Jr. |
|
16 |
| SESUG |
1996 |
It Takes at Least Two to Tango - A Data Set Joining Primer |
Caroline Babler |
|
8 |
| NESUG |
1996 |
PROC SQL - A Closer Look |
Jim Peters |
|
10 |
| NESUG |
1996 |
The SQL Query Window |
Dana Rafiee |
|
10 |
| MWSUG |
1996 |
The SQL Query Window |
Simon Driscoll |
|
10 |
| PNWSUG |
1996 |
The SQL Query Window |
Gail Amato |
|
12 |
| SUGI |
1996 |
JOining Strategies Access to All Data |
Caroline C. Bahler, Stephen Clos |
source |
5 |
| MWSUG |
1995 |
A New Approach to Outer Joins with More than Two Tables |
Howard Levine |
|
10 |
| MWSUG |
1995 |
Joining Data with SQL |
Kim L. Kolbe Ritzow |
|
6 |
| SUGI |
1995 |
A New Approach to Outer Joins with More than Two Tables |
Howard Levine |
source |
10 |
| SUGI |
1995 |
Diving into SAS Software with the SOL Procedure |
Kirk Paul Lafler |
source |
6 |
| WUSS |
1994 |
Joining Tables of Data in the SQL Procedure |
Kirk Paul Lafler |
source |
6 |
| MWSUG |
1993 |
Relational Processing of Tape Databases |
Howard Levine |
|
9 |
| SUGI |
1993 |
Relational Processing of Tape Databases |
Howard Levine |
source |
9 |
| SUGI |
1992 |
Making Use of the SAS Implementation of SQL |
Don Stanley |
source |
6 |
| SEUGI |
1989 |
Using The New SQL Procedure In SAS Programs |
Paul Kent |
source |
6 |
| SUGI |
1989 |
Using the SQL Procedure in SAS Programs |
Susan Johnston |
source |
6 |