I've supplied dozens of custom tasks for SAS Enterprise Guide, but the Copy Files task is easily the most popular. The Copy Files task allows you to capture "file transfer" steps inside your process flow, so that you can automate any file upload and download operations between your PC and
.@philsimon says don't treat data self-service as a binary.
Who was the oldest person elected president of the United States? How about the youngest? Who was the oldest when he left office? Let's look at some data. Wikipedia has a page that presents a table of the presidents of the US by age. It lists the dates for which
Does it seem like there just aren't enough daylight hours to get things done these days? It might not be that you've got more to do - it might be that we actually have fewer daylight hours in the winter (here in the northern hemisphere). And since "seeing is believing,"
If you obtain data from web sites, social media, or other unstandardized data sources, you might not know the form of dates in the data. For example, the US Independence Day might be represented as "04JUL1776", "07/04/1776", "Jul 4, 1776", or "July 4, 1776." Fortunately, the ANYDTDTE informat makes it
Retail isn't an easy place to be these days. The environment is omnichannel and ever-changing. Competition is rising and retailers are struggling to understand how to best meet customers’ merchandise preferences. Fortunately, analytics are driving profitability and market share for smart retailers. Let’s take a look at the four hottest
We often talk about full customer data visibility and the need for a “golden record” that provides a 360-degree view of the customer to enhance our customer-facing processes. The rationale is that by accumulating all the data about a customer (or, for that matter, any entity of interest) from multiple sources, you
The Data For Good initiative is all about using data and analytics to improve the lives of citizens around the world – however most people wouldn’t immediately think about tax collection as a humanitarian effort. But that’s exactly how Courtney Kay-Decker, Executive Director of the Iowa Department of Revenue sees
In the US presidential election, each of the 50 states has a certain number of electoral votes, based on the population. Typically, most states cast all their electoral votes for the candidate who wins in their state (all or nothing). But states can split their electoral votes if they want
This article uses graphical techniques to visualize one of my favorite geometric objects: the surface of a three-dimensional torus. Along the way, this article demonstrates techniques that are useful for visualizing more mundane 3-D point clouds that arise in statistical data analysis. Define points on a torus A torus is
Anteriormente al hablar sobre la implementación de soluciones de business analytics en las empresas, se consideraba necesario invertir grandes cantidades de capital en hardware especializado para alcanzar los resultados deseados, sin embargo, hoy en día gracias a los avances tecnológicos ha sido posible acabar por completo con este inconveniente. La
Most enterprises employ multiple analytical models in their business intelligence applications and decision-making processes. These analytical models include descriptive analytics that help the organization understand what has happened and what is happening now, predictive analytics that determine the probability of what will happen next, and prescriptive analytics that focus on
Rotation matrices are used in computer graphics and in statistical analyses. A rotation matrix is especially easy to implement in a matrix language such as the SAS Interactive Matrix Language (SAS/IML). This article shows how to implement three-dimensional rotation matrices and use them to rotate a 3-D point cloud. Define
Elections in the US are a 'target rich environment' for data analysts. There are surveys and forecasts before the election, and the presentation of results during and after the voting. What's your favorite election-related graph of all time? For the current (2016) presidential election, my favorite graphs are on the
The digital age has fundamentally changed how brands and organisations interact with consumers. This shift has been a crucial part of the Third Industrial Revolution and helped spark the era of consumers sharing their data with different organisations. But now organisations are heralding the Fourth Industrial Revolution, and data is
My river walk last week turned into a spectacular fall show. But if it rains this week in San Antonio, like the weatherman predicts, what will I do? In the coming days, I’ll be presenting at two user groups, one in eastern Canada in Halifax, and the other all the
Electronic health records (EHRs) and the overall advancement of information technology have produced a tsunami of data that must be stored, managed and used. Some had naively hoped that EHRs would bring a simpler, more streamlined industry. Instead, we’re finding that the delivery and management of health care is more
Being an Eagle Scout, the data for good movement caught my attention. I wondered if I could apply my computer skills in a way that might help. How about showing people better ways to visualize HIV/AIDS data - that might help doctors better understand the data, and therefore better treat
Occasionally on a discussion forum, a statistical programmer will ask a question like the following: I am trying to fit a parametric distribution to my data. The sample has a long tail, so I have tried the lognormal, Weibull, and gamma distributions, but nothing seems to fit. Please help!! In
SAS Community member @tc (a.k.a. Ted Conway) has found a new toy: ODS Graphics. Using PROC SGPLOT and GTL (Graph Template Language), along with some creative data prep steps, Ted has created several fun examples that show off what you can do with a bit of creativity, some math knowledge,
Actualmente, a nivel mundial los deportes generan ganancias estratosféricas, desde las propias entradas a los eventos y/o torneos, los múltiples contratos televisivos, patrocinios, souvenirs, hasta las marcas de ropa y calzado deportivo que han hecho de esta vertical de negocio una de las más rentables en los últimos tiempos. La
.@philsimon says that even seemingly useless information can be useful under the right circumstances.
What would happen if we could ask any type of scientific or clinical question about patients, and then go out and find the data to answer our questions? With "real-world data," we can do just that. Real-world data is all medicinal product data that comes from real-life patients. In contrast,
Many people have the perception that data governance is all about policies and mandates, committees and paperwork, without any real "rubber on the road" impact. I want to dispel this viewpoint by sharing a simple example of how one company implemented data governance to enforce something practical that delivered long-term
Every year near Halloween I write an article in which I demonstrate a simple programming trick that is a real treat to use. This year's trick (which features the CMISS function and the crossproducts matrix in SAS/IML) enables you to count the number of observations that are missing for pairs
Halloween appears to be my favorite holiday, because I seem to have more graphs related to it than any of the others. And since Halloween is just a few days away, I thought you might like an easy way to see all those graphs. Here's are links to my previous Halloween-related blog
In my prior posts about operational data governance, I've suggested the need to embed data validation as an integral component of any data integration application. In my last post, we looked at an example of using a data quality audit report to ensure fidelity of the data integration processes for
I've been reflecting on my life and career recently and was amazed to discover that I just hit 30 years of working with industrial and manufacturing applications. While it’s a bit tough to admit my age, I’m quite happy with my career and have enjoyed manufacturing and industrial applications. I
Kennen Sie diese Situation? Sie sollen dringend eine komplexe Auswertung fertig stellen. Die Daten wurden zu spät geliefert und die Qualität und Struktur der Daten waren weit vom erwarteten Standard entfernt. Der Zeitdruck der Ergebnispräsentation ist groß, und Ihr SAS Programm tut immer noch nicht genau das, was Sie als
Aphorism 6: The Surest Way to Get a Better Forecast is to Make the Demand Forecastable Forecast accuracy is largely dependent on volatility of demand, and demand variation is affected by our own organizational policies and practices. So an underused yet highly effective solution to the forecasting problem can be
