I have never heard of domestic pets being sedated in flight. Thinking back to 'Airport', they showed hundreds of different animals and sedation was never mentioned. Not least, I'd say, because a sedated creature (including humans) should not be left unattended.