During a sas session, information known as metadata is captured including sas system. 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. As founder of software intelligence corporation in 1983, kirk provides it services provider to fortune companies. Software intelligence has been used by kirk paul lafler, an american engineer, entrepreneur, and consultant and founder of software intelligence corporation. Kirk paul lafler lecturer and adjunct professor san diego state. 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. 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. Friday halfday class kirk lafler western users of sas. Lafler, kirk paul 2012, exploring ditionary tables and sashelp views, south central sas users group scsug conference, software intelligence corporation, spring valley, ca, usa. Lafler, kirk, consultant and founder of software intelligence corporation. Add a little magic to your joins, continued 6 references lafler, kirk paul 20. Beyond the basics using sas, third edition 3rd edition. Citeseerx 2002, a visual introduction to sql joins.
Sas author kirk lafler, consultant and founder of software intelligence corporation, has been a sas user since 1979. Kirk paul lafler, software intelligence corporation. 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. 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. Kirk paul lafler, consultant and founder of software intelligence corporation, has been programming using sas software since 1979. At that time, this was mainly related to sas activities, in which he has been an expert since 1979. Beyond the basics using sas, second edition, sas institute inc. 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.
Sas software supports a data step programming technique known as a hash object to associate a key with one or more values. 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. Kirk paul lafler highimpact instructorled and handson sas software training by kirk paul lafler and software intelligence corporation greater san diego area. The sas macro language is a powerful feature for extending and customizing the capabilities of the sas system. Kirk provides it consulting services and training to sas users around the world. Friday halfday class kirk lafler western users of sas software. Kirk paul lafler sas consultant, application developer. This paper explores what an index is, the purpose of an index, how an index is created. Kirk paul lafler is an entrepreneur and founder of order of magnitude analytics and software intelligence corporation. Kirk paul lafler is consultant and founder of software intelligence corporation and has been using sas since 1979. 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. Lafler, kirk paul 2012, exploring ditionary tables and sashelp views, south central sas users group scsug conference. 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.
Software intelligence has been used by kirk paul lafler, an american engineer, entrepreneur, and consultant and founder of software intelligence corporation in 1979. As a sas certified professional, kirk provides it consulting services and training to sas users around the world. Even if you have not, you will certainly be amazed at the wealth of. Lafler, kirk paul 2007, undocumented and hardtofind proc sql features, proceedings of the.
His popular sas tips column, kirks korner of quick and simple tips, appears regularly in several sas user group newsletters and websites. Benchworkzz provides stronger, more reliable sas code, a. Kirk paul lafler is an entrepreneur and founder at software intelligence corporation, and has used sas software since 1979 as a consultant, application developer. Kirk paul lafler has been programming in sas since 1979 and is consultant and founder of software intelligence corporation. Lafler, kirk paul 2010, data step and pro sql programming techniques, ohio sas users group. American engineer, programmer, author, entrepreneur, consultant, and founder of software intelligence corporation. 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. Kirk paul lafler lecturer and adjunct professor san diego. The explosion of internet technologies, especially electronic delivery of data, is on the rise. Kirk paul lafler lecturer and adjunct professor san.
Kirk paul lafler, software intelligence corporation, spring valley, california. Meeting march th, 2008, software intelligence corporation, spring valley, ca, usa. Sas\u00aeprogrammingtipstricksandtechniquesscsug2012. Stored in files and data sets, sas users across industries. Structured query language sql is a universal language that allows you. An introduction to proc report nebraska sas users group. 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 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 has worked as a software consultant for the last 25 years. 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. Lafler, kirk paul 2007, undocumented and hardtofind proc sql features, proceedings of the pharmasug 2007 conference, software intelligence corporation, spring valley, ca, usa. Fuzzy matching programming techniques using sas software. Lafler, kirk paul 2006, exploring dictionary tables with proc sql. About the authors kirk paul lafler is consultant and founder of software intelligence corporation and has been programming in sas since 1979. Citeseerx output delivery system tips and techniques. 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. Downloading, configuring, and using the free sas university. 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 is consultant and founder of software intelligence corporation and has been programming in 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. The software bundle includes base sas, sasstat, sasiml, designer studio.
He is a sas certified professional, sas institute alliance. 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 is a sas application developer, programmer, certified. Software intelligence see the truth, be a software genius, and deliver super software. 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. Hundreds of companies rely on cast software intelligence to improve enduser satisfaction and timeto. Kirk paul lafler is an entrepreneur, consultant, and founder at software intelligence corporation, and has been using sas since 1979. 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, 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. He is a sas certified professional, provider of it consulting services, trainer to sas users around the world, and emeritus. Kirk lafler, consultant and founder of software intelligence corporation, has been a sas user since 1979.
American engineer, programmer, author, entrepreneur, consultant, and founder of software intelligence. Kirk paul lafler is an entrepreneur, founder, and consultant at software intelligence corporation and has worked with sas software since 1979. Custom reporting with proc report and ods excel handson presented. Since 1979, kirk has served as a sas consultant and specialist, certified professional, application and tool developer, programmer, data analyst, educator, and author. Software intelligence corporation, spring valley, ca, usa. Kirk paul lafler, software intelligence corporation abstract in an age of internet frenzy, output delivery is experiencing incredible interest around the globe. 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. 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. 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.
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 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. Sas users are always interested in learning techniques that will help them improve the performance of table lookup, search, and sort operations. Tune your sas system for max performance sas users groups. Five little known, but highly valuable, proc sql programming techniques a presentation by kirk paul lafler. Kirk paul lafler is an entrepreneur, founder and lifelong sas learner at software intelligence corporation. He has worked with sas software since 1979 as a consultant, application designer and developer, programmer, sas solutions provider, data analyst, educator, and author. A handson introduction to sas hash programming techniques. 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. An american engineer, programmer, entrepreneur, consultant and founder of software intelligence. To do so would require maintaining several duplicate copies of the same values and could threaten the integrity of the data. Kirk paul lafler, software intelligence corporation abstract.
362 1461 1553 569 225 373 56 1256 1086 1272 1260 124 307 703 996 878 102 567 654 256 811 892 1268 749 766 430 2 292 205 1305 594 390 783 1004 865 16 1126 367 1404 450 1151 115 834 661 1249 757 716 329 920 963