Yesterday a frustrated SAS user complained on Twitter. He's working with a database that stores an ID field as a big long number (perhaps using the database BIGINT type), and SAS can't display a number greater than 15 digits. Well, it's actually 16 digits, depending on the value: %put Biggest
The numbers are daunting. More than 40 million Americans have their identities stolen each year. Credit card companies lose more than $200 billion annually due to fraud. Cybercrime-related losses exceed $3 million per claim for large companies. If you’re like me, those stats are enough to give pause. To fuel the concern,
How bad was the recent recession on the Las Vegas housing market, and what lingering side effects are still being felt? If you don't know squat about real estate housing markets, then this blog post is for you! It takes a simple graphical look at some data that helps explain
.@philsimon on the collision between the two.
My previous blog discussed the SAS Environment Manager Report Center, and talked about its organization, and how to start using some of the prompts to get the reports you want. The next step is to learn to use some of the example reports provided to help you design your own, production-level
As a parent of children who love books, I can tell you that there is something humorous about taking a first name, adding a "Mc" and then a rhyming surname to make up a brand new character name. My daughters always loved to read the adventures of Harry Mclary from
The pharmaceutical industry will undergo significant changes this summer. A set of standards for the identification of medicinal products (IDMP) from the European Medicines Agency (EMA) will take effect in July, requiring the whole industry to apply the terminologies released by EMA. The changes have raised many concerns regarding how
SAS Global Forum 2016 recently concluded and by all measures it was a huge success. With more than 5,000 attendees, hundreds of crazy-good talks and countless networking and learning opportunities, it very likely was the best SAS users’ conference yet. To put a bow on this year’s event, and help
Master data management (MDM) provides methods for unifying data about important entities (such as “customer” or “product”) that are managed within independent systems. In most cases, there is some kind of customer data integration requirement for downstream reporting, and analysis for some specific business objective – such as customer profiling for
The world nowadays is full of all sorts of data. With so much information from such a wide range of sources being compiled on a daily basis, we need to be capable of processing and analysing it extremely quickly. We also want information and knowledge immediately to hand, and are
We are entering week 3 of #NationalEmployeeHealthandFitnessMonth and that means we have another fun "Workout of the Week" in store for you! Grab a pal, head to the RFC or your local gym, and have a great time working out as a pair! NEHFM 2016 WOW: The Partner Workout Who's going
What's the most common data reporting mechanism? Is it web-based reporting? PDFs? How about spreadsheets? Maybe, but in my experience many reports are delivered using a less-scalable and transient mechanism: e-mail. I'm a data steward at SAS. Specifically, I look after the operational data around our blogging program and our
It was John Allen Paulos who said, “Data, data everywhere, but not a thought to think.” That rings true more than ever before. Companies are struggling with the deluge of data coming at them from multiple channels. But traditional data channels are just the beginning. Companies also are facing an
Last week I was at PharmaSUG 2016, where I presented a 1/2 day seminar on creating Clinical Graphs using SAS. I was gratified to have a enthusiastic audience of about 28 attendees and we had a great interactive session. I also presented a paper on Clinical Graphs Using SAS. More
I recently had a chance to hear Dr. Karl Kruszelnicki on triple j radio in Australia. Known simply as Dr. Karl, he has a weekly national show answering science questions on an alternative rock radio station. Yes, science on rock radio. Yes, national. Yes, Thursday morning – when people are
Trusted data is key to driving accurate reporting and analysis, and ultimately, making the right decision. SAS Data Quality and SAS Data Management are two offerings that help create a trusted, blended view of your data. Both contain DataFlux Data Management Studio, a key component in profiling, enriching monitoring, governing
The buzz about the Internet of Things (IoT) combined with the insights derived from analytics appears to be hotter than ever. What's interesting to me is how many people go about their lives without knowing what the IoT is and how they're already benefitting from it (or how their jobs
I've spent much of my career managing the quality of data after it was moved from its sources to a central location, such as an enterprise data warehouse. Nowadays not only do we have a lot more data – but a lot of it is in motion. One of the
In my previous post, I wrote about the Quick Pulse survey of leaders of health care institutions and the vital role data and analytics has in patient care and engagement. In this post, I'll tell you what the survey had to say about the progress these leaders believe they are
In this blog post I explore some of the open data police incident reports for Raleigh and Cary, while showing you the easy way to handle various types of CSV files. In recent years, many cities have set up open data websites, to share various kinds of data about their city.
.@philsimon asks some fundamental questions about taking the next step with #bigdata.
Research indicates that IoT and Machine Learning are more valuable to utilities when used in combination but there are hurdles to overcome first. Machine learning and IoT will enable utilities to better realize the next generation of the power grid: a distributed system with power flows among millions of things
“All for one and one for all” is best known as the motto from “The Three Musketeers”, but this phrase could easily sum up the growing trend in social brokers. With advanced analytical techniques like generalized linear modeling insurance companies have created more granular pricing structures. But despite the assertions
I admit, I’ve always loved beets! I can remember eating beets right out of the can as a kid. My grandma would also pickle them. YUM! I love beets! I actually never had a fresh beet until I got a little older and was cooking for myself. The difference between
I’ve been giving presentations about SAS® ViyaTM for a couple of months now, and the reactions have been positive. I’m part of a much bigger cast of speakers at SAS who talk about the new analytics platform with key customers and analysts. While some presenters focus on the overarching benefits or the
In my previous post, Jedi SAS Tricks - Make This a Button in Base SAS I demonstrated running a SAS program from a tool bar button in the SAS Windowing environment. The program we execute is the macro from a previous post, Jedi SAS Tricks: The DATA to DATA Step
As everyone in the financial industry knows, CCAR (comprehensive capital analysis and review) was set up as a capital adequacy assessment for the major US banks. Through several years of practice and feedback, CCAR has evolved into a comprehensive stress testing exercise -- and in doing so, created a new
How do you define Health? What about Fitness or Wellness? To me there is a lot of overlap. For example, if I say I ran 3 miles today, would you say the run benefited my health, improved my state of fitness, or contributed to my overall well-being? I believe I
In my previous post I discussed the practice of putting data quality processes as close to data sources as possible. Historically this meant data quality happened during data integration in preparation for loading quality data into an enterprise data warehouse (EDW) or a master data management (MDM) hub. Nowadays, however, there’s a lot of
The current rate of workforce change is unprecedented. Each new generation of working professionals is emerging more rapidly than the one before, with increasingly advanced expectations of their employers. The latest cohort is Generation Z, typically defined as those born after 1998. This group is fresh-faced, independent and extremely pragmatic.
