Lafler, kirk paul 2007, undocumented and hardtofind proc sql features, proceedings of the. American engineer, programmer, author, entrepreneur, consultant, and founder of software intelligence. Even if you have not, you will certainly be amazed at the wealth of. Kirk paul lafler, consultant and founder of software intelligence corporation, has been programming using sas software since 1979. Datadriven programming techniques using sas metadata. Kirk paul lafler, software intelligence corporation, spring valley, california abstract sas users can easily and quickly access metadata content with a number of readonly sas data sets called dictionary tables or their counterparts, sashelp views. Kirk paul lafler lecturer and adjunct professor san. At that time, this was mainly related to sas activities, in which he has been an expert since 1979.
Kirk teaches sas programming classes at uc san diego extension and to the public, is a sas certified professional, application developer, programmer, data analyst, mentor, and provider of it consulting. Kirk paul lafler software intelligence corporation become a rock star sas professional kirk paul lafler software intelligence corporation five ways to flipflop your data josh horstman nested loop consulting. Software intelligence has been used by kirk paul lafler, an american engineer, entrepreneur, and consultant and founder of software intelligence corporation. This paper explores what an index is, the purpose of an index, how an index is created. Kirk paul lafler highimpact instructorled and handson sas software training by kirk paul lafler and software intelligence corporation greater san diego area. Kirk paul lafler, software intelligence corporation abstract if you ever needed to display two or more observations from a sas system data set in a custom full screen display without using. Fuzzy matching programming techniques using sas software. Kirk paul lafler, software intelligence corporation abstract if you ever needed to display two or more observations from a sas system data set in a custom full screen display without using the sasifsp product, then dynamic extended tables may be for you. The explosion of internet technologies, especially electronic delivery of data, is on the rise. Exploring the world of proc sql joins kirk paul lafler, software intelligence corporation abstract real systems rarely store all their data in one large table.
The software bundle includes base sas, sasstat, sasiml, designer studio. About the authors kirk paul lafler is consultant and founder of software intelligence corporation and has been programming in sas since 1979. Kirk paul lafler rss consultant and founder of software intelligence corporation kirk paul lafler, consultant and founder of software intelligence corporation, has been a sas. Apr 25, 2017 kirk paul lafler rss consultant and founder of software intelligence corporation kirk paul lafler, consultant and founder of software intelligence corporation, has been a sas user since 1979.
Kirk paul lafler is an entrepreneur, founder and lifelong sas learner at software intelligence corporation. Oct 07, 2014 kirk lafler, president of san diegobased software intelligence corporation and one of the worlds leading experts in sas software, describes the power of benchworkzz in the development of sas. The sas macro language is a powerful feature for extending and customizing the capabilities of the sas system. Kirk paul lafler lecturer and adjunct professor san diego. Sas\u00aeprogrammingtipstricksandtechniquesscsug2012. As the founder of software intelligence corporation in 1983, kirk provides it services and training to fortune companies and government installations by designing and developing application software solutions, comprehensive training, and custom programming services. Software intelligence corporation, spring valley, ca, usa. Benchworkzz provides stronger, more reliable sas code, a. Kirk lafler, consultant and founder of software intelligence corporation, has been a sas user since 1979. Kirk paul lafler sas consultant, application developer.
Kirk paul lafler is an entrepreneur, founder, and consultant at software intelligence corporation and has worked with sas software since 1979. An introduction to proc report kirk paul lafler software intelligence corporation, spring valley, california abstract sas users often need to create and deliver quality custom reports and. Kirk paul lafler has been programming in sas since 1979 and is consultant and founder of software intelligence corporation. Lafler, kirk paul 2006, exploring dictionary tables with proc sql. Powerful and hard to find proc sql features kirk paul lafler, software intelligence corporation adding a little magic to your joins kirk paul lafler, software intelligence corporation mixed. Kirk lafler, president of san diegobased software intelligence corporation and one of the worlds leading experts in sas software, describes the power of benchworkzz in the. Lafler, kirk paul 2010, data step and pro sql programming techniques, ohio sas users group. As a sas certified professional, kirk provides it consulting services and training to sas users around the world. Downloading, configuring, and using the free sas university edition software kirk paul lafler, software intelligence corporation, spring valley, california charles edwin shipp, consider consulting corporation, san pedro, california abstract. Citeseerx 2002, a visual introduction to sql joins. Friday halfday class kirk lafler western users of sas. Hundreds of companies rely on cast software intelligence to improve enduser satisfaction and timetomarket, prevent business disruption and reduce cost, enabling them to move past todays obstacles and to tackle the next wave of innovation.
Beyond the basics using sas, second edition, sas institute inc. Paper tu06 a visual introduction to proc sql joins kirk paul lafler, software intelligence corporation charles edwin shipp, shipp consulting abstract real systems rarely store all their data in one large table. Stored in files and data sets, sas users across industries. An introduction to proc report nebraska sas users group. Kirk is a sas application developer, programmer, certified. Kirk paul lafler is an entrepreneur and founder at software intelligence corporation, and has used sas software since 1979 as a consultant, application developer, programmer, sas solutions provider, data analyst, data manager, infrastructure specialist, performance tuner, educator and author.
Kirk paul lafler is an entrepreneur, consultant, and founder at software intelligence corporation, and has been using sas since 1979. Fuzzy matching programming techniques using sas software stephen sloan, accenture kirk paul lafler, software intelligence corporation abstract data comes in all forms, shapes, sizes and complexities. Lafler, kirk paul 2007, undocumented and hardtofind proc sql features, proceedings of the pharmasug 2007 conference, software intelligence corporation, spring valley, ca, usa. Hundreds of companies rely on cast software intelligence to improve enduser satisfaction and timeto. He has worked with sas software since 1979 as a consultant, application designer and. Add a little magic to your joins, continued 6 references lafler, kirk paul 20. Structured query language sql is a universal language that allows you. Kirk paul lafler, software intelligence corporation abstract in an age of internet frenzy, output delivery is experiencing incredible interest around the globe. Nov 19, 2018 kirk paul lafler is an entrepreneur and founder at software intelligence corporation, and has used sas software since 1979 as a consultant, application developer, programmer, sas solutions. Kirk paul lafler is consultant and founder of software intelligence corporation and has been using sas since 1979. American engineer, programmer, author, entrepreneur, consultant, and founder of software intelligence corporation.
Lafler, kirk, consultant and founder of software intelligence corporation. Downloading, configuring, and using the free sas university. Software intelligence see the truth, be a software genius, and deliver super software. Understanding where clause processing and indexes kirk paul lafler, software intelligence corporation, spring valley, ca abstract sas users can quickly access selected observations rows of data in sas data sets using where clause processing and indexes. Custom reporting with proc report and ods excel handson presented. To do so would require maintaining several duplicate copies of the same values and could threaten the integrity of the data. Kirk provides it consulting services and training to sas users around the world. Exploring dictionary tables and sashelp views kirk paul lafler, software intelligence corporation, spring valley, california abstract sas users can quickly and conveniently obtain useful information about their sas session with a number of readonly sas data views called dictionary tables or sashelp views. Citeseerx output delivery system tips and techniques. An american engineer, programmer, entrepreneur, consultant and founder of software intelligence. Using a loop counter as part of a data stepvariable name posted 07282009 1253 views in reply to danielsantos suggest that the op back up and reply to this post with detailed. Kirk paul lafler lecturer and adjunct professor san diego state. Kirk paul lafler, consultant and founder of software intelligence corporation, has been a sas user since 1979. As the founder of software intelligence corporation in 1983, kirk provides it services and training to fortune.
He is a sas certified professional, provider of it consulting services, trainer to sas users around the world, and emeritus. Kirk paul lafler is an entrepreneur and founder at software intelligence corporation, and has used sas software since 1979 as a consultant, application developer, programmer, sas solutions. Since 1979, kirk has served as a sas consultant and specialist, certified professional, application and tool developer, programmer, data analyst, educator, and author. Friday halfday class kirk lafler western users of sas software. Sas users are always interested in learning techniques that will help them improve the performance of table lookup, search, and sort operations. Kirk paul lafler is an entrepreneur and founder of order of magnitude analytics and software intelligence corporation. Kirk paul lafler is an entrepreneur and founder at software intelligence corporation, and has used sas software since 1979 as a consultant, application developer. He has worked with sas software since 1979 as a consultant, application designer and developer, programmer, sas solutions provider, data analyst, educator, and author. He is a sas certified professional, sas institute alliance member 1996 2002, and provider of it consulting services and training to sas users around the world. Sas software supports a data step programming technique known as a hash object to associate a key with one or more values.
His popular sas tips column, kirks korner of quick and simple tips, appears regularly in several sas user group newsletters and websites. Sas author kirk lafler, consultant and founder of software intelligence corporation, has been a sas user since 1979. Tune your sas system for max performance sas users groups. Kirk paul lafler, software intelligence corporation. Lafler, kirk paul 2012, exploring ditionary tables and sashelp views, south central sas users group scsug conference. Lafler, kirk paul 2012, exploring ditionary tables and sashelp views, south central sas users group scsug conference, software intelligence corporation, spring valley, ca, usa. As founder of software intelligence corporation in 1983, kirk provides it services provider to fortune companies. This workshop presents a practical approach to macro tool design and development, along with a collection of techniques for constructing reusable and effective. A handson introduction to sas hash programming techniques. Kirk paul lafler, software intelligence corporation, spring valley, california. Meeting march th, 2008, software intelligence corporation, spring valley, ca, usa. Paper tu06 a visual introduction to proc sql joins kirk paul lafler, software intelligence corporation charles edwin shipp, shipp consulting abstract real systems rarely store all their.
Software intelligence has been used by kirk paul lafler, an american engineer, entrepreneur, and consultant and founder of software intelligence corporation in 1979. As founder of software intelligence corporation in 1983, kirk provides it services provider to fortune companies and government installations by designing and developing application software solutions, and providing comprehensive training and custom programming services. Kirk paul lafler is founder and entrepreneur at software intelligence corporation. Datadriven programming techniques using sas metadata kirk paul lafler, software intelligence corporation abstract datadriven programming, or data oriented programming dop, is a specific programming paradigm where the data, or data structures, itself controls the flow of a program and not the program logic. Kirk paul lafler is consultant and founder of software intelligence corporation and has been programming in sas since 1979. As digital commerce forces fundamental changes in the nature. Beyond the basics using sas, third edition 3rd edition. He is a sas certified professional, sas institute alliance. Kirk paul lafler has worked as a software consultant for the last 25 years. He has worked with sas software since 1979 as a consultant, application designer and developer. During a sas session, information known as metadata is captured including sas system. Software intelligence has been used by kirk paul lafler, an american engineer, entrepreneur and consultant and founder of software intelligence corporation in 1979.