Updated SAS® Data Management helps data scientists spend more time analyzing data, less time prepping it

Share Article

With SAS®, Town of Cary conserves water, saves money and improves customer experience

News Image

Emerging data sources and Internet of Things (IoT) initiatives have made the collection, cleansing, integration and analysis of data more challenging than ever. To help data scientists spend less time preparing data and more time discovering value in it, SAS® has updated its Data Management suite, including SAS Data Loader for Hadoop, SAS Federation Server and SAS Event Stream Processing.

“Data scientists and business analysts spend too much time cleaning and organizing data; they should be mining insights from it,” said Matthew Magne, Global Product Marketing Manager for Data Management at SAS. “These updates take the hassle out of data preparation, delivering faster access for organizations to the data they want, when and how they want it.”

The Town of Cary, N.C., uses SAS to integrate data from multiple sources, including its IoT-based water-conservation project Aquastar. By monitoring water usage by Cary residents, Aquastar can save resources and dollars. If the system detects abnormally high water usage, which can indicate a problem with an appliance or faucet, Aquastar immediately alerts the homeowner.

“The integration capabilities of SAS Data Integration Studio and SAS Data Management provide the needed infrastructure to rapidly analyze the data for our Internet of Things-based water meter initiative,” said Town of Cary Business Analyst Janelle Bailey. “We use SAS to blend data from different sources for a holistic view across multiple silos. As a result, we create triggers to identify higher-than-expected water usage which helps us to reduce cost, conserve water and improve the citizen experience.”

Updates to the SAS Data Management Suite span data cleansing, preparation, streaming and virtualization. They include:

  • SAS Data Loader for Hadoop can run data quality functions in-memory on Apache Spark; perform in-cluster merging of multiple tables and faster Cloudera Impala queries; and integrate with additional Hadoop distributions.
  • SAS Federation Server has improved security with dynamic data masking and better accuracy with on-demand data quality.
  • SAS Event Stream Processing has streamlined integration with YARN on Hadoop and Apache Camel, and increased accuracy with in-stream data quality and machine learning.
  • SAS/ACCESS® to Amazon Redshift helps organizations create and execute Amazon Redshift code from SAS with both implicit conversion of SAS queries to Amazon Redshift SQL and explicit pass-through support.

SAS Data Management is built on a data quality platform that helps organizations improve, integrate and govern data. To learn more, download the new whitepaper Modernizing Data Integration to Accommodate New Big Data and New Business Requirements: http://go.sas.com/pxc5f6

About SAS
SAS is the leader in analytics. Through innovative analytics, business intelligence and data management software and services, SAS helps customers at more than 80,000 sites make better decisions faster. Since 1976, SAS has been giving customers around the world THE POWER TO KNOW®.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are trademarks of their respective companies. Copyright © 2016 SAS Institute Inc. All rights reserved.

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Nicole Murphy
Visit website