A Medical Dashboard for the Star Trek Fans


As a kid who grew up in the 60s and 70s, I was a big fan of the original Star Trek TV series. And in the years since, I have seen lots of the Star Trek "technology" become a reality: cellphones, portable tablet computers, talking computers (Alexa/Siri), etc. But I haven't seen the medical dashboard from sick bay. Seems like that would be a useful thing to have, so I decided to create my own version with SAS software!

Here's how this project got started. One of our customers in the health care industry was asking for better ways to display and analyze medical data. My boss at the time (Armistead Sapp) jokingly said "They want the infographic from Star Trek that was above the bed and allowed Bones to instantly know what was wrong with Captain Kirk." Here's an image of the medical dashboard from the original TV series to refresh your memory on what it looked like:

There's not a proc in SAS to create such a graph, but it's is a very flexible and powerful language, so pretty much anything is possible! I started by creating a custom GReplay template, with a space for each of the 6 bar-like graphs, and then an overall space encompassing the rest of the screen (for the main title, and the stuff in the middle).

I used a very tall/skinny stacked bar chart with an annotated triangle beside it for each of the 6 main charts, and annotated simple graphics for the respiration/pulse/etc in the middle. I made it a gif animation to enable the blinking pulse light. I tried to stay true to the original design they used in the TV show, and only make slight modifications (things I thought the original designers would have liked to do, if they weren't hindered by the inherent limitations of a gel-sheet with lights behind it). Below is a list of my enhancements:

  • I color-coded the triangle-markers, to show exactly which color range they were pointing to.
  • I wrote the data values inside the triangle markers.
  • The original has a line to the left of each bar showing the 'good' range. I moved it to the right side.
  • I made the text labels below the bars white instead of orange, since orange is used to represent 'caution' in other parts of the graph.
  • I added mouse-over text, so you can read what the data values are, which also works with iPhone/iPad voice-over, making it usable by the blind.

Here's a snapshot of my dashboard. Click it to see the full size version, which is easier to read. I also set up a SAS/Internet (or Stored Process) version on our intranet (which, unfortunately you can't get to), such that it reads the values from a text file, and refreshes the dashboard every 'n' seconds with the latest data, to make it more like a real-time monitor.

Hope you all enjoyed this (especially the Star Trek fans), and hopefully it has given you a few ideas on how you might use SAS software to visualize some of your data! Here's a link to the SAS code in case you'd like to experiment with it.

This blog was reposted from the SAS Learning Post. Go there to view the original.

Robert Allison, The Graph Guy!, SAS

Robert Allison has worked at SAS for more than 20 years and is perhaps the foremost expert in creating custom graphs using SAS/GRAPH. His educational background is in computer science, and he holds a BS, MS, and PhD from North Carolina State University. He is the author of several conference papers, has won a few graphic competitions, and has written a book calledSAS/GRAPH: Beyond the Basics.

What Cities are in Hurricane Irma's Path?

Here's an example of using data and visualization to look at weather -- specifically, the possible path of Hurricane Irma. Does your city need to get ready?

Mapping Out the Next Robot Invasion

Where are all the robots today? Here's a look at a better data visualization to represent where in the US all the robots are.


Re: What I want to know
  • 7/25/2017 12:49:19 PM
NO RATINGS

Part of the issue is that there is no incentive for preventative care and many insurance companies are offering costs for preventative care. The benefits can be great, but poor medicine is regularly prescribed. I have a family member that will get antibiotics for anything from their physician even with no sign of a bacterial infection. The physician never warns them about side effects and damage that can be caused by it!

Re: What I want to know
  • 7/10/2017 5:06:36 PM
NO RATINGS

@Lyndon_Henry I believe that the Israeli system is not currently a single-payer one. I believe it used to be dominated by Kupat Cholim but now has various other options. Students who go there to study have to purchase some form of medical insurance, and they do have several options with different price points.  When I looked up medical coverages on nbn.org.il/aliyahpedia/government-services/health-care-national-insurance/private-insurance-options-in-israel/, it offered several levels of coverage, including some plans that do cover pregnancy but not hospitalization. I'm not sure if that is intended only for pregnant women who expect to give birth elsewhere or if there would be some provision for a midwife type of birth.

From what I understand, in the UK women typically use a midwife rather than a doctor for delivery, which saves the NHS money, too. In the US, it is much less common to use a midwife, and there are some states that disallow home births.

As for life expectancy, I'd think there are other factors, too. The American diet is probably one of the worst, for one thing. American also seem to walk very little.

BTW when I looked up the country rankings, I found a lot of slide shows and other things that force many clicks on those who want the data. I then found this data.oecd.org/healthstat/life-expectancy-at-birth.htm which does try to pack a lot more into a single graph.

But I think that it could use some Rober Allison improvements. 

 

 

Re: What I want to know
  • 7/10/2017 4:57:47 PM
NO RATINGS

..

Airella quotes

"A risky, delicate procedure done for the first time in Israel this week repaired a severe heart defect in a 28-week-old fetus."

