You should first do a load calculation to determine if 800amps will carry the entire load of the service.
Chances are, it will because not all the loads are operations at 100% of their rated circuit ampacity.
There is no limit to the number of sub-panels you can take off this 800a. The service should properly protect the wires feeding it, and your installation should have a 200a breaker protecting wires capable of carrying that amount of current.