Knowing the who, informs the what

Accurate diabetes data helps New Zealand provide appropriate and timely care

Diabetes is a condition in which the pancreas fails to make enough insulin or the body is insensitive to the insulin present, resulting in an overabundance of glucose in the blood. Patient care for the condition is extremely important as diabetes often causes additional complications, including significant morbidity, mortality and high health care costs.

New Zealand's Ministry of Health found it difficult to accurately estimate the number of cases in the country since there was no consistent data collection across all general practices and hospitals. With the help of SAS' data analysis capabilities, the ministry created a register to accurately predict the prevalence of the condition and help design effective public health policies to support quality clinical improvements.

GPs should know already how many [diabetic patients] they have - the VDR is also able to help them predict who may be at risk so they can be prepared.

Dr. Paul Drury
Clinical Director of the Diabetes Auckland Center and Medical Director of NZSSD

Tracking the population of diabetics

The Ministry of Health, in collaboration with experts from the New Zealand Society for the Study of Diabetes (NZSSD), established a Virtual Diabetes Register (VDR) that combines and filters various sources of health information to more accurately determine how many people are diagnosed with the condition, as well as predicting who is likely to develop it in the future.

Dr. Paul Drury, Clinical Director of the Diabetes Auckland Center and Medical Director of NZSSD; Dr. Sandy Dawson, Chief Clinical Advisor; and Emmanuel Jo, Principal Technical Specialist at Health Workforce New Zealand, Ministry of Health, have all been instrumental in the establishing the VDR.

"Previously, we would use national surveys to measure diabetes in the community; however, this proved to be slow, costly and have a high error rate," Jo says. "Now, the quality of data within the VDR is offering the accuracy and immediacy we need."

Six major databases were used to establish the VDR: hospital admissions coded for diabetes; outpatient attendances for diabetes and diabetes retinal screening; prescriptions of specific antidiabetic therapies; laboratory orders for HbA1c, which is a measure of diabetes management; and primary health (general practitioner) enrollments.

Using SAS software, an analytical model was created and modified to improve sensitivity and specificity, and then validated against primary care registers.

"Primary data was linked by the National Health Index number, which was available from six databases at the ministry," Jo says.

He adds one challenge came from linking the six data sources and integrating them with a patient's health number to work out if they needed to make contact with their local health center – a process he says took years to refine.

But Drury says the initial results were impressive. "The initial estimation before the VDR was refined showed that 210,679 people, or 4.88 percent, had diabetes in New Zealand as of Dec. 31, 2009. This compares with the country's population of 4,315,355. The VDR yielded a final estimate of 189,256 people, or 4.39 percent, with diabetes."

He adds that diabetes prevalence also showed a clear difference between European/other versus non­European/other ethnicity. "Indian and Pacific people have the highest diabetes prevalence rate," Drury says. "This means we can focus health policies on this group.

"The beauty of the VDR is in combining many data sources and merging the database with other sources of data to look at the implication of diabetes in particular cohorts," Drury says.

"SAS' analytical capabilities have been the key tool in developing the VDR to be very accurate and robust, revealing a true representation of the diabetes population," Jo says.

More effective health policy planning

In addition to more accurately predicting the number of people with diabetes, the VDR is used for planning health services and policies.

"We have 20 different District Health Boards (DHB), and the data can show them how many diabetic people are in their area," Drury says. "GPs should know already how many they have, but the VDR is also able to help them predict who may be at risk so they can be prepared. By knowing the populations where diabetes is more prevalent, more resources can be directed at them to provide clinical quality improvements."

Privacy in health is always an important factor, but Drury says access to the data in the VDR is regulated. "We have built the VDR to ensure there is privacy around patient information. Each DHB from this year can access this and see its data. GPs themselves don't have open access to the register – it only goes to those directly involved in that individual person's health care."

100 million rows of data with SAS®

The VDR relies on SAS for its analytical data management. "SAS is the only tool that is able to deal with the amount of number crunching that we require," Jo says. "Some of the data sets we use are very large with more than 1 million rows of data per month. Sometimes we need to go back 10 years, so we're looking at working with over 100 million rows of data. SAS is the best tool to enable this."

In the future, the VDR will continue to have more criteria added to it to monitor changes. "The criteria from five years ago will become less accurate as medical science changes, so our systems with SAS are built to be able to respond easily to these changes," Drury says.

Jo adds that it is very easy to change the analytical models in the SAS solution. "It is a well-­structured system with robust coding," he says.

Both Jo and Drury are extremely pleased with the support from SAS in setting up the VDR and the positive effects it has had on managing diabetes in the country.

"The VDR is invaluable for monitoring national prevalence and supporting clinical quality improvements," Drury says. "It is also readily applicable to other areas and future projects to investigate the correlation between the two areas or among many other factors."

Ministry of Health Logo


Getting accurate information surrounding the number of people in New Zealand with diabetes.



  • Linked six data sources and integrated those sources with patient's heath number.
  • Identified cohorts with increased prevalence rate.
  • Can predict who may be at risk to ensure appropriate resources are available.

Bu makalede gösterilen sonuçlar, burada açıklanan belirli durumlara, iş modellerine, veri girdilerine ve hesaplama ortamlarına özeldir. Ticari ve teknik değişkenlere bağlı olarak, her bir SAS müşterisinin deneyimi kendine özgüdür ve hiçbir açıklama tipik olarak düşünülmemelidir. Gerçekleşen tasarruflar, sonuçlar ve performans özellikleri, bireysel müşteri konfigürasyonlarına ve koşullara göre değişiklik gösterecektir. SAS, her müşterinin benzer sonuçlara ulaşacağını garanti etmemekte veya bu konuda bir taahhütte bulunmamaktadır. SAS ürün ve hizmetlerine yönelik tek garanti, söz konusu ürün ve hizmetlere dair yazılı anlaşmada belirtilen açık garanti beyanlarında ifade edilen garantilerdir. Bu belgedeki hiçbir ifade, ek bir garanti teşkil ettiği yönünde yorumlanmayacaktır. Müşteriler, üzerinde anlaşılmış bir sözleşmeden doğan bir alış verişin bir parçası olarak ya da SAS yazılımının başarılı bir şekilde uygulanmasının ardından sunulan proje başarı özetinde, başarılarını SAS ile paylaşmışlardır. Marka ve ürün adları, söz konusu şirketlerin ticari markalarıdır.