In researching material for an upcoming project, I investigated the SAS Deployment Backup and Recovery Tool available in SAS 9.4. Here are some of my findings on identifying what directories are included in a Backup and Recovery session and how to add custom directories to a backup configuration. The SAS
The physical and social costs of untreated mental illness are significant and have been discussed in detail in previous posts. Now let’s talk about the immense financial costs, then I’ll wrap up the series with a conclusion. The financial costs cover a broad cross-section of society, including government services and
There are some things every company should know about the nature of its business. Yet many organizations don't know these fundamentals -- either because they are short on resources, or their resources don't have the analytical skills to do the work. The summer research projects offered by the Lancaster Centre for Forecasting,
With our recent client engagements in which the organization is implementing one or more master data management (MDM) projects, I have been advocating that a task to design a demonstration application be added to the early part of the project plan. Many early MDM implementers seem to have taken the
When we talk about digital customer services, it’s all about creating online self-service capabilities for our customers. This is great for everyone! We’ve made it easy for the customer to get what they need; it’s cheaper and faster for organizations to deliver the service to the customer. Need a copy
The underground economy is driving a hole in the collection of income taxes, social security, unemployment and Medicare to the tune of hundreds of billions of dollars annually within the United States. Yet significant questions remain about how big the problem is, as well as what should be done about it.
The Lancaster Centre for Forecasting is seeking Master Student Projects in Forecasting, Data Mining, or Analytics for summer of 2015. Projects normally run from mid-May to mid-August, with reports issued a few weeks after. These projects are a cost efficient way for a company to carry out analytical work by
In an era long gone by (actually not so long ago) we all interacted with computers via terminals to a mainframe or minicomputer systems. Sometimes, you had to book a slot for when you could access and exploit computer resources. The user was subject to interrupted connections or very poor
Life is a gift, and it offers us the privilege, opportunity, and responsibility to give something back by becoming more. - Anthony Robbins Every year at SAS Global Forum, SAS professionals from all over the globe gather, reconnect and learn from each other. And wherever they gather, SAS Global Forum
It’s that time of year again, and I have retail on my mind. Not only because we’re reaching the peak of the holiday buying season, but because we at SAS are getting ready for one the biggest events on our calendar, the National Retail Federation tradeshow in January. As I’m
How does Santa keep track of everything on his big night? I can't confirm or deny that he uses SAS software -- but if he does, it would look a lot like this! ... A couple of years ago, I blogged about a prototype dashboard that I wrote for Santa. This
I have a rule – any conversion or upgrade will require the creation of a decommission plan. A decommission plan should include the following: A list and definition of each database, table and column (source and target). A list and definition of each of the current programs in use (you
The physical data model should represent exactly the way the tables and columns are designed in the in the database management system. I recommend keeping storage, partitioning, indexing and other physical characteristics in the data model if at all possible. This will make upkeep and comparison with the development, test
Last week, I had lunch with a friend who I hadn’t seen in quite some time. As I approached the table, I noticed my friend busily writing away in her journal. With a fantastic smile, my friend shared that she was writing down her personal and professional goals for the
SAS will again be participating in the Allied Social Science Association annual meetings in January. This year the event will be held in Boston, and conference organizers expect more than 12,000 participants from a variety of backgrounds, including economics, finance and many other social sciences. One of the primary functions
If you haven’t tried them for your web applications and other graphics needs, you’ll want to read further! Scalable Vector Graphics (SVG) output is vector graphics output you can display with most (if not all) modern web browsers. Because SVG graphic output is scalable, you can zoom in on the
We've explored data provenance and the importance of data lineage before on the Data Roundtable (see here). If you are working in a regulated sector such as banking, insurance or healthcare, it is especially important right now and one of the essential elements of data quality that they look for
.@philsimon on an important question.
Often we need graphs that display two or more responses by the same category values. In many cases it is useful to plot both responses on the same response (Y) axis. This can be helpful to understand the data and compare the magnitudes side by side. This works when the scales
For a long time, master data management (MDM) practitioners boasted about their ability to build a 360° view of customers by aggregating and proactively managing information coming from various business applications such as CRM systems, ERP applications, and other operational systems. But was it really a 360° view? What about
The RFC is closed during winter break, but don’t miss out on a chance to burn a few of those extra holiday calories with the RFC’s 12 Days of Fitness Workout by Pam Cole! Please check with your health care provider prior to starting a new exercise routine. Photos by Edie
As SAS administrators, I know you are as excited as I am by the ability of SAS Environment Manager to monitor, in detail, the performance of their SAS environments. Now, we have a robust tool to monitor, measure and report on the performance of the various SAS components. An added
‘Tis the season. While the season means different things to different people, its most common theme is people buying things for people. Things that become presents when they are covered in wrapping paper. Two retailers have been running television commercial campaigns this season about how presents are wrapped. One campaign
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 at more than 265 pounds of candy- 45 more pounds than we collected last year! So what happened to ALL that candy? Well,
I recently posted an article about self-similar structures that arise in Pascal's triangle. Did you know that the Kronecker product (or direct product) can be used to create matrices that have self-similar structure? The basic idea is to start with a 0/1 matrix and compute a sequence of direct products
Well, Analytic Hospitality Executives, the year has once again flown by, and here we sit just before the holidays looking back on 2014, and figuring out what it all means for 2015. I traveled even more than usual this year (if that’s even possible), spending a significant amount of time
The impact of mental illness on individuals, families, the health system and even the economy is broad and significant. In this, the latest post in my mental health series, I’d like to talk about what can be done to help. Prevention and early detection are just parts of an integrated
I have a question --- do we need a logical data model for a conversion? Here are my thoughts. I believe the answer is yes if the conversion has any of the following characteristics: The target application is created in-house. This application will more than likely be enhanced in the
Flexibility and nimbleness are terms synonymous with small and mid-sized businesses. They have the ability to react quickly to changing market conditions as they are made aware of them. Traditionally these businesses have lived in the world of spreadsheets - and why not? They are easy to use, very affordable
In the last post we looked at the use case for master data in which the consuming application expected a single unique representative record for each unique entity. This would be valuable in situations for batch accesses like SQL queries where aggregates are associated with one and only one entity record.
