TU11 Putting it Together (The Tutorial): A Data Set Joining Primer     Invited

Janet E. Stuelpner Citigroup ,Caroline Bahler
Meridian Software, Inc.
Abstract: The ability to combine different types of data from multiple hardware and software platforms is a major strength of the SAS system. SAS has blessed information analysts with a wealth of different options for joining data values from many different data str uctures. Therefore, an information analyst needs to determine who (parent data structures), what (“software environment”), where (“hardware environment”), how (the tools available to perform the join) and why (the required contents of the child data set) o f a join in order to determine which strategy to use, This paper will discuss the joining techniques offered within the SAS system and give examples of their use.

Biography:
Janet Stuelpner provides training and programming support in the areas of clinical trials, outcomes research and the financial industry. Janet has several degrees in the sciences. She has been a SAS user for over 21 years on many different platforms. Origi nally a systems programmer, she has now turned her focus to teaching DB2 SQL and SAS. She is a section chair at NESUG, a member of the HASUG steering committee and has been a presenter at users groups at all levels.

Caroline has over 20 years experience using SAS software under multiple operating systems and platforms. Her educational background includes a Ph.D. in Agronomy. She has presented at multiple SUGI and SESUG conferences on multiple SAS topics.