Hello,
I have data on loans, one loan per observation, each with a zipcode and amount attached as variables .

1.I looking to get the number of observations/loans per zipcode (string) or zipnumber (same value but long).
So I'm looking to have 1 distinct zipcode as an observation and a number of loans for that zip code as a new variable value.

2. I looking to sum the "amount" variable for each zipcode into a new variable.
So I'm looking to get distinct zipcodes for each observation with an amount summed from the "amount" variable.

Thanks,
​​​​​​​Tom