As I discussed in the first two blogs of this series, metadata is useful in a variety of ways. Its importance starts at the source system, and continues through the data movement and transformation processes and into operations. Operational metadata, in particular, gives us information about the execution and completion
Yearly Archives: 2016
I am writing this post with the satisfaction of having Implementing CDISC Using SAS: An End-to-End Guide, Second Edition completed and on the shelf. Once again, it was my pleasure to collaborate with Chris Holland, and I am glad that we had a chance to update the book with current
Anteriormente, el sector empresarial se enfrentaba constantemente a la escases de información de aquello que ocurría en su compañía, tanto a nivel de procesos internos como de interacción con los clientes, siendo este último punto el más relevante por estar ligado la fidelización o desencanto de la marca. Sin embargo,
The title of this post borrows from Stanley Kubrick’s 1964 comedy “Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb.” It stars the great Peter Sellers as the titular character as well as George C. Scott and Slim Pickens. The black and white film is strange
Data governance seems to be the hottest topic at data-related conferences this year, and the question I get asked most often is, “where do we start?” Followed closely by how do we do it, what skills do we need, how do we convince the rest of the organisation to get
There has been a lot of speculation over the years about the quality of the optimization solvers in SAS/OR, in particular the mixed integer linear optimization (MILP) solver. Measuring the performance of optimization solvers and comparing different solvers on a test set is a crucial part of modern optimization solver development.
Let me make this clear right from the start: I needed to answer 44 of the 62 exam questions correctly to earn my BASE SAS Programmer certification, and I got exactly 44 right. No margin of error. I never thought I’d be proud of a 70%, but I’m more than
Displaying nicely rendered axis values reduces clutter and makes the graph more readable. With SAS 9.4, we added the ability for splitting x-axis tick values on white space to create a nice and readable x-axis as shown in the graph on the right. It is always a challenge to fit
In some applications, you need to optimize a linear objective function of many variables, subject to linear constraints. Solving this problem is called linear programming or linear optimization. This article shows two ways to solve linear programming problems in SAS: You can use the OPTMODEL procedure in SAS/OR software or
A multilabel format enables you to assign multiple labels to a value or a range of values. The capability to add multilabel formats was added to the FORMAT procedure in SAS® 8.2. You assign multiple labels by specifying the MULTILABEL option in the VALUE statement of PROC FORMAT. For example,
"Two weeks to go," Santa said to himself, with millions of toys stacked up on the shelves. Each year worry hit at the same time – "How do I get the right toy to the right child without losing my mind?" Though Old St. Nick didn't have a computer science degree, deep down
I recently met Mrs. Claus at the INFORMS Annual Meeting, where we got to talking about the social network analysis session she’d just attended. It turns out Mrs. Claus and I are both fans of a book by Alex Pentland, Social Physics: How Social Networks Can Make Us Smarter. Apparently
During a data quality assessment, one of my clients discovered that a large chunk of data that ultimately fed into their business analytics engine was sourced externally. After examining the contracts surrounding this data, I found that 100% of it failed to possess service-level agreements (SLAs) for the quality of
Ready for another (soon to be classic) fun, custom-made for IT holiday jingle?? Fire up the hot chocolate, gather around the water cooler and belt this one out at the upcoming office party: Have a holly, jolly smart grid It's about time we upgraded our electric infrastructure I don't know
Some observant readers may have noticed a new icon on the right sidebar of this blog announcing the release of the new SAS Press book on the ODS Graphics Designer, written in collaboration with Jeanette Bottitta. Jeanette is a Technical Writer at SAS and has worked on various SAS Graphics products
Imagine making $50K a day out of thin air. Did you know that NASDAQ routinely processes around 10,000,000 trades a day? What if instead of rounding cents for each transaction, market makers truncated fractions of cents in the amount they owe you? Under the assumption that each transaction, on average,
The financial crisis led to a deep reflection on the things that Banks and other financial institutions were doing wrong. The most significant factor that led to bad business decisions and in extend the results that we have all been experiencing the past few years, was uninformed analytics. This is
“Analytics” and “data scientist” aren’t new terms, but they are trending buzzwords. The popularity of these concepts has created a false impression: Analytics are mysterious abstractions that can only be decoded if you have a white lab coat and an advanced degree in computer science. The reality couldn’t be more different.
La intuición ya no es la mejor consejera a la hora de tomar importantes decisiones de negocio. Los empresarios de antes lanzaban un nuevo producto al mercado basados en su ‘olfato de negocios’; abrían un nuevo local después de contar manualmente cuántas personas transitaban por el frente del local; y
La intuición ya no es la mejor consejera a la hora de tomar importantes decisiones de negocio. Los empresarios de antes lanzaban un nuevo producto al mercado basados en su ‘olfato de negocios’; abrían un nuevo local después de contar manualmente cuántas personas transitaban por el frente del local; y
Karen, in unserem letzten Gespräch haben wir über die Bedeutung von professionellem Datenqualitäts-Management und über die erforderliche organisatorische Einbettung gesprochen. Jetzt möchte ich etwas konkreter werden. Beschreibe doch mal, worauf es bei der Umsetzung ankommt? Wie sollte sich ein solcher Data Governance Prozess gestalten?
Contar con un inventario eficiente, que se ajuste a las necesidades de los clientes y prevea las preferencias de compra que tienen los consumidores incluso en tiempo real, pareciera un desafío complejo de resolver, sin embargo, se trata de una oportunidad al alcance de las organizaciones. Un área clave en
Have you ever thought how many problems in your business can be solved through analytics? I bet you stumble on that thought at least once a month but I'm also confident that maybe you see the thing in different terms. Let me put it like that: have you ever noticed strange patterns
I was surprised to learn recently that despite the reams of laws and policies directing the protection of personally identifiable information (PII) across industries and government agencies, more than 50 million Medicare beneficiaries were issued cards with a Medicare Beneficiary Number that's based on their Social Security Number (SSN). That's
We want to extend a huge thank you to everyone who donated their leftover (and excess) Halloween candy this year, you outdid yourselves!! We tipped the scales right at 450 pounds of candy!
Out of the bosom of the Air, Out of the cloud-folds of her garments shaken, Over the woodlands brown and bare, Over the harvest-fields forsaken, Silent, and soft, and slow Descends the snow. "Snow-flakes" by Henry Wadsworth Longfellow Happy holidays to all my readers! In my last post I showed
Clinical research generates extensive amounts of data, yet most of it is siloed or generally unavailable to a larger pool of willing potential researchers. If this data were liberated to the masses, we would venture into a world of endless possibilities where the search for new cures and treatments could
Last week, I attended the IALP 2016 conference (20th International Conference on Asian Language Processing) in Taiwan. After the conference, each presenter received a u-disk with all accepted papers in PDF format. So when I got back to Beijing, I began going through the papers to extend my learning. Usually, when
Editor's note: Amanda Farnsworth is Head of Visual Journalism at BBC News and a featured speaker at SAS Global Forum 2017, April 2-5, 2017 in Orlando. My days are spent trying to put the best content we can in front of our loyal, heartland audience, while reaching out to others,
Die letzten Jahre zeigen deutlich, wie rasant das Datenaufkommen in den Unternehmen wächst. Laut einer Prognose von Statista wird das Volumen der jährlich generierten digitalen Datenmenge weltweit in den kommenden 5 Jahren um das 5-fache (in Exabyte) steigen. Dies stellt sowohl die IT als auch die Fachbereiche vor immense Herausforderungen.