As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


SAS® Data Integration Studio Tips and Tricks

From sasCommunity
Jump to: navigation, search
Chris Olinger and David Kratz

d-Wise Technologies, Inc.

Raleigh, NC

Abstract

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 I want 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 tutorial will explore some of the work-arounds that we have come to rely on while using the application. We will also explore the latest version of SAS Data Integration Studio to see if any of our pet peeves have been fixed.

Online materials