I am obsessed with jigsaw puzzles. Specifically, 1000-piece mystery puzzles, entertaining not just for their pictorial humor, but also for the challenge. Unlike traditional puzzles, you don't know what you are putting together because the completed puzzle isn't pictured on the box. Mystery puzzles are constructed so that you must
Tag: data management
Recently, I worked on a cybersecurity project that entailed processing a staggering number of raw text files about web traffic. Millions of rows had to be read and parsed to extract variable values. The problem was complicated by the varying records composition. Each external raw file was a collection of
My New Year's resolution: “Unclutter your life” and I hope this post will help you do the same. Here I share with you a data preparation approach and SAS coding technique that will significantly simplify, unclutter and streamline your SAS programming life by using data templates. Dictionary.com defines template as
K(o)ennen Sie schon „DevOps“? Machen Sie SAS? Dann lohnt sich eventuell ein frischer Blick auf die Kombination! Denn immer mehr Unternehmen probieren, ihren produktiven Betrieb auch in die Hände der Software-Entwickler zu legen (2 von 3 laut Jenkins) – speziell in der Analyse, insbesondere beim agilen Modellieren und dem Veredeln
By now you’ve seen the headlines and the hype proclaiming data as the new oil. The well-meaning intent of these proclamations is to cast data in the role of primary economic driver for the 21st century, just as oil was for the 20th century. As analogies go, it’s not too
Data management gets lost in the enthusiasm around Artificial intelligence (AI) and machine learning (ML). Not surprising, when it's an algorithm that decides what search results to show you, guides the self-driving cars on the roads, and powers the anti-fraud bots that monitor every credit card transaction we make. Charles
This blog post outlines how to create your own CAS functions using the CAS Language. It also includes a partial list of both CASL built-in and common functions for reference.
SAS Technical Support has had several requests from customers who want to use SAS® software to help download their files from a website when there is no application programming interface (API) to do it. This post shows how to automate downloads using PROC HTTP and DATA step, and how to use the HTTP DEBUG statement.
Los objetivos que deben concretar los líderes de las áreas de negocio de una organización son tan variados como importantes: mejorar la experiencia de sus clientes, elevar la rentabilidad, reducir los costos al tiempo de hacer más eficiente la cadena de producción o cumplir con las regulaciones que rigen a
In my last article, we introduced SAS® Personal Data Compliance Manager and how the solution allows you to record processing activities for complying with GDPR Article 30. However, in certain situations these processing activities could require a Data Protection Impact Assessment (DPIA), also known as a Privacy Impact Assessment (PIA).
With SAS Data Preparation and SAS Decision Manager, you can perform out-of-the-box column and row transformations to increase your data quality and build the foundations for data-driven innovation. This blog will discuss how you can leverage SAS Decision Manager to enrich data when preparing it through SAS Data Preparation.
In the previous article of this series, Vincent Rejany explained why Personal Data Protection regulation are calling for better governance of data. Let’s talk now about one building block of these regulations for demonstrating accountability: the records of processing activities, and how SAS® Personal Data Compliance Manager allows to perform
La aserción de que los datos son nuevos para el cobra y, en especial, un nuevo escenario para el negocio y en el que la economía digital es imparable. Las organizaciones de todo el mundo están cada vez más conscientes de ello y están aprovechando al máximo las innovaciones tecnológicas
SAS Viya is our latest extension of the SAS Platform and interoperable with SAS® 9.4. There were a number of SAS Viya presentations at SAS Global Forum 2018. In this series, we will review several of the most interesting talks. This post reviews Hadley Christoffels’ talk, A Need For Speed: Loading Data via the Cloud.
We all are now learning to live with the EU’s General Data Protection Regulation. It has often been viewed as a challenge and a requirement, a box that needs to be ticked before everyone can get on with doing their day jobs again. Recently, however, I have noticed a slight change
Lately, the media has again been focusing on the debate about how we can do more for society's vulnerable groups, including children. This is an important debate and an area that we at SAS already have much experience with: when you apply analytics to the right data, something important happens.
The European Union’s General Data Protection Regulation (GDPR) taking effect on 25 May 2018 pertains not only to organizations located within the EU; it applies to all companies processing and holding the personal data of data subjects residing in the European Union, regardless of the company’s location. Here are four selected SAS tools for GDPR that allow you to protect personal data in SAS reports by suppressing counts in small demographic group reports.
Aunque el término Big Data lleva solo 20 años de uso a nivel mundial, SAS ya tiene más de cuatro décadas inspirando lo extraordinario, un reto que muchas compañías y empleados ya han asumido, incorporando soluciones de analítica en procesos tan increíbles como la exploración del sol, la protección del
The release of SAS Viya 3.3 has brought some nice data quality features. In addition to the visual applications like Data Studio or Data Explorer that are part of the Data Preparation offering, one can leverage data quality capabilities from a programming perspective. Here is an overview of SAS Data Quality 3.3 programming capabilities.
In May of 2016, I expressed my personal excitement for the release of SAS 360 Discover to the SAS platform, and the subject of predictive marketing analytics. Since then, I have worked with brands across industries like sports, non-profits, and financial services to learn about valuable use cases. Before diving
Having been involved in some capacity in more than 100 Customer Intelligence (CI) sales and implementation cycles, one of the most common questions perspective clients ask me is: “What do we need to do to make this project successful?” Over the years, I have distilled six themes that ultimately determine
This is a continuation of my previous blog post on SAS Data Studio and the Code transform. In this post, I will review some additional examples of using the Code transform in a SAS Data Studio data plan to help you prepare your data for analytic reports and/or models. Create
SAS Data Studio is a new application in SAS Viya 3.3 that provides a mechanism for performing simple, self-service data preparation tasks to prepare data for use in SAS Visual Analytics or other applications. It is accessed via the Prepare Data menu item or tile on SAS Home. Note: A
A restaurant cannot survive without customers. It does not matter how cutting-edge or delicious its food, or how many Michelin stars it has earned. The equation is simple: If it has no diners, there will be no income, and the restaurant will go out of business. This insight could be
Cuando usted viaja, va de compras o se hospeda en un hotel espera recibir un servicio de primera, un trato amable y que se cumpla lo que le han prometido. Es lo que exigimos de las empresas y organizaciones con las que tratamos: tener una experiencia que cumpla con nuestras
Much has been written about the value that North Carolina’s Criminal Justice Law Enforcement Automated Data Services (CJLEADS) system has brought the state’s court personnel and law enforcement officers. CJLEADS integrates dozens of NC criminal justice and law enforcement data sets, a vast improvement over the state’s legacy processes. Law
How many of us have already failed to unsubscribe to newsletters or other email solicitations? For sure the link is there at the bottom of these emails, but who knows what happens when asking for unsubscribing. Consent has been for years limited to one “Do not call/contact” flag at the
In a recent Q&A session, SAS Executive Vice President, Chief Operating Officer, Chief Technology Officer Oliver Schabenberger mentioned a thought-provoking concept. When learning (new) information, you should be able to convey it to three different people: a “newbie” (someone who has never heard of the information before), an expert (someone