About SAS Data Integration Studio
SAS Data Integration Studio is a tool that enables you to consolidate and manage enterprise data from a variety of source systems, applications, and technologies. This software enables you to create process flows that accomplish the following tasks:- extract, transform, and load data for use in data warehouses and data marts
- cleanse, migrate, synchronize, replicate, and promote data for applications and business services.
SAS Data Integration Environment
 |
| SAS Data Integration Environment |
Administrators use SAS Management Console to connect to a SAS Metadata Server. They enter metadata about servers, libraries, and other resources on your network and save this metadata to a repository.
Users connect to the same metadata server and register any additional libraries and tables that they need.Then, they create process flows that read source tables and create target tables in physical storage.
Practical approach to extract, transform and loading
Importing externals delimited files
I am having a data set with 5 tables and each table accomplished with different table names and different sizes. It is a external data set saved in .excel and .csv format. Here i am showing how to import externals delimited files and upon registering them into SAS Dataset.
Select delimited external file from external folder of source designer and click on next.Browse the external file from the server location into sas. specify the delimiters and other parameters for reading the external file.
Define the columns contained in the external file by importing it and skip the 1st row if your column names are written. specify the folder location of the data set in repository to finish it.
Hello Venkatnaveen,
ReplyDeleteYou have provided good basic info for SAS Data integration studio,
The way you have presented using diagrams is really helpful.Thanks for providing it