SAS Users

Data Management

Understand why managing your data is essential for analytics

Data Management

Clemens KnoblochJune 21, 2017 1

Writing your own functions in SAS Data Quality using Dataflux Data Management Studio

IT organizations today are constantly challenged to do more with less. Reusing data processing jobs and employing best practices in monitoring the health of your data are proven ways to improve the productivity of data professionals. Dataflux Data Management Studio is a component of both the SAS Data Quality and

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanApril 27, 2017 8

Automating the loading of multiple database tables into SAS tables

When developing SAS applications, you can feed database tables into your application by using the libname access engine either by directly referring a database table, or via SAS or database views that themselves refer to one or more of the database tables. More on Automation with SAS: Let SAS write

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanMarch 28, 2017 12

Changing variable type and variable length in SAS datasets

There is a well-known Russian saying that goes “Если нельзя, но очень хочется, то можно.” The English translation of it can span anywhere from “If you can’t, but want it badly, then you can” to “If you shouldn’t, but want it badly, then you should” to “If you may not,

English

Data Management

Mary Kathryn QueenMarch 8, 2017 0

Securing sensitive data using SAS Federation Server data masking

SAS® Federation Server provides a central, virtual environment for administering and securing access to your data. It also allows you to combine data from multiple sources without moving or copying the data. SAS Federation Server Manager, a web-based application, is used to administer SAS Federation Server(s). Data privacy is a

English

Data Management | Programming Tips

Mary Kathryn QueenNovember 30, 2016 0

Securing sensitive data using SAS Federation Server at the data source level

Data virtualization is an agile way to provide virtual views of data from multiple sources without moving the data. Think of data virtualization as an another arrow in your quiver in terms of how you approach combining data from different sources to augment your existing Extract, Transform and Load ETL batch

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanNovember 25, 2016 16

Modifying variable attributes in all datasets of a SAS library

Using the DATASETS procedure, we can easily modify SAS variable attributes such as name, format, informat and label: proc datasets library=libref; modify table_name; format var_name date9.; informat var_name mmddyy10.; label var_name = 'New label'; rename var_name = var_new_name; quit; We cannot, however, modify fixed variable attributes such as variable type

English

Data Management

Helmut PlinkeNovember 9, 2016 0

Using suggestion-based matching in SAS Data Quality

We all have challenges in getting an accurate and consistent view of our customers across multiple applications or sources of customer information. Suggestion-based matching is a technique found in SAS Data Quality to improve matching results for data that has arbitrary typos and incorrect spellings in it. The suggestion-based concept

English

Data Management

Clemens KnoblochNovember 1, 2016 0

Calling SAS Data Quality jobs from Python

With DataFlux Data Management 2.7, the major component of SAS Data Quality and other SAS Data Management solutions, every job has a REST API automatically created once moved to the Data Management Server. This is a great feature and enables us to easily call Data Management jobs from programming languages

English

Data Management | Programming Tips

Mary Kathryn QueenOctober 19, 2016 0

Using multiple SAS Quality Knowledge Base locales in a SAS Event Stream Processing compute window

In a previous blog post, I demonstrated combining the power of SAS Event Stream Processing (ESP) and the SAS Quality Knowledge Base (QKB), a key component of our SAS Data Quality offerings. In this post, I will expand on the topic and show how you can work with data from

English

Data Management

Helmut PlinkeAugust 30, 2016 0

Improve matching results with suggestion based matching in SAS Data Quality

Have you ever had problems matching data that has typographical errors in it? Because of the nature of arbitrary typos and incorrect spelled words a specific matching technique is required to tackle those cases. SAS Data Quality, with its traditional, in nature deterministic matching approach is by nature not best

English

Blogs

Blogs

Data Management