SAS Users

Data Management

Understand why managing your data is essential for analytics

Nicolas RobertJuly 25, 2016 1

Four ways to conduct a web search for business terms with SAS Business Data Network

SAS Business Data Network is SAS’ solution for managing glossaries of common business terms. This is part of the SAS Data Governance offering as well as bundled with Advanced versions of all SAS Data Management bundles. One thing that is important regarding Data Governance in general, and this solution in

English

Data Management | Programming Tips

Mary Kathryn QueenJuly 21, 2016 0

Using an alternate Quality Knowledge Base (QKB) in a DataFlux Data Management Studio data job

In DataFlux Data Management Studio, the predominate component of the SAS Data Quality bundle, the data quality nodes in a data job use definitions from something called the SAS Quality Knowledge Base (QKB). The QKB supports over 25 languages and provides a set of pre-built rules, definitions and reference data

English

Data Management | Programming Tips

Mary Kathryn QueenJune 3, 2016 1

Using Multiple Quality Knowledge Base Locales in a DataFlux Data Management Studio Data Job

In DataFlux Data Management Studio, the data quality nodes (e.g., Parsing, Standardization, and Match Codes) in a data job use definitions from the SAS Quality Knowledge Base (QKB). These definitions are based on a locale (Language and Country combination). Sometimes you would like to work with multi-locale data within the

English

Data Management | Programming Tips

Mary Kathryn QueenMay 13, 2016 0

Improving matching results in DataFlux Data Management Studio with cluster comparison

Trusted data is key to driving accurate reporting and analysis, and ultimately, making the right decision. SAS Data Quality and SAS Data Management are two offerings that help create a trusted, blended view of your data. Both contain DataFlux Data Management Studio, a key component in profiling, enriching monitoring, governing

English

Data Management | Programming Tips

Nicolas RobertMarch 7, 2016 2

Data Governance Series: Share DataFlux Data Quality profiling metrics in SAS Visual Analytics (Part 2)

In this post, I continue the journey of getting data profiling results into SAS Visual Analytics. In my first blog I described the process of collecting DataFlux Data Quality profiling metrics to load a datamart. Now we load this datamart into memory (LASR) and then plug a VA report on

English

Data Management | Programming Tips

Mary Kathryn QueenFebruary 17, 2016 2

DataFlux Data Management Server 2.7: REST APIs

REpresentational State Transfer (REST) is an architectural style for designing web services that access a system's resources using HTTP methods. With the release of DataFlux Data Management 2.7 earlier this year, three new REST Application Programming Interfaces (APIs) are now available: Data Management Server Batch Jobs Data Management Server Real-time

English

Data Management | Programming Tips

Nicolas RobertFebruary 11, 2016 2

Data Governance Series: Share DataFlux Data Quality profiling metrics in SAS Visual Analytics

This is my first blog post, and the first of a long series around Data Governance. The first thing I want to discuss is the ability to Share DataFlux Data Quality profiling metrics in SAS Visual Analytics. This post will illustrate how to extract profiling data from the DataFlux repository

English

Data Management | Programming Tips

Mary Kathryn QueenDecember 16, 2015 0

Matching Names: How to Avoid a Common Mistake

Sometimes when trying to fuzzy match names you want to fuzzy match just a portion of the name: for example, Family Name and/or Given Name. A common mistake that people make is to feed in the Family Name and Given Name columns separately into the Match Codes node instead of

English

Data Management | SAS Administrators

Charlotte CrainNovember 11, 2015 0

In-Database Nirvana – The Five Step Process to run business rules without moving data

The phrase “business rules” is often loosely used. It can refer to things like constraints in a query, a data mapping, a data quality constraint, a data transformation, or a model. Business rules also reflect an enforced policy, a regulatory requirement and business constraints on model scores that trigger analytically-driven

English

Data Management | Programming Tips

Stephen FoersterOctober 30, 2015 3

How to shrink LASR tables

Is your LASR implementation running short on memory? Since LASR tables are stored in memory, it can become scarce. So what can we do to minimize LASR table size and still get LASR’s legendary performance? Here are a few strategies on how to shrink LASR tables: Compression: When compression was

English

Blogs

Blogs

Data Management