On discussion forums, I often see questions that ask how to Winsorize variables in SAS. For example, here are some typical questions from the SAS Support Community: I want an efficient way of replacing (upper) extreme values with (95th) percentile. I have a data set with around 600 variables and
Colors are the subject of many romantic poems and songs, but there isn't much romance to be found in their hexadecimal values. With apologies to Van Morrison: ...Skipping and a jumping In the misty morning fog with Our hearts a thumpin' and you My cx662F14 eyed girl When it comes
Doing business in a global economy, have you ever found yourself wanting to show Chinese (or Korean, or Japanese) labels on a map? If so, then this blog is for you! Before we get started, here is a photo of some Chinese characters to get you into the mood. This
The last time I wrote a blog about teen dating, I shared that my colleague, Lisa Allred, and I were learning new terms from the teens in our lives. One was “ship”. Of course, the funny part was that although Lisa got the concept correct, she mis-remembered the actual term.
On any inauguration day in our country’s history people probably found themselves in one of three categories: happy & hopeful, disappointed & apprehensive, or apathetic & checked-out. Change is difficult, whether you perceive it as positive or negative. This blog is not to share which category I fall into but
The financial sector has always been subjected to regulatory compliance laws and directives. Consumers, lawmakers and politicians would expect no less. But it's fair to say that the financial sector has witnessed a "hockey stick" trend regarding new regulations in recent years.
Suppose you create a scatter plot in SAS with PROC SGPLOT. What color does PROC SGPLOT use for the markers? If you specify the GROUP= option so that markers are colored by a grouping variable, what colors are used to represent the various groups? The following scatter plot shows the
Back in 2013, I wrote a paper for the SAS Global Forum, reviewing the attributes that go towards making a good graph. In this paper, I covered many recommendations from industry thought leaders that can help enhance the effectiveness of graphs to deliver the intended information. One of the aspects that
Last night I dropped a check into my son’s school’s American Heart Association Fund Raiser and this morning we kicked off #NationalWearRedDay at the RFC with our annual Wear RED for Heart Health Breakfast Run. What’s the deal with all heart health awareness this month? Heart Disease Not only is it
Experience design is not just like a standard advertising campaign or an online app, but rather a strategy to keep customers engaged with a brand through impactful interactions. It means that every product and service is designed to offer a delightful experience; the packaging, mobile app, web and print ads
Having addressed the adaptability and power of an analytics environment in my last two posts, I thought I'd close out this mini-series of blogs by providing the business and technology implications of three attributes that need to define any truly open and unified analytics environment: Cohesion Business: The platform enables
I will begin with a short story. Like many employers, McDougall Scientific, my employer, requires its employees to review, with their co-workers and managers, what they learned at a conference or course. They are also asked to suggest applications of their learnings so that McDougall might realize value from the
As early as in 2009, Gartner predicted that Social Network Analysis (SNA) could be an important tool for detecting business patterns or disruptions and a source of new unprecedented insights for organisations. Today, SNA-based tools, as components of advanced analytic platforms (including predictive platforms), become indispensable for defining long-term strategies and managing
It was just a few years ago that the idea of an Internet of Things (IoT) seemed far off, something out of a science-fiction movie. After all, why would a vehicle need to talk to the road? Why would our utility meters need to talk to the central office? The
Strengthens arms, shoulders, back, core and quadriceps Four-Limbed Staff Pose (Sanskrit: Chaturanga Dandasana) Start on hands and knees and then move into Plank. Wrists are under shoulders and you’re engaging quadriceps and pressing through heels as if you’re stepping on the floor. Core is engaged and drawing in towards spine.
To make it easy to identify non-value adding areas, you can build a simple application using SAS® Visual Analytics software. Such an application lets you point and click your way through the organization’s forecasting hierarchy, and at each point view performance of the Naïve, Manual, Statistical, and Automated forecasts (or
.@philsimon says that, once again, there's quite a bit to learn from Amazon.
Achieving GDPR compliance is impossible without Data Management and Data Governance. That's a bold statement but it is borne out by any in-depth examination of the tasks necessary to achieve compliance. Let's take a look at a few of the things that regulators require when interacting with organizations around personal
Looking for ways to add some variability to your routine? Try these row options. You can choose one or all as you focus on your back while keeping your core engaged. The row incorporates almost every muscle involved in moving your shoulder and your elbow. It also relies on muscles of
In a previous article, I showed how to simulate data for a linear regression model with an arbitrary number of continuous explanatory variables. To keep the discussion simple, I simulated a single sample with N observations and p variables. However, to use Monte Carlo methods to approximate the sampling distribution
To properly evaluate (and improve) forecasting performance, we recommend our customers use a methodology called Forecast Value Added (FVA) analysis. FVA lets you identify forecasting process waste (activities that are failing to improve the forecast, or are even making it worse). The objective is to help the organization generate forecasts
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
I usually create very technical maps, to display data spatially - and they usually have a certain look. They're clear, crisp, and to the point. I typically only use color to represent the data, and I choose a font that is simple and easy to read (such as arial). But
Did you know that January is Human Trafficking Awareness Month in the United States? If not, you may not know that researchers estimate that human trafficking is a global industry with revenues from $51 to $99 billion annually, up from $32 billion just a few years ago. In this case,
You have all seen, or perhaps even created, some really bad graphics: Cluttered, confusing, too small, incomprehensible. Or worse, the author may have committed one of the three unforgivable sins of data visualization by deceptively distorting a map, truncating the axis so as to misrepresent the data, or used double
PROC SGPLOT writes a graph template and uses it to create a graph. You can edit the template and then create a modified graph.
Recently, SAS shipped the fourth maintenance of SAS 9.4. Building on this foundation, SAS Studio reached a new milestone, its 3.6 release. All editions have been upgraded, including Personal, Basic and Enterprise. In this blog post, I want to highlight the new features that have been introduced. In subsequent posts
If you are a SAS programmer and use the GROUP= option in PROC SGPLOT, you might have encountered a thorny issue: if you use a WHERE clause to omit certain observations, then the marker colors for groups might change from one plot to another. This happens because the marker colors
I’ve had several meetings lately on data management, and especially integration, where the ability to explore alternatives has been critical. And the findings from our internet of things (IoT) early adopters survey confirms that the ecosystem nature of data sources in IoT deployments means we need to expand the traditional
Preview of the Winter 2017 issue of Foresight Foresight begins the new year with our 44th issue since the journal began publishing in 2005, and in this Winter 2017 collection we’re showcasing a broad range of incisive and entertaining pieces. We’re looking at new research on the effectiveness of collaboration
