In my first post, I talked about the hell of using Excel for all your data needs; in my second post, I covered the building blocks and initial first steps that will lead you to a future proof data strategy. Now let’s zoom in on the three domains that underpin
Yearly Archives: 2015
Recently a user posted a query on the SAS Communities page asking on how to create a histogram where the bins of the histogram are colored by the analysis variable using a three color ramp. Essentially, he wanted the bins to be colored from "Low" to "High" along the horizontal
Government organizations are seeking new and innovative ways to use an abundance of data – both internally for government operations and externally to provide the public with greater access to information. This intersection of open and internal government data is the topic of a Route Fifty webinar taking place on
There is no doubt about it – over the past few years there has been a monumental shift in how we think about “enterprise” data management. I believe this shift has been motivated by four factors: Open data. What may have been triggered by demands for governmental transparency and the need
Imagine your company's analytics environment is like an old apartment building, with each unit having its own air conditioner. Each air conditioning unit has to be individually maintained and repaired by the building landlord or "super." The air conditioning units come from different manufactures and are of varying ages. It can be challenging, to
When creating a statistical graphic such as a line plot or a scatter plot, it is sometimes important to preserve the aspect ratio of the data. For example, if the ranges of the X and Y variables are equal, it can be useful to display the data in a square
Cary, North Carolina, Dezember 1997: Das war die Geburtsstunde des SAS® Enterprise Miner™ (nachfolgend Miner genannt). Nur zur Orientierung für die Generation Y: Damals war noch ein Mann Bundeskanzler. Er hatte einen recht hohen BMI, wurde gerne mit einer Obstart verglichen und kam aus einem Ort gar nicht weit weg
Times have changed. As the oil industry shutters and sheds investments that made sense during the two-year period in which oil rode comfortably above $90, the market is establishing a new equilibrium at $40/barrel. This despite the fact that the Baker Hughes domestic rig count is down 64 percent. It’s
“(Teaching) is an incredible opportunity to be a catalyst for what we want the future to be," says Shannon Hardy, a 21-year math and science teacher from The Exploris School, a Wake County charter school in Raleigh, NC. Ms. Hardy uses data not just as a summative measurement tool, but
Aussagefähige, geschäftsrelevante Datenanalysen auf Knopfdruck – davon träumen viele Unternehmen. Leider sieht die Realität gegenwärtig oft anders aus. Um aus der Flut Ihrer Unternehmensdaten nutzbare Ergebnisse zu ziehen, brauchen Sie zweierlei: gute Analysewerkzeuge und kompetente Mitarbeiter.
One of the frustrating outcomes of the data import process is when a variable that you need to be numeric is imported as character. This often happens because the column of data contains non-numeric data, for example, where blanks in a database are exported as “NULL” instead of a true
A matrix is a convenient way to store an array of numbers. However, often you need to extract certain elements from a matrix. The SAS/IML language supports two ways to extract elements: by using subscripts or by using indices. Use subscripts when you are extracting a rectangular portion of a
You could argue that it’s misguided for someone like me to say data science doesn't have to be difficult. After all, I’ve been in the industry for many years and should have a few tricks up my sleeve for dealing with data. But with the latest data visualisation technology –
As consumers have moved to digital channels and digital interactions, competition for the hotel consumer has increased dramatically. Now, hotels not only compete with each other, but also with third-party online distributors, and even new disruptors from the sharing economy like AirBnB. However, hotels have one advantage that these other
Unos 30 mil millones de dispositivos estarán conectados al Internet de las Cosas para el 2020*. También se estima que para finales de 2015, el mercado de dispositivos con capacidad de conectarse a internet a través de protocolo IP, crecerá unos 6 mil millones de dólares. Estas cifras impresionan. Sin
SAS Global Users Group and SAS have a history of giving back to the community where the conference is held. We think giving back is important. Conference attendees have played a big part in contributing to this effort every year. Over the years, the opportunities where attendees have been able
What happened to the adage, "What gets measured, gets done"? Though progress is being made, there are too many child protection agencies that have yet to understand the profound impact data-informed policy and practice have on performance outcomes, as well as staff retention and satisfaction. Without dipping deep into the
The ODS statement controls most aspects of how SAS creates your output results. You use it to specify the destination type (HTML, PDF, RTF, EXCEL or something else), as well as the details of those destinations: file paths, appearance styles, graphics behaviors, and more. The most common use pattern is
Kürzlich habe ich das Buch „Die Zahl die aus der Kälte kam“ des österreichischen Mathematikers Rudolf Taschner gelesen. Er versteht es meisterhaft, komplexe Zusammenhänge einer breiten Öffentlichkeit zu präsentieren. Eines seiner Beispiele behandelt die Macht der Hohepriester im alten Ägypten. Dabei ist mir folgendes klar geworden: Die Hohepriester im Alten
Entre una gran oferta de servicios televisivos, la competencia se torna cada vez más agresiva, y el mínimo descuido con el cliente puede significar una pérdida. Cada vez el análisis debe ser más meticuloso. Adicional al análisis de la competencia, de las preferencias del televidente, las empresas deben evitar lagunas
Sometimes you are writing a program that needs to find out whether a particular SAS product (like SAS/ETS, SAS/QC, or SAS/OR) is licensed. I was reminded of this fact when I wrote last week's blog post about how to create a map with PROC SGPLOT. Although the SGPLOT procedure is
Many readers in applied areas (business, health, psychology & sociology, education, and several others) are reading statistics texts under duress for a course or project, and are in truth somewhere between disinterested and terrified. In my new SAS Press book Business Statistics Made Easy in SAS® I knew that I
“Der hat doch´n Vogel – was für ein Freak” hab ich damals im Bio-Unterricht gedacht, als unser Lehrer davon erzählte, dass er sich im Frühjahr und im Sommer gerne früh morgens auf die Pirsch legt und die Vögel im seinem Garten beobachtet. Mit Vogel-Voyeurismus allein war es aber nicht getan, nein mein Bio-Lehrer dokumentierte
If your graphics look a little on the fuzzy or blurry side, there are lots of ways to increase the resolution of your SAS graphics output. Let’s go over some of these methods. Before increasing the resolution of your graphics output, check to see what you are creating your graphics
In my previous post, I discussed some of the challenges and costs organizations face when they’re stuck in Excel hell with no real data strategy. Now that we’ve discussed the problem, let’s dive into the solution. Every organization needs a data strategy with these building blocks: Your top priority is
The holiday season is a festive time of the year. But it can also be a nail biter for retailers. Months of planning can be sidetracked by fickle consumers or aggressive pricing from competitors. Paying attention to even a little bit of data can work wonders. In October, SAS conducted
„Mein Name ist Dr. Richard Dump. Ich bin IT Verantwortlicher bei einem großen global agierenden Unternehmen. Unsere IT Strategie ist durch eine konsequente Cloud Ausrichtung in Bezug auf Hardware und Software durch internationale Provider (auch außerhalb der EU) gekennzeichnet. Dies beinhaltet ebenso die Verarbeitung von personenbezogenen Daten.
John Beale was one of the highest paid government employees. A 10-year veteran of the Environmental Protection Agency (EPA), Beale defrauded the Federal Government of nearly $1M in employment wages and fraudulent travel. Beale came under suspicion after it was noticed that the he was still being paid wages 19
I have written a new book on advanced ODS Graphics examples. It is available as a free PDF file on the web. It is in color, and all of the SAS code is available by double clicking a link at the beginning of each example. Advanced ODS Graphics Examples Update:
Here in the US, we've got the Thanksgiving holiday coming up soon. And the keystone of this holiday is a big dinner, with lots of traditional Thanksgiving foods. But where does all this food come from, and which farmers should we thank for which of the food items? I use SAS