This made me curious about the Israeli healthcare system. It's described as a universal healthcare system, and while it seems to have some problems, they don't seem anywhere near as severe as those of the British NHS. I found a particularly interesting article:

An Overview of Israel's Universal Health Care System

I found the comparison with the USA especially interesting:

According to the latest Organization for Economic Co-operation and Development (OECD) figures, Israel's health care costs constitute 7.5% of its GDP; in the U.S. they account for 17.9% of GDP.

According to the World Bank's latest tally, Israel ranks 8th in the world for life expectancy; the U.S. ranks 26th.

 

 

 

 

 

Re: What I want to know
  • 7/9/2017 11:25:44 AM
NO RATINGS

@Lyndon_Henry agreed, they do run out of money, and that leads to not having the equipment and staff resources necessary to treat everyone. That's why the heart surgeon who wrote Open Heart recounts having to raise funds outside the systems for his experimental surgeries. In one case, a whole team of people also had to be flown in for the procedure. That takes a great deal of money, and the NHS would never pay for something like that. They would cite the poor odds of survival, but the money is really what it boils down to.

I saw this today, and it's exactly the kind of thing that would never happen under the NHS. It's never been done before, no doubt expensive, and cannot guarantee a positive outcome: "Rare heart surgery performed in utero to save sick baby" It's described as "A risky, delicate procedure done for the first time in Israel this week repaired a severe heart defect in a 28-week-old fetus." Much cheaper, cleaner, simpler to abort the fetus. BTW I found it fascinating that they make a point of giving the fetus anaesthesia because they know it does feel pain. When my 3 week old was given a spinal tap, the doctors didn't give her anything to diminish the pain, and she certainly felt it.

 

Re: What I want to know
  • 7/8/2017 9:51:46 PM
NO RATINGS

..

Ariella writes

Well, you can look at the UK. The good news is that they do have extensive electronic records. The bad news is that OECD 2015 report ranked the system as one of the worst in the developed world, as  the Telegraph reported, "Hospitals are now so short-staffed and underequipped that people are also dying needlessly because of a chronic lack of investment."

In evaluating universal healthcare systems like Britain's National Health Service, and their current problems, I think it's important to consider whether problems arise from an intrinsic dysfunction of the system or official policy decisions. In the case of the NHS, I'm convinced that the evidence is overwhelming that policy decisions by the UK government have been the key factor in underfunding and undermining the system, which had otherwise been working effectively since its inception after World War 2.

See, for example:

Outrageous Decline in British Healthcare a Result of Cuts and Privatization

NHS at breaking point, according to British Medical Association

..

Re: What I want to know
  • 6/30/2017 8:32:12 AM
NO RATINGS

I think the defensive medicine attitude is what bothers me the most.  If I could walk in once a year at no cost to get a physical, get all the typical diagnostics done and have a 10 minute discussion about how to adjust lifestyle I'd see them more often.  I find that a lot of people don't do any kind of preventative health care and only start paying attention when something is so bad it's debilitating.  I had a talk with an acquaintance earlier this year about the fact that the edema in his legs is probably a result of his diabetes, to which he snapped back that he doesn't have diabetes.  We talked some more and it turned out that he's never had his blood sugar checked and avoids going to doctors. We end up paying more to fix severely broken people because it's a hassle to do business with our health care system.  There are so many conditions, diseases, etc. that are simple to fix or manage if you catch them early but there's no external incentive for anyone to do so.

Re: What I want to know
  • 6/30/2017 8:22:40 AM
NO RATINGS

@Areilla, What I find most funny about them charging $1 per page is their printer sounds like it's dying.  I suspect they are pooling that money to replace the printer but they won't get the money from me, I have an account with the lab that I go to and I get all my lab results before their office does. 

Re: What I want to know
  • 6/29/2017 10:50:35 PM
NO RATINGS

T Sweeney, the problem is how doctors have long been compensated by payors --- by quantitiy of procedure or patient. So they are incentivized to crowd their waiting rooms and try to fly through as many people as possible. Likewise for diagnostics and the problem of over-prescription. Doctors always blamed "defensive medicine," but it's more like, let me get paid for that! Obamacare was moving physicians and hospitals to a pay for results model ... but who knows what will happen now.

Re: Trends in medical practice size
  • 6/29/2017 1:18:40 PM
NO RATINGS

Very true and the logistics and costs of operating an independent office are crippling many physicians. Implementing technology is often another cost not just for the initial turnover but for all the ongoing maintenance. Many physicians offices feel overwhelmed by the demands of running their office and practicing medicine.

Re: What I want to know
  • 6/29/2017 10:58:14 AM
NO RATINGS

I don't think your post is off-topic at all. To me, it speaks to the impact of the business model being used to deliver healthcare for most people in this country. When every minute is measured and costed out, common sense goes out the window in favor of efficiency and the rules of the system, as you found in your blood text incident.

Page 1 / 5   >   >>
INFORMATION RESOURCES
ANALYTICS IN ACTION
CARTERTOONS
VIEW ALL +
QUICK POLL
VIEW ALL +