Philadelphia SAS User Group Webinar with Jay Iyengar
Join the Philadelphia SAS User Group and Jay Iyengar for this one-hour webinar.
Jay will present two topics:
Look Up Not Down: Advanced Table Lookups in Base SAS
One of the most common data manipulation tasks SAS® programmers perform is combining tables through table lookups. In the SAS programmer’s toolkit many constructs are available for performing table lookups. Traditional methods for performing table lookups include conditional logic, match-merging and SQL joins. In this paper we concentrate on advanced table lookup methods such as formats, multiple SET statements, and HASH objects. We conceptually examine what advantages they provide the SAS programmer over basic methods. We also discuss and assess performance and efficiency considerations through practical examples.
Validate the Code, not just the Data. A system for SAS program validation
Regardless of the industry they work in, SAS® programmers are focused on validating data, and devote a considerable amount of attention to the quality of data, whether its raw source data, submitted SAS data sets, or SAS output, including figures and listings.
No less important is the validity of code and the SAS programs which extract, manipulate, and analyze data. Although code validity can be assessed through the SAS log, there other ways to produce metrics on code validity. This paper introduces a system for SAS program validation which produces useful information on lines of code, number of data steps, total run and CPU time and other metrics for project-related SAS programs.
Register today!
