References

Abolafia, Jeff, and Frank DiIorio. 2008. “Managing The Change And Growth Of A Metadata-Based System.” In Proceedings of the SAS^® Global Forum 2008 Conference. Cary, NC: SAS Institute Inc. https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/128-2008.pdf.

Batkhan, Leonid. 2016. “Modifying variable attributes in all datasets of a SAS library.” SAS Users Blog, http://blogs.sas.com/content/sgf/2016/11/25/modifying-variable-attributes-in-all-datasets-of-a-sas-library/.

Batkhan, Leonid. 2017. “CALL EXECUTE made easy for SAS data-driven programming.” SAS Users Blog, https://blogs.sas.com/content/sgf/2017/08/02/call-execute-for-sas-data-driven-programming/.

Burlew, Michele M. 2014. SAS^® Macro Programming Made Easy, Third Edition. Cary, NC: SAS Institute Inc.

Cadieux, Richard, and Daniel R. Brethiem. 2014. “Matching Rules: Too Loose, Too Tight, or Just Right?” In Proceedings of the SAS^® Global Forum 2014 Conference. Cary, NC: SAS Institute Inc. http://support.sas.com/resources/papers/proceedings14/1674-2014.pdf.

Carpenter, Art. 2016. Carpenter’s Complete Guide to the SAS^® Macro Language, Third Edition. Cary, NC: SAS Institute Inc.

Carpenter, Arthur L. 2017. “Building Intelligent Macros: Using Metadata Functions with the SAS^® Macro Language.” In Proceedings of the SAS^® Global Forum 2017 Conference. Cary, NC: SAS Institute Inc. http://support.sas.com/resources/papers/proceedings17/0835-2017.pdf.

Celko, Joe. 2014. Joe Celko’s SQL for Smarties: Advanced SQL Programming, Fifth Edition. San Francisco, CA: Morgan Kaufman.

Cody, Ron. 2010. SAS^® Functions by Example, Second Edition. Cary, NC: SAS Institute Inc.

Cody, Ron. 2017. Cody's Data Cleaning Techniques Using SAS^®, Third Edition. Cary, NC: SAS Institute Inc.

Davis, Michael. 2001. “You Could Look It Up: An Introduction to SASHELP Dictionary Views.”  In Proceedings of the Twenty-Sixth Annual SAS® Users Group International Conference. Cary, NC: SAS Institute Inc. https://support.sas.com/resources/papers/proceedings/proceedings/sugi26/p017-26.pdf.

Droogendyk, Harry. 2010. “SAS^® Formats: Effective and Efficient.” In Proceedings of the 2010 South East SAS Users Group (SESUG) Conference. https://analytics.ncsu.edu/sesug/2010/FF04_Droogendyk.pdf.

Dunn, Toby. 2014. “Getting the Warm and Fuzzy Feeling with Inexact Matching.” In Proceedings of the SAS® Global Forum 2014 Conference. Cary, NC: SAS Institute Inc. http://support.sas.com/resources/papers/proceedings14/1316-2014.pdf.

Erinjeri, Jinson J., and Saritha Bathi. 2017. “Applying IFN and IFC Functions.” In Proceedings of the 2017 South East SAS Users Group (SESUG) Conference. https://analytics.ncsu.edu/sesug/2017/SESUG2017_Paper-153_Final_PDF.pdf.

Foley, Malachy J. 1999. “FUZZY MERGES: Examples and Techniques.” In Proceedings of the Twenty-Fourth Annual SAS^® Users Group International Conference. Cary, NC: SAS Institute Inc. https://support.sas.com/resources/papers/proceedings/proceedings/sugi24/Advtutor/p46-24.pdf.

Graebner, Robert W. 2001. “Developing Data-Driven SAS^® Programs Using Proc Contents.” In Proceedings of the 2001 MidWest SAS Users Group (MWSUG) Conference. https://www.lexjansen.com/mwsug/2001/ApplicationDevelopment/APP-009-developing.pdf.

Gupta, Sunil. 2003. Quick Results with the Output Delivery System. Cary, NC: SAS Institute Inc.

Hamilton, Jack. 1998. “Some Utility Applications Using the Dictionary Tables in PROC SQL.” In Proceedings of the 1998 Western Users of SAS Software (WUSS) Conference, 85-90. https://www.lexjansen.com/wuss/1998/WUSS98017.pdf.

