Edgar, who died of cancer treatment complications, was lauded for guiding US state into financial stability in 1990s