HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

data merging

202 papers and 5 presentations; 155 titles.

Back to keywords

Conference × Year × Title × Authors Extras Pages
PharmaSUG 2026 DOSEON: Fuzzy Matching DOSE Date Intervals ON Analysis Dates Across SAS (PROC SQL, SAS Macro, DATA Step, and PROC FCMP) Inka Leprince,
Troy Martin Hughes		 source 39
PharmaSUG 2026 SAS Programming techniques for efficiency and code optimization Jayanth Iyengar source 27
PHUSE US 2026 Fuzzy Matching DOSE Date Intervals ON Analysis Dates Across SAS (DATA Step, PROC SQL, SAS Macro, and PROC FCMP) Inka Leprince,
Troy Martin Hughes		 source
presentation source		 32
PHUSE APAC 2026 Don't Loop - Hash! Slashing Clinical Merge Times with Five-Line In Memory SAS Lookups Hayk Nazaryan source
presentation source		 5
MWSUG 2025 Under the Hood: The Mechanics of SQL Query Optimization Techniques Kirk Paul Lafler source 8
SESUG 2025 Lookup Tables (LUT) in SAS and Data-Driven Programming Imelda C. Go,
Abbas S. Tavakoli		 17
MWSUG 2024 Best Practices for Efficiency and Code Optimization in SAS programming Jayanth Iyengar source 20
MWSUG 2024 From Paper To Pedigrees: A Beginners Approach with SAS Vijay Susmitha Bommini source 14
MWSUG 2024 Stacking Up: Horizontal or Vertical with PROC SQL or DATA Step [presentation] Charu Shankar source 59
SESUG 2024 Look Up Not Down: Advanced Table Lookups in Base SAS Jayanth Iyengar source 20
SESUG 2024 Unanticipated Results: Uncovering Five Unexpected Outcomes in PROC SQL Joins Kiran Venna source 15
SESUG 2023 Best Practices for Efficiency and Code Optimization in SAS programming Jayanth Iyengar source 20
PharmaSUG 2023 Best Practices for Efficiency and Code Optimization in SAS programming Jayanth Iyengar source 20
SESUG 2022 Demystifying PROC SQL Join Algorithms Kirk Paul Lafler source 7
WUSS 2022 Best Practices for Efficiency and Code Optimization in SAS programming Jayanth Iyengar source 21
PharmaSUG 2022 Look Up Not Down: Advanced Table Lookups in Base SAS Jayanth Iyengar,
Joshua M. Horstman		 source 28
PHUSE US 2022 Incorporating Immunogenicity Data from Various Analyzing Labs [presentation] Elisabeth van Son-Palmen,
Gunasekaran Subramaniam		 source 19
SESUG 2021 Under the Hood: The Mechanics of SQL Query Optimization Techniques Kirk Paul Lafler source 9
PharmaSUG 2021 Under the Hood: The Mechanics of Various SQL Query Optimization Techniques Kirk Paul Lafler source 9
SESUG 2020 Exploring the MSGLEVEL= SAS System Option and PROC SQL _METHOD Option Kirk Paul Lafler source 5
SESUG 2020 Look Up Not Down: Advanced Table Lookups in Base SAS Jayanth Iyengar,
Joshua M. Horstman		 source 28
SGF 2020 Best Practices in SAS Programming to Support Ever-Increasing Data Loads. John Schmitz source 15
PharmaSUG 2020 Sometimes SQL Really Is Better: A Beginner's Guide to SQL Coding for DATA Step Users Brett Jepson source 16
SCSUG 2019 Exploring the MSGLEVEL= SAS System Option and PROC SQL _METHOD Option Kirk Paul Lafler source 5
MWSUG 2019 Look Up Not Down: Advanced Table Lookups in Base SAS Jayanth Iyengar,
Joshua M. Horstman		 24
SGF 2019 Calculating Lags and Leads in SAS Andrew Gannon source 12
SGF 2019 Cool SQL Tricks Russell M. Lavery source 53
SGF 2019 Simple Techniques to Improve the Performance of your SAS Programs When Processing Large Data Sets Steve Cavill source 20
SCSUG 2018 NBA Draft Analytics: Boom or Bust? Isaiah Hartman source 17
SESUG 2018 Using PROC FORMAT to Automate Data correction process Dalvi Shreyas source 6
MWSUG 2018 How to Avoid Possible Tricks When Using DATA STEP MERGE Instead of PROC SQL JOIN Guangtao Gao 27
PHUSE US 2018 Fuzzy Joins with Proc SQL for Better Data Utilization Sunil Kumar Gupta source
presentation source		 2
SGF 2018 Cool SQL Tricks Russell M. Lavery source 35
SGF 2018 Fuzzy Matching Programming Techniques Using SAS Software Stephen B. Sloan,
Kirk Paul Lafler		 source 24
SESUG 2017 Automatic Verification of Combined Datasets Joe Matise source 9
SESUG 2017 Fuzzy Matching Programming Techniques Using SAS Software Stephen B. Sloan,
Kirk Paul Lafler		 source 25
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 Fuzzy Matching Programming Techniques Using SAS Software Kirk Paul Lafler,
Stephen B. Sloan		 source 25
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 A Quick Look at Fuzzy Matching Programming Techniques Using SAS Software Kirk Paul Lafler,
Stephen B. Sloan		 source 25
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 From Source to Target: Hadoop Capabilities of SAS Data Integration Studio Darryl Yewchin,
Todd Foreman		 source 18
PHUSE EU 2016 Top 10 Uses of Macro %VARLIST - In Proc SQL, Data Step and Elsewhere Jean-Michel Bodart source
presentation source		 12
MWSUG 2015 Essential PROC SQL Join Techniques Using SAS University Edition Software Kirk Paul Lafler 8
MWSUG 2015 Table Lookup Techniques: From the Basics to the Innovative Arthur L. Carpenter 11
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
PharmaSUG CN 2015 Not Just Merge - Complex Derivation Made Easy by Hash Object Lu Zhang 5
PharmaSUG 2015 Not Just Merge - Complex Derivation Made Easy by Hash Object Lu Zhang source 5
SGF 2015 Data Management Techniques for Complex Healthcare Data Gabriela Cantu,
Christopher Klekar		 source 14
SGF 2015 How Do You Use Look-up Tables? Philip R. Holland source 10
SGF 2015 Table Lookup Techniques: From the Basics to the Innovative Arthur L. Carpenter source 11
SCSUG 2014 Exploring the PROC SQL _METHOD Option Kirk Paul Lafler 4
SCSUG 2014 Using Enterprise Guide for Table Joins and Sets Warren Schlechte,
John Barry Taylor		 13
PHUSE EU 2014 SDTM Mapping Becomes more EASY with SAS Clinical Data Integration Saumilkumar Tripathi source
presentation source		 8
MWSUG 2014 Navigating the Data Universe Aboard the Starship Enterprise Guide Jayanth Iyengar 10
WUSS 2014 Table Lookup Techniques: From the Basics to the Innovative Arthur L. Carpenter source 11
PharmaSUG 2014 Table Lookup Techniques: From the Basics to the Innovative Arthur L. Carpenter source 11
PharmaSUG 2014 Using the Power of SAS SQL Jessica Wang source 14
SGF 2014 Big Data Everywhere! Easily Loading and Managing Your Data in the SAS LASR Analytic Server Gary Mehler,
Donna Bennett		 source 17
SGF 2014 Getting the Warm and Fuzzy Feeling with Inexact Matching Toby Dunn source 20
SGF 2014 Powerful and Hard-to-find PROC SQL Features Kirk Paul Lafler source 19
SGF 2014 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
WUSS 2013 Exploring the PROC SQL _METHOD Option Kirk Paul Lafler,
Charles E. Shipp		 source 4
SCSUG 2013 Demystifying PROC SQL Join Algorithms Kirk Paul Lafler source 6
MWSUG 2013 Exploring the PROC SQL _METHOD Option Kirk Paul Lafler,
Charles E. Shipp		 4
NESUG 2013 Exploring the PROC SQL _METHOD Option Kirk Paul Lafler,
Charles E. Shipp		 pdf 4
NESUG 2013 I Can SQL Clearly Now, the Data's Fine... Brian Taaffe 16
NESUG 2013 Navigating the Data Universe Aboard the Starship Enterprise Guide Jayanth Iyengar,
Kirk Paul Lafler		 10
PharmaSUG 2013 Doing the hashwork: Using the DATA step hash object to perform common clinical programming chores Miles Dunn source 9
SGF 2013 A Day in the Life of Data - Part 2 Harry Droogendyk source 13
SGF 2013 Data Merging and Visualization to Identify Associations Between Environmental Factors and Disease Outbreaks Azhar Nizam,
Neeta Shenvi,
Xin Zhang		 source 12
SGF 2013 Exploring the PROC SQL _METHOD Option Charles E. Shipp,
Kirk Paul Lafler		 source
pdf		 4
SESUG 2012 CT-30 Beyond "If then"-- Three Techniques for Cleaning Character Variables from Write-in Questions Yusheng Zhai,
Ryan Diver,
Xia Lin		 source 8
WUSS 2012 Demystifying PROC SQL Join Algorithms Kirk Paul Lafler source 6
WUSS 2012 Scalability of Table Lookup Techniques Richard D. Langston source 5
WUSS 2012 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
PharmaSUG CN 2012 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt 17
PharmaSUG 2012 "Analysis-ready" - Considerations, Implementations, and Real World Applications Ellen (Zihui) Lin,
Beiying Ding		 source 6
SGF 2012 Combine Data Sets Using Inexact Character Variables in SAS Kulwant Rai source 12
SGF 2012 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
SESUG 2011 Two Guys On Hash Paul M. Dorfman source 34
WUSS 2011 Quick Results with PROC SQL Kirk Paul Lafler source 17
NESUG 2011 Join or Merge? The Differences Between PROC SQL goin and Data Step Merge and When to Use Them. Ted Shelly 7
NESUG 2011 Using SQL joins to Perform Fuzzy Matches on Multiple Identifiers Jedediah J. Teres 6
SGF 2011 Best Practices in Data Integration: Advanced Data Management Nancy A. Rausch,
Michael Ames,
David Barkaway,
Jeff Stander		 source 15
SGF 2011 Best Solutions for Tuning Performance of ETL Jobs in SAS Data Integration Studio Qingfeng Liang source 10
SGF 2011 Getting Personal but Not Too Personal Stephanie R. Thompson source 4
SGF 2011 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
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
MWSUG 2010 Set, Match, Merge ... Don't You Love SAS Peter W. Eberhardt,
Ying Liu		 19
MWSUG 2010 The SAS Hash Object: It's Time To .find() Your Way Around - Hands-On Workshop Peter W. Eberhardt 17
SESUG 2010 Set, Match, Merge ... Don't You Love SAS Peter W. Eberhardt,
Ying Liu		 source 19
SESUG 2010 Two Guys On Hash Paul M. Dorfman source 33
PharmaSUG 2010 The SAS Hash Object: It's Time To .find() Your Way Around - Hands-On Workshop Peter W. Eberhardt 17
PharmaSUG 2010 The SAS Hash Object: It's Time To .find() Your Way Around - Tutorial Peter W. Eberhardt 17
SGF 2010 Exploring Powerful Features in PROC SQL Kirk Paul Lafler source 17
SGF 2010 SAS Data Integration Studio Tips and Tricks Christopher R. Olinger,
David Kratz		 source 32
SGF 2010 SAS Data Integration Studio: Tips and Techniques for Implementing ELT Jeff Stander source 16
SGF 2010 The Power of User-Defined SAS Code in SAS Data Integration Studio Anders Holte source 12
SGF 2010 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
SCSUG 2009 A Propaedeutics for PROC SQL Joins Toby Dunn,
Lisa A. Mendez		 9
MWSUG 2009 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter 10
MWSUG 2009 Using the Data Step's ATTRIB Statement to both Manage and Document Variables in a SAS Dataset (lightly) Philip A. Wright 8
NESUG 2009 Choosing the Right Technique to Merge Large Data Sets Efficiently Qingfeng Liang 9
NESUG 2009 Using DATA STEP MERGE and PROC SQL JOIN to Combine SAS Datasets Dalia C. Kahane 15
NESUG 2009 Using SQL Joins to Perform Weighted Matches on Multiple Identifiers Jedediah J. Teres 8
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 Choosing the Right Technique to Merge Large Data Sets Efficiently Qingfeng Liang source 9
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 Parameter-Driven Data Integration Using SAS Stored Processes Evangeline Collado source 8
SGF 2009 Scalability of Table Lookup Techniques Richard D. Langston source 5
WUSS 2008 Demystifying PROC SQL Join Algorithms Kirk Paul Lafler 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 Exploring the Undocumented PROC SQL _METHOD Option Kirk Paul Lafler source 2
PNWSUG 2008 Exploring PROC SQL Joins and Join Algorithms Kirk Paul Lafler 6
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 Exploring the Undocumented PROC SQL _METHOD Option Kirk Paul Lafler source 2
SGF 2008 Going Beyond Simple Information Maps to Improve Access to Data Sources Jerry High source 8
SGF 2008 Joining Data: Data Step Merge or SQL? Faisal Dosani,
Harry Droogendyk		 source 19
SGF 2008 Many-to-Many Merges in the DATA Step Edward Heaton source 9
NESUG 2007 A Hands-on Tour Inside the World of PROC SQL Kirk Paul Lafler 18
SESUG 2007 Set, Match, Merge ... Don't You Love SAS Peter W. Eberhardt,
Ying Liu		 source 19
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 Integrating data transformations using DI Studio and SAS DD Alistair Dootson source 15
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
SGF 2007 A Hands-on Tour Inside the World of PROC SQL Kirk Paul Lafler,
Ben Cochran		 source 13
SGF 2007 Super Size It!!! Maximize the Performance of Your ETL Processes Nancy A. Rausch,
Nancy J. Wills		 source 14
SGF 2007 The "Ins" and "Outs" of SAS Data Integration Studio Chris Weeks,
Tim Olinger		 source 20
SESUG 2006 Stars and Models: How to Build and Maintain Star Schemas Using SAS Data Integration Server in SAS9 Nancy A. Rausch source 24
WUSS 2006 A Hands-on Tour Inside the World of PROC SQL Kirk Paul Lafler source 11
PharmaSUG 2006 A Comparison Between SQL and Data Step and Some SAS Procedures LaTonya Murphy 6
SUGI 2006 A Hands-on Tour Inside the World of PROC SQL Kirk Paul Lafler source 11
SUGI 2006 Stars and Models - How to Build and Maintain Star Schemas Using SAS ETL Server Nancy A. Rausch source 24
PNWSUG 2005 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter 10
SESUG 2005 A Quick Tour of SAS ETL Studio to Build a Data Mart Kari Richardson source 20
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 The Optimizer Project: WHERE The Statement Is Not The Clause Paul D. Sherman,
Russell M. Lavery		 source 15
NESUG 2005 A Quick Tour of SAS ETL Studio to Build a Data Mart Kari Richardson 20
PharmaSUG 2005 Everything You Always Wanted to Know About Fuzzy Merges But Were Afraid to Ask - A Guide to Merging Datasets with Non-Exact Keys Using SAS Proc SQL Robert W. Graebner 4
PharmaSUG 2005 Preventing Data Loss when Combining SAS Datasets John Cantrell 9
SUGI 2005 A Quick Tour of SAS ETL Studio to Build a Data Mart Eric Rossland,
Kari Richardson		 source 20
SUGI 2005 A SAS Macro for Producing Customized Reports Robert G. Edson,
Yajie Wang,
Lan Zhao		 source 10
SUGI 2005 Merging versus Joining: Comparing the DATA Step with SQL Malachy J. Foley source 18
WUSS 2004 Methods For Combining SAS Data Sets Of Varying Sizes: Which Method To Use When? Hugh Roghmann source 7
WUSS 2004 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter source 10
PharmaSUG 2004 A Visual Introduction to PROC SQL Joins Kirk Paul Lafler 5
SUGI 2004 Quicker Than Merge? Kirby L. Cossey source 7
WUSS 2003 A Visual Introduction to SQL Joins Kirk Paul Lafler,
Charles E. Shipp		 source 3
WUSS 2003 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter source 7
SCSUG 2003 Merge Processing and Alternative Table Lookup Techniques Destiny Corporation (a company) 7
SCSUG 2003 Quicker Than Merge? Kirby L. Cossey 5
SESUG 2003 Merge Processing and Alternate Table Lookup Techniques Destiny Corporation (a company) 7
NESUG 2003 Next Generation Warehousing with Version 9 Gary Mehler 10
SEUGI 2003 SAS SPD Server 4.0 Scalable Storage for SAS Marketing Automation [presentation] Jochen Kirsten source 33
SUGI 2003 Make Your SAS/ACCESS Query More Efficient Jianming He,
Dinesh Jain,
Cheng Wang		 source 3
SUGI 2003 Next Generation Warehousing with Version 9 Gary Mehler source 10
SUGI 2003 Ring Charts David J. Corliss source 5
SCSUG 2002 MERGING: Comparing the DATA Step with SQL Malachy J. Foley 11
NESUG 2002 An Animated Guide: Speed Merges with Key Indexing, Bitmapping and Hashing Paul M. Dorfman,
Russell M. Lavery		 10
NESUG 2002 Subsetting SAS Data Set by Using PROC SQL Self-join with Compound Key Zizhong (James) Fan 2
SESUG 2002 MERGING: Comparing the DATA Step with SQL Malachy J. Foley source 10
SEUGI 2002 Banking Transactions Analysis using SAS Software [presentation] Lioudmila Dmitrieva,
Roman Volynets		 source 31
SEUGI 2002 SAS SPD Server, applying intelligence to data storage [presentation] Jochen Kirsten source 26
SUGI 2002 An Introduction to SAS PROC SQL Timothy J. Harrington source 6
SUGI 2002 SAS Accessing DB2 Data: a Performance Victory Away Henri Theuwissen,
Nancy Croonen		 source 9
SUGI 2002 Table Look-up: Techniques Beyond the Obvious Henri Theuwissen,
Nancy Croonen		 source 9
MWSUG 2001 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter 8
SESUG 2001 Direct Addressing Techniques of Table Look-Up Part 1. Key-Indexing - Bitmapping Part 2. Hashing Paul M. Dorfman source 10
SUGI 2001 Table Look-Up by Direct Addressing: Key-Indexing - Bitmapping - Hashing Paul M. Dorfman source 10
SESUG 2000 Table Lookup via Direct Addressing: Key-Indexing, Bitmapping, Hashing Paul M. Dorfman source 11
NESUG 2000 Merge Processing - Alternative Table Lookup Techniques Destiny Corporation (a company) 8
MWSUG 2000 Ring Charts David J. Corliss 7
SUGI 2000 Merges and Joins Timothy J. Harrington source 6
NESUG 1999 Alternatives to Merging SAS Data Sets But Be Careful Michael J. Wieczkowski 7
SCSUG 1998 Data Warehousing Efficiency Techniques with the SAS System Tony Brown 10
NESUG 1998 Efficient Access to Data Warehouse With PROC SQL Pass Through Facility James Yang 7
SESUG 1998 Data Warehouse Efficiency Techniques with the SAS System Tony Brown 10
MWSUG 1995 A New Approach to Outer Joins with More than Two Tables Howard Levine 10
MWSUG 1995 SQL Joins - The Long and The Short of It Paul Kent 10
NESUG 1995 SQL Joins - The Long and The Short of It Lewis Church Jr.,
Paul Kent		 10
SESUG 1995 Applications Development DOES PROGRAM EFFICIENCY REALLY MATTER ANYMORE? Sigurd W. Hermansen 10
SEUGI 1995 Tips to Merge Large Datasets or Views, and Tips to Percent in PROC TABULATE Per Andersen source 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
SUGI 1995 SOL Joins - The Long and the Short of it Paul Kent source 10
WUSS 1994 Joining Tables of Data in the SQL Procedure Kirk Paul Lafler source 6
NESUG 1994 SQL Joins - The Long and The Short of It Paul Kent 10
SESUG 1994 rurORIALS Paul Kent 10
SUGI 1994 Processing Large SAS and DB2 Files: Close Encounters of the Colossal Kind Judy Loren,
Alan Dickson		 source 8
NESUG 1993 Close Encounters of the Colossal Kind: How Can Large SAS and DB2 Files Get Together? Judy Loren,
Alan Dickson		 8
NESUG 1993 Fun with the SQL Procedure - An Advanced Tutorial Paul Kent,
Lewis Church Jr.		 6
MWSUG 1993 Relational Processing of Tape Databases Howard Levine 9
SUGI 1993 Relational Processing of Tape Databases Howard Levine source 9
SCSUG 1992 Database Wars: Part I -- Memoirs of a SAS Technical Support Analyst Kathe Richards 6
SUGI 1991 Normalized Data: Implications for the Use of SAS Software, SQL, and Views Patricia L. Gerend source 5
SUGI 1982 Set Merge and Update Peter L. Rikard source 4

Back to keywords