Haworth, Lauren E., Cynthia L. Zender, and Michele M. Burlew. 2009. Output Delivery System: The Basics and Beyond. Cary, NC: SAS Institute Inc.

Hermansen, Sigurd W., and Stanley E. Legum. 2008. “Existential Moments in Database Programming:  SAS® PROC SQL EXISTS and NOT EXISTS Quantifiers, and More.” In Proceedings of the SAS^® Global Forum 2008 Conference. Cary, NC: SAS Institute Inc. https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/084-2008.pdf

Lafler, Kirk Paul. 2005. “Exploring DICTIONARY Tables and SASHELP Views.” In Proceedings of the Thirteenth Annual Western Users of SAS Software Conference. https://www.lexjansen.com/wuss/2005/data_warehousing_and_database_management/dwdb_exploring_dictionary.pdf

Lafler, Kirk Paul. 2006. “Exploring Dictionary Tables with PROC SQL.” SAS Press Webinar Series, http://support.sas.com/publishing/bbu/webinar.html#lafler2.

Lafler, Kirk Paul. 2008. “Undocumented and Hard-to-find PROC SQL^® Features.” In Proceedings of the Greater Atlanta SAS Users Group (GASUG) Meeting (June 11^th, 2008); Pharmaceutical SAS Users Group (PharmaSUG) Conference (June 1^st – 4^th, 2008); 2008 Michigan SAS Users Group (MSUG) Meeting (May 29^th, 2008); 2008 Vancouver SAS Users Group Meeting (April 23^rd, 2008); and 2008 PhilaSUG User Group Meeting (March 13^th, 2008). https://www.lexjansen.com/pharmasug/2008/tt/TT02.pdf

Lafler, Kirk Paul. 2009. “DATA Step versus PROC SQL Programming Techniques.” In Proceedings of the 2009 South East SAS Users Group (SESUG) Conference. https://analytics.ncsu.edu/sesug/2009/FF003.Lafler.pdf.

Lafler, Kirk Paul. 2009. “Exploring DICTIONARY Tables and SASHELP Views.” In Proceedings of the 2009 Western Users of SAS Software (WUSS) Conference and 2009 Pharmaceutical SAS Users Group (PharmaSUG) Conference. https://www.lexjansen.com/wuss/2009/dmw/DMW-Lafler.pdf.

Lafler, Kirk Paul. 2012. “Exploring DICTIONARY Tables and SASHELP Views.” In Proceedings of the 2012 South Central SAS Users Group (SCSUG) Conference and Kansas City SAS Users Group (KCSUG) Meeting. https://www.lexjansen.com/scsug/2012/Exploring-DICTIONARY-Tables-and-SASHELP-Views-SCSUG-2012.pdf.

Lafler, Kirk Paul. 2013. PROC SQL: Beyond the Basics Using SAS^®, Second Edition. Cary, NC: SAS Institute, Inc.

Lafler, Kirk Paul. 2016. “Removing Duplicates Using SAS^®.” In Proceedings of the 2016 MidWest SAS Users Group (MWSUG) Conference. https://www.lexjansen.com/mwsug/2016/TT/MWSUG-2016-TT02.pdf.

Lafler, Kirk Paul. 2016. “Important & Valuable Things You Can Do with SAS^® Metadata DICTIONARY Tables and SASHELP Views.” In Proceedings of the 2016 Wisconsin Illinois SAS Users (WIILSU) Conference. http://www.wiilsu.org/sdajgfuirHIUTlsdfnloa312/SUSJun2016/Proceedings/Papers/Lafler%20-%20Valuable%20Things%20You%20Can%20Do%20with%20SAS%20DICTIONARY%20Tables%20and%20SASHELP%20Views.pdf

Lafler, Kirk Paul. 2017. “Removing Duplicates Using SAS^®.” In Proceedings of the 2017 South Central SAS Users Group (SCSUG) Conference. https://www.lexjansen.com/scsug/2017/Removing-Duplicates-Using-SAS-SCSUG-2017.pdf.

