Hello,

I am looking for a way equivalent to SPSS (AGGREGATE with PIN) syntax
I have data

id zipcode race
1 11364 white
2 11364 black
3 98006 white
4 98006 asian

Then, I want to have
zipcode count asian black white
11364 2 0% 50% 50%
98006 2 50% 0% 50%

Can anyone please have an idea how to get this?

Thank you,