Many programming tasks require merging time series of varying frequency. For instance you might have three datasets (YEAR, QTR, and MONTH) of data, each with eponymous frequency and sorted by common id and date variables. Producing a monthly file with the most recent quarterly and yearly data is a hierarchical last-observation-carried-forward (LOCF) task. Or you may have three irregular times series (ADMISSIONS, SERVICES, TESTRESULTS), in which you want to capture the latest data from each source at every date encountered (event-based LOCF). These are tasks often left poorly optimized by most SQL-based languages, in which row order is ignored in the interests of optimizing table manipulation.
This presentation shows how to use conditional SET statements in the SAS® DATA step to update specific portions of the program data vector (i.e. the YEAR variables or the QTR variables) to carry forward low frequency data to multiple subsequent high frequency records. A similar approach works just as well for carrying forward data from irregular time series. We’ll also show how to use “sentinel variables” as a means of controlling the maximum time-span data is carried forward, i.e. how to remove historical data that has become “stale.” Finally, we will demonstrate how to modify these techniques to carry future observations backward, without re-sorting data.
Presented by Mark Keintz
Mark Keintz has been using SAS® since it was documented in one book. His interests are largely in development of applications for financial research and education, addressed in several presentations at SAS Global Forums and various regional SAS user groups. Mark's primary SAS expertise is in DATA step programming, hash programming techniques, efficient use of large data sets, and macro programming.
REGISTER for this virtual event today.
Google® Search for SAS® Users - Kirk Paul Lafler
Google (www.google.com) is the world’s most popular and widely-used search engine. As the premier search tool on the Internet today, SAS® users frequently need to identify and locate SAS content wherever and in whatever form it resides. Topics include learning how Google search works by illustrating relevant search examples, tips, and techniques for finding content of interest, including examples, reference works, information tools, directories, PDFs, images, SAS communities and user groups announcements / examples / solutions, current news stories, and various techniques on how you can quickly and easily improve / optimize your Google searches to satisfy your every need.
Tutorial with examples Length: 50 minutes
Registration is not required. Simply join https://teams.microsoft.com/l/meetup-join/19%3ameeting_ZjBmZDI0OTgtMjQyYy00MTkzLWIxYzQtMzVhNWZhY2VkODFi%40thread.v2/0?context=%7b%22Tid%22%3a%22b1c14d5c-3625-45b3-a430-9552373a0c2f%22%2c%22Oid%22%3a%22a0399228-6892-40c9-bca0-a81a60bcdfc2%22%7d at 10:30am on June 26.
Presenter Bio
Kirk Paul Lafler is a consultant, developer, programmer, educator, and data scientist; and teaches SAS Programming and Data Management in the Statistics Department at San Diego State University. Kirk also provides project-based consulting and programming services to client organizations in a variety of industries including healthcare, life sciences, and business; and teaches “virtual” and “live” SAS, SQL, Python, Database Management Systems (DBMS) technologies (e.g., Oracle, SQL-Server, Teradata, MySQL, MongoDB, PostgreSQL, AWS), Excel, R, cloud-based technologies as well as other software and tools. Currently, Kirk serves as the Western Users of SAS Software (WUSS) Executive Committee (EC) Open-Source Advocate and Coordinator and is actively involved with several proprietary and open-source software, DBMS, machine learning, cloud-computing user groups and conference committees. Kirk is the author of several books including the popular PROC SQL: Beyond the Basics Using SAS, Third Edition (SAS Press. 2019), along with other technical books and publications. He is also an Invited speaker, educator, keynote, and leader; and is the recipient of 28 “Best” contributed paper, hands-on workshop (HOW), and poster awards.
