SAS Data Integration Studio Tips and Tricks

Anyone who has used SAS Data Integration Studio to process and transform data has invariably said to themselves "Is there another way to do the things that the author wants to do?" SAS Data Integration Studio is great at certain tasks such as standard transformations, visual representations of code, and impact analysis. However, it can be tricky to perform some industry standard tasks such as writing jobs that can be promoted and configured through external options files, loading metadata from non-supported external sources (such as Excel), and managing macros. This paper will explore some of the work-arounds that the author has come to rely on while using the application.