PROC-X.com
An online (unofficial) SAS® journal – written by bloggers

Main menu

Skip to content
  • About
  • add your blog
  • Contact us
SAS

Impact Analysis – “Hawk Eyes” of SAS Data Integration Studio

by Harsh Gajjar • December 21, 2011 • Comments Off on Impact Analysis – “Hawk Eyes” of SAS Data Integration Studio

This post was kindly contributed by Business Intelligence Notes for SAS BI Users - go there to comment and to read the full post.

As we have observed majorly in large enterprises, particularly the Banking and Finance sectors, there is always a huge amount of data building up every day. Moreover, one cannot ignore the fact that every observation in the database is linked up or important in some or the other way. So if you need to make a change to a data table, you need to understand the impact of that decision on your downstream data and reports. Currently, I will be focusing on the chief enhancement of Impact Analysis in data integration.  Analyze your Data Impact Here, I am showing the application of Data Integration in enterprises and the advantage of Impact Analysis in SAS Data Integration (DI) Studio. SAS DI Studio offers the ability of creating jobs, which can be used to populate various tables and creation of analytical reports.  SAS DI Studio is an end-to-end solution in creation of the data warehouse.  SAS Data Integration Studio User’s Guide describes impact analysis like this: “Impact analysis identifies the tables, columns, jobs, and transformations that are affected by a change to a selected table or column. Reverse impact analysis identifies the tables, columns, jobs, and transformations that contribute to the content […]

This post was kindly contributed by Business Intelligence Notes for SAS BI Users - go there to comment and to read the full post.

Tags: Building Business Intelligence data Metadata SAS DI Studio

Post navigation

← Fat Fingers
Self-assessments for SAS training courses →

Popular Posts

  • SAS – Lowercase (lowcase) / Uppercase (upcase) / Proper Case (propcase)
  • How do I export from SAS to Excel files: Let me count the ways
  • How to Get Row Numbers in SAS Proc SQL (and DO NOT Use the Undocumented MONOTONIC Function)
  • How to convert the datetime character string to SAS datetime value? (ANYDTDTM and MDYAMPM formats)
  • Using SAS Enterprise Guide to run programs in batch
  • Clear the Results viewer in SAS 9.3

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com

Contributors

  • AFHood Group Blog » SAS
  • Avocet Solutions
  • BI Notes
  • Blogging about all things SAS
  • BusinessKen
  • Computing from Out in Left Field
  • Data Steps
  • Enterprise Software Doesn’t Have to Suck
  • Gregor Gorjanc (gg)
  • Heuristic Andrew
  • Jared Prins’ Blog – SAS
  • Ken's SAS tricks
  • Michael @ Scorpio
  • Musings From an Outlier: The SAS Users Blog
  • NOTE: Development With SAS
  • Numbermonger » SAS
  • Peer Revue
  • Peter Flom blog (Statistical Analysis Consulting)
  • platformadmin.com
  • ProcRun;
  • SAS – BioStatMatt
  • SAS – Confounded by Confounding
  • SAS – From a Logical Point of View
  • SAS & Statistics
  • SAS | r4stats.com
  • SAS and R
  • SAS Learning Post
  • SAS Live!
  • Sas on Melinda Higgins, Ph.D
  • SAS Programming for Data Mining
  • SAS support site – SAS Users
  • SAS Users
  • SAS-BI Business Layers
  • SASopedia
  • SASTechies
  • Software & Service
  • Statistical Analysis Consulting
  • StudySAS Blog
  • The SAS Dummy

Recent Posts

  • SAS training: 5 free sessions technologists love
  • Creating a Microsoft Excel report using SAS, Python and SQL!
  • Decode your SAS® macro code with the MFILE and MPRINT options
  • ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya
  • CAS-Action! Advanced Frequency Tables – Part 4
  • CAS-Action! Grouping Frequency Tables – Part 3
  • Using SAS to score a test
  • CAS-Action! Saving Frequency Tables – Part 2
  • CAS-Action! Simple Frequency Tables – Part 1
  • CAS-Action! Rename Columns in a CAS Table
  • Details, details: Updates to The Little SAS Book
  • SAS administrator tip: How to identify and prevent duplicate librefs in SAS metadata
  • Building an Open Source Software Community
  • Unexpected results from missing values with PROC SQL
  • Machine learning models for payment fraud

Copyright © 2022 PROC-X.com. All Rights Reserved. The Magazine Basic Theme by bavotasan.com.