Page 1 of 1

Generating Sequential ID

Posted: September 25th, 2018, 11:53 pm
by terevelasquez
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.

Re: Generating Sequential ID

Posted: September 26th, 2018, 7:34 am
by Gregory Martin
How about making your ID field an auto increment field?

http://www.csprousers.org/help/CSPro/ch ... rties.html