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
0 Response to Creating number of obs and summing for new variable value
Post a Comment