Hi! looking for help on how to generate sequential id.
Data dictionary and datafiles are already available, however, due to data privacy, i would like to delete the geo ids (region, province, household no) and replace it with new variable, e.g HHsequentialno (starting 1, 2,.. up to last household).
Thanks.
Generating Sequential ID
Forum rules
New release: CSPro 8.0
New release: CSPro 8.0
-
- Posts: 1777
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Generating Sequential ID
How about making your ID field an auto increment field?
http://www.csprousers.org/help/CSPro/ch ... rties.html
http://www.csprousers.org/help/CSPro/ch ... rties.html