The WHERE clause in SAS is a powerful mechanism for selecting observations as you read or write a data set. The WHERE clause supports many operators, including the IN operator, which enables you to compactly specify multiple conditions for a categorical variable. A common use of the IN operator is
Have you ever been involved in executing an exploratory analysis based on an integrated clinical trial database? If so, you've probably experienced firsthand how elaborate the initial phase of data access and data processing can be. Market analysts estimate the ratio for preparing the data, compared to actually analyzing the information,
When you were growing up, did you ever imagine that the most popular show on TV would be 24-hour coverage of a storm?!? Yes, for better or for worse, the weather has become our new reality TV. And as you watch the weather coverage, you probably see all the weather reporters showing the
Data governance has been the topic of many of the recent posts here on the Data Roundtable. And rightfully so, since data governance plays such an integral role in the success of many enterprise information initiatives – such as data quality, master data management and analytics. These posts can help you prepare for discussing
Machine learning is taking a significant role in many big data initiatives today. Large retailers and consumer packaged goods (CPG) companies are using machine learning combined with predictive analytics to help them enhance consumer engagement and create more accurate demand forecasts as they expand into new sales channels like the
Are you happy with the ROI on your analytics investments? Recently we’ve seen an upswing in organisations investing in analytical platform capabilities. One can assume the goal of these investments is to turn transactional data into a strategic asset. However, analytics alone will not do it. Unless your organisation is
Real world data collected in a functioning health care setting instead of a controlled clinical environment can provide opportunities for new and deeper insights across life science and health care organizations. However, managing, analyzing and extracting actionable information from the varied available sources can present unique challenges. The sheer size of these
Dies ist der zweite Teil der Blog-Serie zu Big Data Governance. Beginnen Sie vorher am besten mit „Teil 1: Wie Big Data Unternehmen durcheinanderwirbelt”, wenn sie ihn noch nicht gelesen haben.
Energy suppliers are fighting for prime position in the domestic energy supply market. Disillusioned customers, increased competition due to a flood of new entrants and tighter regulations are forcing suppliers to reassess their business models. According to UK regulator Ofgem, there were 3.8 million account switches in the first six
Lately, the definitions of data governance and data management look very much alike. In this two-part series, we'll define data governance and data management. And we'll see that there's a big difference in the two.
What is weighted regression? How does it differ from ordinary (unweighted) regression? This article describes how to compute and score weighted regression models. Visualize a weighted regression Technically, an "unweighted" regression should be called an "equally weighted " regression since each ordinary least squares (OLS) regression weights each observation equally.
While men still outnumber women in the analytics field, there are plenty of opportunities available for women. At a recent Chief Data and Analytics forum, I was encouraged to see a well-balanced number of senior executives presenting about the business of analytics. Speakers included 12 women and 14 men, which indicates a
Like many words, if you just say "Cat 5" different people might think you're talking about different things. Computer geeks might assume you're talking about category 5 network cabling. But around this time of the year, most people in the southeast US will probably assume you're talking about a category
.@philsimon asks, Rather than trying to tackle a new form of governance, wouldn't your organization do better to shore up its existing data-governance practices?
The recent releases of SAS 9.4 have featured major enhancements to the ODS statistical graphics procedures such as PROC SGPLOT. In fact, PROC SGPLOT (and the underlying Graph Template Language (GTL)) are so versatile and powerful that you might forget to consider whether you can create a graph automatically by
With today’s customers able to access rich sources of product and service information – especially pricing data – when they are mobile, retailers are being forced to innovate in the way they capture consumers’ attention. Unfortunately, attention spans are rapidly decreasing to just the few seconds that a user spends
Jared Cohen, President of Jigsaw, formerly Google Ideas, and Chief Advisor to Alphabet Executive Chairman (former Google CEO) Eric Schmidt, presented a very interesting keynote at Analytics Experience this month. In it he mentioned the idea of a ‘digital self’. He explained most people have not one but numerous digital
At SAS, we use terms like “machine learning,” “predictive modeling” and, of course, “analytics” quite a bit in our day-to-day business. Not surprising, given that we're the largest analytical software vendor out there. But have you noticed that these terms are popping up more frequently in news articles and blogs?
Start with the end in mind -- wise words that apply to everything, and in the world of big data it means we have to change the way we look at managing the data we have. There was a time when we managed data quality, and the main goal was
We've witnessed a significant rise in data governance adoption in recent years. Careers, technology, education, frameworks, practitioners – there's growth in all aspects of the discipline. Regulatory compliance across many sectors is a typical driver for data governance. But I also believe one of the main reasons is the realisation by
Similar to hunting for Mewtwo (Pokémon), identifying and recruiting talented data scientists is just as elusive. CIMB decided that the best way would be to bring budding data scientist together for a challenge. This will provide candidates the opportunity to win cash prizes along with potential employment with CIMB’s Decision
SAS Programming Professionals, SAS & bugs & rock & roll? But, of course! SAS Because of its amazing versatility, SAS is indisputably the greatest software package currently in use anywhere within the Milky Way Galaxy. Can SAS input every type of flat file imaginable? Yes! Can SAS read and write
With the first debate between the two candidates behind us and the culmination of the US presidential election drawing near, who wouldn’t love to predict the winner? I don't have a crystal ball, but I do have the power of unstructured text analytics at my fingertips. With the help of
Last week I showed how to find the nearest neighbors for a set of d-dimensional points. A SAS user wrote to ask whether something similar could be done when you have two distinct groups of points and you want to find the elements in the second group that are closest
“Every morning in Africa, a gazelle wakes up. It knows it must run faster than the fastest lion, or it will be killed. Every morning a lion wakes up. It knows it must outrun the slowest gazelle, or it will starve to death. It doesn't matter whether you are a
I recently read a very interesting article describing how analytics is being used to detect cheating/copying/re-use in crossword puzzle creation, in some of the major news publications. This inspired me to try my hand at creating a totally new & unique crossword puzzle ... of course using SAS software! :) My grandmother
NIJ's Real-Time Forecasting Challenge If you want to show off your forecasting chops, and maybe even make a little money, the National Institute of Justice has just the challenge for you. The NIJ's Real-Time Crime Forecasting Challenge: ...seeks to harness the advances in data science to address the challenges of
Just in time for the Strata + Hadoop World Conference, SAS became the first software vendor to achieve ODPi Interoperability with our Base SAS® and SAS/ACCESS® Interface to Hadoop products. Now, that's a lot to digest – so let me back up a second and give some background as to what this
Recently, I was talking to a director of analytics from a large telecommunications company, and I asked her, “Do you think we have a skills shortage?” She replied, “NO, I think we’re just looking in the wrong place.” I wanted to hear more as this analytics expert may have just
Are you ready to expand your programming skills and become a more versatile programmer? Then this new (and free!) course might be for you. SAS Programming for R Users is a free course aimed at helping R programmers who want to learn SAS. The goal is for you to be comfortable accomplishing
