1937, from sour (adj.) + puss (n.2) "face."
A morose person; a chronic complainer and moaner; picklepuss: the regular assortment of first-night sourpusses and professional runners down/ He'd change into a sour-pan (entry form 1937+, variant 1942+)