August 13, 2014 Workshop and Presentations
Workshop:
Cleaning, Validating, and Reshaping Your Data: Taking Advantage of SAS Tools
Art Carpenter, CALOXY
The procedures of SAS along with the DATA step provide the programmer and data analyst access to flexible
programming power unavailable in any other programming language. Along with that power comes the complexity of
multiple solutions to many common programming tasks. This class covers a number of Intermediate and Advanced SAS
programming topics that offer solutions that take advantage of techniques that are not employed by a majority of SAS
programmers. Based on Art's latest book, Carpenter's Guide to Innovative SAS Techniques, published in the spring of
2012, this course will extend the knowledge and tool set of SAS programmers that work with data.
Cleaning, Validating, and Reshaping Your Data: Taking Advantage of SAS Tools
Art Carpenter, CALOXY
The procedures of SAS along with the DATA step provide the programmer and data analyst access to flexible
programming power unavailable in any other programming language. Along with that power comes the complexity of
multiple solutions to many common programming tasks. This class covers a number of Intermediate and Advanced SAS
programming topics that offer solutions that take advantage of techniques that are not employed by a majority of SAS
programmers. Based on Art's latest book, Carpenter's Guide to Innovative SAS Techniques, published in the spring of
2012, this course will extend the knowledge and tool set of SAS programmers that work with data.
Featured Presentation:
SAS® Debugging 101
Kirk Paul Lafler, Software Intelligence Corporation
SAS® users are almost always surprised to discover their programs contain bugs. In fact, when asked, users will
emphatically stand by their programs and logic by saying they are bug-free. But, the vast number of experiences along
with the realities of writing code says otherwise. Bugs in software can appear anywhere, whether accidentally built into
the software by developers or introduced by programmers when writing code. No matter where the origins of bugs occur,
the one thing that all SAS users know is that debugging SAS program errors and warnings can be a daunting, and
humbling, task. This presentation explores the world of SAS bugs, providing essential information about the types of
bugs, how bugs are created, the symptoms of bugs, and how to locate bugs. Attendees learn how to apply effective
techniques to better understand, identify, and repair bugs and enable program code to work as intended.
SAS® Debugging 101
Kirk Paul Lafler, Software Intelligence Corporation
SAS® users are almost always surprised to discover their programs contain bugs. In fact, when asked, users will
emphatically stand by their programs and logic by saying they are bug-free. But, the vast number of experiences along
with the realities of writing code says otherwise. Bugs in software can appear anywhere, whether accidentally built into
the software by developers or introduced by programmers when writing code. No matter where the origins of bugs occur,
the one thing that all SAS users know is that debugging SAS program errors and warnings can be a daunting, and
humbling, task. This presentation explores the world of SAS bugs, providing essential information about the types of
bugs, how bugs are created, the symptoms of bugs, and how to locate bugs. Attendees learn how to apply effective
techniques to better understand, identify, and repair bugs and enable program code to work as intended.
| sas_debugging_101_sands_2014.pdf |
Short Talk:
Table Lookup Techniques: From the Basics to the Innovative
Art Carpenter, CALOXYOne of the more commonly needed operations within SAS® programming is to determine the value of one variable based on the
value of another. A series of techniques and tools have evolved over the years to make the matching of these values go faster,
smoother, and easier. A majority of these techniques require operations such as sorting, searching, and comparing. As it turns out,
these types of techniques are some of the more computationally intensive, and consequently an understanding of the operations
involved and a careful selection of the specific technique can often save the user a substantial amount of computing resources.
Many of the more advanced techniques can require substantially fewer resources. It is incumbent on the user to have a broad
understanding of the issues involved and a more detailed understanding of the solutions available. Even if you do not currently have
a BIG data problem, you should at the very least have a basic knowledge of the kinds of techniques that are available for your use.
Note: Due to time constraints, only the introduction to the topic will be presented. The paper can be found at
http://www.sascommunity.org/wiki/Table_Lookup_Techniques:_From_the_Basics_to_the_Innovative.
Table Lookup Techniques: From the Basics to the Innovative
Art Carpenter, CALOXYOne of the more commonly needed operations within SAS® programming is to determine the value of one variable based on the
value of another. A series of techniques and tools have evolved over the years to make the matching of these values go faster,
smoother, and easier. A majority of these techniques require operations such as sorting, searching, and comparing. As it turns out,
these types of techniques are some of the more computationally intensive, and consequently an understanding of the operations
involved and a careful selection of the specific technique can often save the user a substantial amount of computing resources.
Many of the more advanced techniques can require substantially fewer resources. It is incumbent on the user to have a broad
understanding of the issues involved and a more detailed understanding of the solutions available. Even if you do not currently have
a BIG data problem, you should at the very least have a basic knowledge of the kinds of techniques that are available for your use.
Note: Due to time constraints, only the introduction to the topic will be presented. The paper can be found at
http://www.sascommunity.org/wiki/Table_Lookup_Techniques:_From_the_Basics_to_the_Innovative.
