When using conventional methods to access and analyze data sets from Teradata tables, SAS brings all the rows from a Teradata table to SAS Workspace Server. As the number of rows in the table grows over time, it adds to the network latency to fetch the data from a database
Your statistical software probably provides a function that computes quantiles of common probability distributions such as the normal, exponential, and beta distributions. Because there are infinitely many probability distributions, you might encounter a distribution for which a built-in quantile function is not implemented. No problem! This article shows how to
It is not laziness—it is efficiency!!! Programmers are often called lazy; we even call ourselves lazy. But we are not lazy, we are just being efficient. It makes no sense to type the same code over and over again or use more keystrokes than are absolutely necessary. Keyboard Macros You
The consumer packaged goods (CPG) and Retail industry are going through a period of significant change. Both retailers and manufacturers are struggling to find growth and improve profitability. One strategy is through consolidation - e.g., Kraft-Heinz, Keurig- Dr Pepper Snapple Group on the manufacturer side, as well as Safeway-Albertsons, Ahold-Delhaize,
How effective is your organization at leveraging data and analytics to power your business models? This question is surprising hard for many organizations to answer. Most organizations lack a roadmap against which they can measure their effectiveness for using data and analytics to optimize key business processes, uncover new business
In this article, I will set out clear principles for how SAS Viya 3.3 will interoperate with Kerberos. My aim is to present some overview concepts for how we can use Kerberos authentication with SAS Viya 3.3. We will look at both SAS Viya 3.3 clients and SAS 9.4M5 clients.
What is Forecast Value Added? Please enhance your Valentine's Day with this treat offered up by the Journal of Business Forecasting. Eric Wilson's very nice discussion of Forecast Value Added, originally published in the Spring 2016 issue of JBF, is now available online: "What is Forecast Value Added?" Eric also
You might have seen a SAS Global Forum infographic floating around the web. And maybe you wondered how you might create something similar using SAS software? If so, then this blog's for you - I have created my own version of the infographic using SAS/Graph, and I'll show you how
When I first learned to program in SAS, I remember being confused about the difference between CLASS statements and BY statements. A novice SAS programmer recently asked when to use one instead of the other, so this article explains the difference between the CLASS statement and BY variables in SAS
Two years ago my husband and I found ourselves on the eve of Valentine’s Day with no plans. It fell on a weekend that year so there was plenty of time to do something. The act of giving gifts isn’t necessarily either of our love languages. We also have very
Todd Wright summarizes several GDPR-related blog posts that cover topics ranging from what the GDPR means to how you can manage consent.
In the hype and excitement surrounding artificial intelligence and big data, most of us miss out on critical aspects related to collection, processing, handling and analyzing data. It's important for data science practitioners to understand these critical aspects and add a human touch to big data. What are these aspects?
Did you know that SAS can combine or "merge" a symbol and a line pattern into a single legend item, as shown below? This kind of legend is useful when you are overlaying a group of curves onto a scatter plot. It enables the reader to quickly associate values of
As the old saying goes, the only constant is change. The corollary that I’ll add is this: and the pace of change feels like it's directly proportional to Moore’s Law. Utilities used to be favorites for conservative investors. Smooth. Steady. When there was change, it was incremental. But today, uncertainty
This is a guest blog by Hayden Dawes, LCSW, LCAS-A, as part of the Work/Life February Relationships Series. We offer our sincere thanks to Hayden for volunteering to contribute! As we head into Valentine's week of 2018, I am struck at the differences as to how children and adults typically celebrate
Want to see my newly minted certified professional badge? Scroll down to take a peek. Yes, I managed to successfully complete the Base SAS Programmer certification exam… with, ahem, flying colors I might add. Here are my tips to tackle the Base SAS certification exam: 1. Get clear on the
In my last article, I worked with an example of using custom polygon data to create a regional geo map in SAS Visual Analytics 7.4. In this article, I will use almost the same example to illustrate the ease of implementing custom polygons to produce the same regional map in
By default, SAS Visual Analytics 7.4 supports country and state level polygons for regional geomaps. In SAS Visual Analytics 7.4, custom shape files are now supported, as well. This means that if a site has their own custom polygon data that defines custom regions, it’s possible to create a region
Jim Harris considers the technical infrastructure challenges of data preparation for streaming data.
With Valentine’s Day just a week away, many of you might already be thinking about the treats that tend to come along with this holiday. Whether or not you celebrate Valentine’s Day, we all love a little special treat now and then. While I don’t believe that you have to
If N random people are in a room, the classical birthday problem provides the probability that at least two people share a birthday. The birthday problem does not consider how many birthdays are in common. However, a generalization (sometimes called the Multiple-Birthday Problem) examines the distribution of the number of
In an earlier blog, I asked you to participate in CertMag/GoCertify’s Annual IT Salary survey. The response was fantastic and I’m happy to report that we made the list of the Top 75 IT certifications out of more than 900. This marks the first time SAS has been part of
Jazz up your Geo Map or Network Analysis graph by applying icon-based display rule markers instead of color markers on the map. With SAS Visual Analytics, you may have already used display rules by populating intervals or adding color-mapped values for report objects. Now, you can jazz up your Geo
Next week I am offering a lunch-and-learn called "Successfully Single: In and out of relationships", but I think I should have titled it "Attractiveness and Self-investment". I am not sure how many people want to be "successfully single", particularly this month when our collective attention is focused on love and
A dual response axis chart is useful when the data type for the multiple measures are not compatible. For example, when overlaying measures like "This Year" sales with "Last Year" sales, the format and magnitudes of the two measures (or values for two groups) may be compatible, and it is
This article simulates the birthday-matching problem in SAS. The birthday-matching problem (also called the birthday problem or birthday paradox) answers the following question: "if there are N people in a room, what is the probability that at least two people share a birthday?" The birthday problem is famous because the
Forecasting Research Survey The Centre for Marketing Analytics and Forecasting at Lancaster University is conducting a new study on how demand forecasters do forecasting. They invite all practitioners who are working with forecasts, such as demand planners and supply managers, to take part in the study. The survey is anonymous
Can felons vote? This seemed like a simple question, but I realized that I wasn't 100% sure of the answer. Therefore I looked into the data ... and apparently "it depends". Follow along and see how I created a map to help answer this question. But before we take the
This is a guest blog by Shelly Hummel, LMFT and Carole Cullen, LMFT as part of the Work/Life February Relationships Series. We offer our sincere thanks to Shelley and Carole for volunteering to contribute! Jennifer and Dave have been married for 3 years. “We have a huge argument every December
For the past few years, I've been hearing from many news sources that Detroit is the most violent large city in the US. If the news is saying this, then the data should corroborate it, eh? Well, of course I decided to check for myself... When comparing crime data across
