HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

full join

101 papers and 1 presentation; 85 titles.

Back to keywords

Conference × Year × Title × Authors Extras Pages
WUSS 2026 Are We Winning the Vulnerabilities Battle? Measuring Cybersecurity Progress with SAS Viya Data Pipelines [presentation] Mike Krizan source 14
SESUG 2025 Visualizing SQL Join Types with Venn Diagrams Kirk Paul Lafler 8
WUSS 2023 TARDIS: Tracking Alterations and Record Differences in SAS, a Macro to Add Color to Your Dataset Comparisons Inka Leprince source 21
SESUG 2022 Demystifying PROC SQL Join Algorithms Kirk Paul Lafler source 7
WUSS 2022 TrackCHG: A SAS Macro to Colorize and Track Changes Between Data Transfers in Subject-Level Safety Listings Inka Leprince,
Elizabeth Li,
Carl Chesbrough		 source 21
WUSS 2022 True is not False: Evaluating Logical Expressions Ronald J. Fehd source 10
PharmaSUG 2020 Sometimes SQL Really Is Better: A Beginner's Guide to SQL Coding for DATA Step Users Brett Jepson source 16
SESUG 2019 HOW AM I DIFFERENT? Kannan Deivasigamani source 17
PharmaSUG 2019 One More Paper on Dictionary Tables and Yes, I Think it Is Worth Reading Vladlen Ivanushkin source 11
SGF 2019 Cool SQL Tricks Russell M. Lavery source 53
PharmaSUG 2018 Exploring techniques of using multiple SET statements in a DATA step Yizhong Huang source 10
SGF 2018 Cool SQL Tricks Russell M. Lavery source 35
SGF 2018 V is for Venn Diagrams Kriss Harris,
Richann J. Watson		 source 22
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 I Didn't Know You Could Do That! Revelations from the Advanced SAS Certification Exam Patricia Hettinger source 9
SCSUG 2017 One-to-One, One-to-Many, and Many-to-Many Joins Using PROC SQL Charu Shankar,
Kirk Paul Lafler		 source 19
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 Testing the Night Away Laurent de Walick,
Bas Marsman,
Stephan Minnaert		 source 13
SESUG 2016 True is not False: Evaluating Logical Expressions Ronald J. Fehd source 9
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
PHUSE EU 2015 SQL by Example: A Comparative Introduction to PROC SQL Jeanina M. Worden source
presentation source		 7
SCSUG 2014 Using Enterprise Guide for Table Joins and Sets Warren Schlechte,
John Barry Taylor		 13
MWSUG 2014 SAS 101 For Newbies--Not Too Little, Not Too Much--Just Right Ira Shapiro 42
WUSS 2014 Macro Design Ideas: Theory, Template, Practice Ronald J. Fehd source 21
SGF 2014 Big Data Analysis for Resource-Constrained Surgical Scheduling Elizabeth Rowse,
Paul Harper		 source 5
SGF 2014 Macro Design Ideas: Theory, Template, Practice Ronald J. Fehd source 21
SESUG 2013 Macro Design Ideas: Theory, Template, Practice Ronald J. Fehd source 21
MWSUG 2013 Macro Design Ideas: Theory, Template, Practice Ronald J. Fehd 21
MWSUG 2013 SAS: Tips and Tricks Audrey Yeo 11
SGF 2013 A Day in the Life of Data - Part 2 Harry Droogendyk source 13
PHUSE EU 2012 The Power of PROC SQL Amanda Reilly source
presentation source		 9
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
PharmaSUG 2012 Get SASsy with PROC SQL Amie Bissonett source 12
SGF 2012 Optimized 1:N Case-Control Match Using SAS Zhiwei Wang source 5
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
SGF 2011 Managing your SAS Assets Stephanie R. Thompson source 5
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 Joins with EG J. Warren Schlechte source 14
SCSUG 2009 A Propaedeutics for PROC SQL Joins Toby Dunn,
Lisa A. Mendez		 9
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
SGF 2009 A Propaedeutics for PROC SQL Joins Lisa A. Mendez,
Toby Dunn		 source 9
SGF 2009 MERGING vs. JOINING: Comparing the DATA Step with SQL Malachy J. Foley source 17
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
NESUG 2008 A PROC SQL Primer Matthew Taylor 11
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
SGF 2008 Joining Data: Data Step Merge or SQL? Faisal Dosani,
Harry Droogendyk		 source 19
SGF 2008 The Perfect Baby Name: One Dads Quest Using SAS Chris Hemedinger source 7
PharmaSUG 2006 CFB: A Programming Pattern for Creating "Change from Baseline" Datasets Lei Zhang 12
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 Get Going with PROC SQL Richard Severino source 20
NESUG 2005 A Programming Pattern for Differences Calculation in Clinical Data Analysis Lei Zhang,
Chang Y. Chung		 8
PharmaSUG 2005 The Use and Abuse of the Program Data Vector (The Procs) Jim Johnson 17
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
SCSUG 2004 Using SAS to Automate Statistical Reports Madhukar Joshi 15
SCSUG 2003 SQL - Intermediate Destiny Corporation (a company) 19
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
SESUG 2002 Customized Reports - Have It Your Way! Deb Cassidy source 10
SESUG 2002 MERGING: Comparing the DATA Step with SQL Malachy J. Foley source 10
SESUG 2002 Putting It Together - The Tutorial A Data Set Joining Primer Janet E. Stuelpner,
Caroline C. Bahler		 source 9
WUSS 2002 A Program to Write Programs Kathryn A. Valdes source 4
SCSUG 2001 Problem Solving Techniques with SQL Kirk Paul Lafler 4
SESUG 2000 A Join for All Seasons Caroline C. Bahler source 10
WUSS 2000 SQL and Its Applications - Problem Solving Techniques for Everyone Kirk Paul Lafler source 4
MWSUG 2000 Merges and Joins Timothy J. Harrington 6
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 Robust Programming Techniques in the SAS System Alice M. Cheng 10
NESUG 1999 The Magic of PROC SQL John Hotaling 3
SUGI 1999 Performance Enhancements to PROC SQL in Version 7 of the SAS System Lewis Church Jr. source 6
PharmaSUG 1998 The Causes, Impact and Detection of Duplicate Observations Alice M. Cheng 11
PharmaSUG 1998 The Magic of PROC SQL John Hotaling 3
SUGI 1998 Purge Those MERGE Problems: Realistic Solutions for Accurate and More Complete Matching of Inexact Data Fields that Occur in the Everyday World Judy Palermo source 6
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 Solving Business Problems with SQL Procedure Kirk Paul Lafler,
Sunil Kumar Gupta		 4
SEUGI 1996 Intelligent query and reporting against DB2 Jens Dahl Mikkelsen source 20
SUGI 1996 An SQL Tutorial - Some Random Tips Paul Kent source 5
SUGI 1996 JOining Strategies Access to All Data Caroline C. Bahler,
Stephen Clos		 source 5
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 If I'm Not a Database User, What Is the SQL Procedure Good For? Ann Olmsted source 15
WUSS 1994 Joining Tables of Data in the SQL Procedure Kirk Paul Lafler source 6
NESUG 1994 Solving Common Data Processing Problems with the SQL Procedure Kirk Paul Lafler 3
SUGI 1993 Relational Processing of Tape Databases Howard Levine source 9
SUGI 1992 Optimal Clinical Data Structures for Use with SAS/PH-Clinical Software Sandra D. Schlotzhauer,
Andrew T. Fagan		 source 8
SEUGI 1990 The SQL Procedure in Release 6.06 of the SAS System Jens Dahl Mikkelsen source 7

Back to keywords