Lafler, Kirk Paul. 2018. “Introduction to Data-driven Programming Using SAS^®.” In Proceedings of the 2018 South Central SAS Users Group (SCSUG) Conference. https://www.lexjansen.com/scsug/2018/Introduction%20to%20Data-driven%20Programming%20Using%20SAS%20(SCSUG%202018).pdf.

Lafler, Kirk Paul, and Stephen Sloan. 2017. “A Quick Look at Fuzzy Matching Programming Techniques Using SAS^® Software.” In Proceedings of the 2017 Western Users of SAS Software (WUSS) Conference. https://www.lexjansen.com/wuss/2017/129_Final_Paper_PDF.pdf.

Lafler, Kirk Paul, and Stephen Sloan. 2017. “Fuzzy Matching Programming Techniques Using SAS^® Software.” In Proceedings of the 2017 South Central SAS Users Group (SCSUG) Conference. https://www.lexjansen.com/scsug/2017/Fuzzy-Matching-Programming-Techniques-Using-SAS-Software-SCSUG-2017.pdf.

Lorie, Raymond A., and Jean-Jacques Daudenarde. 1991. SQL & Its Applications. Upper Saddle River, NJ: Prentice Hall.

Matise, Joe. 2016. “Writing Code With Your Data:  Basics of Data-Driven Programming Techniques.” In Proceedings of the 2016 South East SAS Users Group (SESUG) Conference. https://analytics.ncsu.edu/sesug/2016/BB-229_Final_PDF.pdf.

McConnell, Steve. 2004. Code Complete: A Practical Handbook of Software Construction, Second Edition. Redmond, WA: Microsoft Press.

Olson, Diane. 2000. “Power Indexing: A Guide to Using Indexes Effectively in Nashville Releases.” In Proceedings of the 2000 SAS Users Group International (SUGI) Conference. https://support.sas.com/resources/papers/proceedings/proceedings/sugi25/25/dw/25p124.pdf.

Patridge, Charles. 1997. “The Fuzzy Feeling SAS Provides: Electronic Matching of Records without Common Keys.” In Proceedings of the 1997 SAS Users Group International (SUGI) Conference. https://support.sas.com/resources/papers/proceedings/proceedings/sugi22/APPDEVEL/PAPER28.PDF.

Perry, William E. 2006. Effective Methods for Software Testing, Third Edition. Indianapolis, IN: Wiley Publishing, Inc.

Raithel, Michael A. 2006. The Complete Guide to SAS^® Indexes. Cary, NC: SAS Institute Inc.

Raithel, Michael A. 2016. “Hack 3.21 Saving the Output of PROC CONTENTS to a SAS Data Set.” Michael A. Raithel’s Blog, http://michaelraithel.blogspot.com/2016/10/hack-321-saving-output-of-proc-contents.html.

Raithel, Michael A. 2016. “PROC DATASETS; The Swiss Army Knife of SAS^® Procedures.” In Proceedings of the SAS^® Global Forum 2016 Conference. Cary, NC: SAS Institute Inc. http://support.sas.com/resources/papers/proceedings16/3440-2016.pdf.

RHO. 2000. “TRANSFORMING SAS DATA SETS.” http://www.rhoworld.com/pdf/ch599.pdf.

Roesch, Amanda. 2012. “Matching Data Using Sounds-Like Operators and SAS^® Compare Functions.” In Proceedings of the SAS^® Global Forum 2012 Conference. Cary, NC: SAS Institute Inc. http://support.sas.com/resources/papers/proceedings12/122-2012.pdf.

Russell, Kevin. 2015. “How to perform a fuzzy match using SAS functions.” SAS Users blog, https://blogs.sas.com/content/sgf/2015/01/27/how-to-perform-a-fuzzy-match-using-sas-functions/.

SAS Institute Inc. 2000. “SAS Usage Note 1566: Why duplicate observations occur when using PROC SORT with the NODUPRECS option.” http://support.sas.com/kb/1/566.html.

SAS Institute Inc. 2011. SAS^® 9.3 Macro Language: Reference. Cary, NC: SAS Institute Inc.

SAS Institute Inc. 2018. SAS^® 9.4 Language Reference: Concepts, Sixth Edition. Cary, NC: SAS Institute Inc.

