Thursday, 5 July 2012

Base SAS Vs SAS Data Integration Studio

BASE SAS
SAS DATA INTEGRATION STUDIO
Source data Adaptors, SAS can access just about any known data source through their native access engines and open standards approaches.
The same functionality is surfaced in SAS Data Integration Studio through metadata.
Base SAS has conditional logic support (if-then-else), so you can’t act on whatever observations or columns you wish.
Data Integration Studio Has a built in extract transformation
We have a tremendous amount of functionality at our disposal for doing the matching and retention of good values.
We have standard transformations as well as ability to create customer transformations that can be drooped onto the process editor.
We define surrogate key and simply increment the values each time a new record is added.
There is a surrogate key generator that will handle the creation of a new key for you when you load the table.

No comments:

Post a Comment