Manage health care data more quickly

Community Care Behavioral Health Organization has reduced the time it takes to process data by two-thirds, despite the volume of data increasing by 50 percent a year. With the SAS® Data Integration platform, Community Care is better able to provide cost-effective services for its 1 million members while meeting regulatory obligations.

Pittsburgh-based Community Care manages behavioral health coverage for Pennsylvania Medicaid, Medicare and commercial members. It has been honored for ethical practices in patient care by the American Association of Community Psychiatrists. The organization prides itself on paying particular attention to coordinating care with medical insurers and social service agencies, as behavioral health often affects physical illness and vice versa.

For many years, Community Care used an outside vendor to assist with data processing, but felt going forward it needed to bring the process in-house and blend the data with additional sources to help truly coordinate care. "Our goal is to have one source for all our data reporting," says Mary Doyle, Associate Chief Information Officer.

Community Care's data vendor encouraged the organization to look at SAS. Community Care's IT department was not a SAS shop and was not familiar with the scope of SAS products. The organization invited SAS and another vendor to demonstrate their products. SAS was the unanimous choice – even among the technical staff that had reservations about SAS. "We were sold on the data quality/data cleansing aspects," Doyle said.

... we were able to apply SAS best practices in our data warehouse work, thus reducing the trial and error ...

Mary Doyle
Associate Chief Information Officer

"The pure nature of the data integration studio in terms of point and click versus some of the maintenance of the competitors – SAS is just so much more straightforward," Doyle said.

Community Care manages data obtained from claims processing, internal clinical transactions, member eligibility, and financial and pharmaceutical data.
Community Care now has the option to run reports weekly instead of monthly, and the run times have dropped dramatically. Programming is much simpler, Doyle says. Shortening processing time is incredibly important, because the company’s claims record is 60 gigabytes and is expected to grow by another 30 to 40 gigabytes in the next year. It also stores and reports on 15 gigabytes of authorization data.

Being able to run reports more frequently allows the organization to make better data-driven decisions. "That's something our CEO is really focused on," she says.

For instance, the company can now measure clinical interventions. Does a patient released from the hospital need six follow-up services to maintain the discharge plan, or is eight the preferred number? More importantly, can the staff quickly see which members aren't following post-hospitalization protocols?

"Being able to flag records is so much easier," Doyle says.

The speed and ease also gives Doyle more time to provide customized reports for individual departments.

The organization has also engaged in joint projects with an affiliated physical health insurance plan responsible for serving Pennsylvania residents enrolled in Medicare or Medicaid. The goal is to understand how physical diseases affect behavioral health and vice versa and to use data to help the consumer with all aspects of their health care. Once insurers understand the use patterns, they can team with medical personnel to come up with methods to address the problems. "We've actually been able to move our side of this analysis much quicker using SAS as an analytical tool," Doyle says. "We're looking at being able to structure some data to help answer public health-sector questions."

She says the organization plans to add a predictive analytics component..

The company used SAS Consulting® services to get SAS Data Integration up and running quickly.

"The decision to implement SAS strategies in building our warehouse had a direct impact upon its success. By partnering with SAS, we were able to apply SAS best practices in our data warehouse work, thus reducing the trial and error that we might have otherwise endured. We had a wonderful experience," Doyle said.

"I've worked with a lot of different consultants before, and I have to say this is the first one that came in under budget. I thought the folks we worked with were very practical. They were respectful of the fact that we had a very limited number of hours to work with and everything we asked for was given. Working with SAS has been exceptional."


Needed to bring its data warehouse in-house, work with multiple sources of data and produce reports quickly.


SAS® Data Integration


Slashed processing time by two-thirds and can make better data-driven decisions.


Les résultats présentés dans cet article sont spécifiques à des situations, problématiques métiers et données particulières, et aux environnements informatiques décrits. L'expérience de chaque client SAS est unique et dépend de variables commerciales et techniques propres, de ce fait les déclarations ci-dessus doivent être considérées dans un contexte. Les gains, résultats et performances peuvent varier selon les configurations et conditions de chaque client. SAS ne garantit ni ne déclare que chaque client obtiendra des résultats similaires. Les seules garanties relatives aux produits et services de SAS sont celles qui sont expressément stipulées dans les garanties contractuelles figurant dans l’accord écrit conclu avec SAS pour ces produits et services. Aucune information contenue dans le présent document ne peut être interprétée comme constituant une garantie supplémentaire. Les clients ont partagé leurs succès avec SAS dans le cadre d’un accord contractuel ou à la suite de la mise en œuvre réussie du progiciel SAS. Les noms de marques et de produits sont des marques déposées de leurs sociétés respectives.

Back to Top