All Posts
There are many ways to do data integration. Those include: Extract, transform and load (ETL) – which moves and transforms data (with some redundancy) from a source to a target. While ETL can be implemented (somewhat) in real time, it is usually executed at intervals (15 minutes, 30 minutes, 1
The Midwest SAS Users Group (MWSUG) 2015 conference is almost here and there’s a lot to get excited about. The event takes place October 18-20 in Omaha, NE. If you haven’t already registered, regular registration has been extended through October 13th. The full conference agenda is now available. We hope
Though crude oil prices edged up last week, the market remains well below VirtualOil’s original $50 strike price, meaning the hypothetical portfolio’s production is shut in in the spot market again. Oversupply continues while China GDP forecasted growth is slowing. Given the market outlook, the VirtualOil board has decided to
This guest blog post comes from Dr. David Dickey, one of our original SAS Press authors. Hope you enjoy! In the late 1970s, shortly after SAS was founded, I was approached by Herbert Kirk and John Brocklebank from SAS to put together a course on time series. This was reasonably
The SAS In-Database Embedded Process is the key technology which enables the SAS® Scoring Accelerator, SAS® Code Accelerator, and SAS® Data Quality Accelerator products to function. The EP is the computation engine we place near the data, which reduces unnecessary data movement and speeds up processing and efficiency. The EP
Jim Harris addresses some of the most common questions and challenges big data poses for data quality.
In my last blog, I demonstrated how to configure a SAS server to write a record to a log file showing who is opening, editing or renaming a SAS table. In this blog we will see how we can process that information. The documentation shows one way to do this via
“Everywhere modern processed foods go, chronic diseases like obesity, type 2 diabetes and heart disease soon follow.” -Kris Gunnars The typical American diet is inundated with highly processed carbohydrates. We have a bagel made from white flour and sugar for breakfast, a sandwich on white bread for lunch, potato chips
Suppose that you are tabulating the eye colors of students in a small class (following Friendly, 1992). Depending upon the ethnic groups of these students, you might not observe any green-eyed students. How do you put a 0 into the table that summarizes the number of students who have each
I’ve often heard people say about weather forecasters “they have the best job…they just report what the models are telling them, and when they’re wrong they can always blame it on Mother Nature throwing us a curve.” While that’s true, this glass-half-empty crowd is failing to appreciate how amazing the
I remember being intrigued by the movie In Search of Noah's Ark, when I was a kid back in the 1970s. They claimed to have definitively found the ark ... but of course, since then several other people claim to have found it in other locations. Therefore I don't feel too
Following World War II, an intelligence-sharing partnership was formed between Australia, Canada, New Zealand, the United Kingdom and the United State of America. The original alliance, called Five Eyes, was focused on monitoring the communications of the major global threat at the time – the Soviet Union. As the world
If you’re looking to advance your knowledge and your career, few activities are better than attending a professional conference, where new ideas, best practice discovery and networking opportunities abound. For many SAS users, regional user group meetings provide a forum to learn from other users and meet successful professionals in
Editor Len Tashman's Preview of the Fall 2015 issue of Foresight This 39th issue of Foresight features a special section on forecasting support systems (FSS) developed by our FSS Editor Fotios Petropoulos. His article Forecasting Support Systems: Ways Forward highlights three main areas for improvement: better utilization of open-source software
People encounter stress in all types of situations. Positive stress occurs when we are exposed to new situations or challenges, perhaps a new job or attending a new school – this type of stress is typically short term and is a necessary factor in healthy development. Tolerable stress results from