| Date: | Wed, 28 Jun 2006 07:38:51 -0700 |
|---|
| Reply-To: | Apsteinberg <apsteinberg@HOTMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Apsteinberg <apsteinberg@HOTMAIL.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | Single row into multiple columns |
|---|
|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
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
| 
