Generating Sequential ID

Discussions about editing and cleaning data
terevelasquez
Posts: 1
Joined: September 25th, 2018, 11:40 pm

Generating Sequential ID

Postby terevelasquez » September 25th, 2018, 11:53 pm

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.

Gregory Martin
Posts: 1049
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Generating Sequential ID

Postby Gregory Martin » September 26th, 2018, 7:34 am

How about making your ID field an auto increment field?

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


Return to “Editing”