Hello,

I'm having significant difficulty numbering observations. I've attached a screenshot for clarity. In this subset of data, many of the observations underneath the serial number variable are repeated. They are different individuals living under the same household. I'd like each individual in the household to be labeled 1, 2, 3, 4, etc., resuming at 1 for each subsequent serial number. I've been trying to come up with different variations for how to do this for a few hours, only to be met with error messages. If anyone knows a command to do this, I'd greatly appreciate it as I can't go through several million observations manually entering that data.

Thank you