Date:         Fri, 28 Aug 2009 11:03:53 -0700
Reply-To:     Praveen Sawh <praveensawh@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Praveen Sawh <praveensawh@GMAIL.COM>
Organization: http://groups.google.com
Subject:      id lists
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

I am working with a dataset that has id lists.  So for instance one
table has the following 3 ids -
tablepk_id
adult_id
child_id.

The tablepk_id is the unique id for that table.  The other 2 ids are
actually comma separated lists of adult and child ids, e.g. "adult001,
adult002, adult003"

Now each adult and child also have their own tables where the ids are
regular pk ids (not lists).

So, I will be going back and forth between tables where ids can occur
as lists and/or as regular ids.  I am trying to come up with a way to
deal with this.  Any ideas?