Hello

In my dataset, I have two string variables. I am trying to summarize the number of implementscheme by districts.
implementscheme district
PumpSet State Plan Araria
Rotavator State Plan Patna
Folding LDPE Irrigation Pipe State Plan Arwal
IrrigationPipe NFSM Arwal
I am using collapse (count) implementscheme, by(district). I get type mismatch error.
Am I right in using collapse command? or some other command helps here?

Thank You
Smriti