2002 was the only year that combo was available when the SC could be added to the XE trim. Since then they've made the SC only available on the SE trim which no longer offers the option of a manual transmission.
The Canadian market still offers a 5-speed SC though. If you want one bad enough, it's apparently not too difficult to have one brought over the border.
Brent