Schreier, Howard. 2006. “SQL Set Operators: So Handy Venn You Need Them.” In Proceedings of the Thirty-first Annual SAS® Users Group International Conference. Cary, NC: SAS Institute Inc. https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/242-31.pdf.

Schreier, Howard. 2008. PROC SQL by Example: Using SQL within SAS^®. Cary, NC: SAS Institute Inc.

Sloan, Stephen, and Dan Hoicowitz. 2016. “Fuzzy Matching: Where Is It Appropriate and How Is It Done? SAS® Can Help.” In Proceedings of the SAS^® Global Forum 2016 Conference. Cary, NC: SAS Institute Inc. http://support.sas.com/resources/papers/proceedings16/7760-2016.pdf.

Sloan, Stephen, and Kirk Paul Lafler. 2018. “Fuzzy Matching Programming Techniques Using SAS^® Software.” In Proceedings of the 2018 SouthEast SAS Users Group (SESUG) Conference. https://www.lexjansen.com/sesug/2018/SESUG2018_Paper-143_Final_PDF.pdf.

Sloan, Stephen, and Kirk Paul Lafler. 2018. “Fuzzy Matching Programming Techniques Using SAS^® Software.” In Proceedings of the SAS^® Global Forum 2018 Conference. Cary, NC: SAS Institute Inc. https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2886-2018.pdf.

Staum, Paulette. 2007. “Fuzzy Matching using the COMPGED Function.” In Proceedings of the 2007 NorthEast SAS Users Group (NESUG) Conference. https://www.lexjansen.com/nesug/nesug07/ap/ap23.pdf.

Telles, Matthew A., and Yuan Hsieh. 2001. The Science of Debugging. Scottsdale, AZ: The Coriolis Group.

Teres, Jedediah J. 2011. “Using SQL Joins to Perform Fuzzy Matches on Multiple Identifiers.” In Proceedings of the 2011 NorthEast SAS Users Group (NESUG) Conference. https://www.lexjansen.com/nesug/nesug11/ps/ps07.pdf.

Varney, Brian. 2000. “Using Metadata for Data Driven Programming.” In Proceedings of the Twenty-Fifth Annual SAS^® Users Group International Conference. Cary, NC: SAS Institute Inc. https://support.sas.com/resources/papers/proceedings/proceedings/sugi25/25/cc/25p077.pdf.

Villacorte, Renato G. 2012. “Go Beyond The Wizard With Data-Driven Programming.” In Proceedings of the SAS^® Global Forum 2012 Conference. Cary, NC: SAS Institute Inc. http://support.sas.com/resources/papers/proceedings12/148-2012.pdf.

Wang, Hui. 2015. “Creating Data-Driven SAS^® Code with CALL EXECUTE.” In Proceedings of the 2015 PharmaSUG Conference. https://www.pharmasug.org/proceedings/2015/BB/PharmaSUG-2015-BB15.pdf.

Whitcher, Mike. 2008. “New SAS^® Performance Optimizations to Enhance Your SAS^® Client and Solution Access to the Database.” In Proceedings of the SAS^® Global Forum 2008 Conference. Cary, NC: SAS Institute Inc. https://support.sas.com/resources/papers/sgf2008/optimization.pdf.

Whitlock, Ian. 1998. “CALL EXECUTE: How and Why.” In Proceedings of the Twenty-Third Annual SAS^® Users Group International Conference. Cary, NC: SAS Institute Inc. https://support.sas.com/resources/papers/proceedings/proceedings/sugi22/CODERS/PAPER70.PDF.

Whitlock, Ian. 2006. “How to Think Through the SAS^® DATA Step.” In Proceedings of the Thirty-first Annual SAS^® Users Group International Conference. Cary, NC: SAS Institute Inc. https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/246-31.pdf.

Williams, Christianna S. 2012. “Queries, Joins, and WHERE Clauses, Oh My!! Demystifying PROC SQL.” In Proceedings of the SAS^® Global Forum 2012 Conference. Cary, NC: SAS Institute Inc. http://support.sas.com/resources/papers/proceedings12/149-2012.pdf.

Zirbel, Douglas. 2009. “Learn the Basics of Proc Transpose.” In Proceedings of the SAS^® Global Forum 2009 Conference. Cary, NC: SAS Institute Inc. http://support.sas.com/resources/papers/proceedings09/060-2009.pdf.