Generating Sequential ID

Discussions about editing and cleaning data
Forum rules
New release: CSPro 8.0
Post Reply
terevelasquez
Posts: 1
Joined: September 25th, 2018, 11:40 pm

Generating Sequential ID

Post 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.
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Generating Sequential ID

Post by Gregory Martin »

How about making your ID field an auto increment field?

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