Hi,

See for a similar problem and a solution: http://listserv.uga.edu/cgi-bin/wa?A2=ind0606B&L=sas-l&P=R21295

Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld

On Wed, 28 Jun 2006 07:38:51 -0700, Apsteinberg <apsteinberg@HOTMAIL.COM> wrote:

>Here is my issue...I have a table with 60K records. There are multiple >individual IDs for one site id. The data looks something like this: >Site_ID Individual_ID >1 1 >1 2 >1 55 >3 8416 >5 4568 >9 46 >13 88 >13 959 > >I need the data to be listed like this: > >Site_ID Individual_ID >1 1, 2, 55 >3 8416 >5 4568 >9 46 >13 88, 959 > >Or like this: >Site_ID Individual_ID Individual_ID Individual_ID >1 1 2 55 >3 8416 >5 4568 >9 46 >13 88 959 > >I need to get it so that only one site id is listed per column >corresponding to every individual id for the site id. Right now I have >it so that if I have more than one individual id it is a new column. >Please help. Thanks