creating unique ID to assign to duplicate addresses in file : <p>I am working to create a household ID when people in my file have the same address but assigned to different people.  I need it to be the same ID for each person with the same address not a sequential ID and I am using a program called Alpine so I need to use Sql or  version of pig syntax. </p>
