Hi everyone,

I want to sum a variable and then assign its highest value +1 to an observation. The variable is called cluster and when I summarize it, max=2412. The observation is identified by the town_code 1997.
I tried to do this using (variable names are inclinated):

sum cluster
replace cluster= ( r(max) + 1 ) if town_code==1997

But nothing's changed. Is it even possible to assign r(max) to a variable in any way?
And can someone think of another way to automatically assign that observation (and others) with values of cluster that aren't assigned yet? (all these observations currently hold the value 1 in cluster).

Thanks a lot in advance,
Ben