The legendary broadcaster was diagnosed with prostate cancer in 2007 but the disease was being managed with treatment