SAS-L archives -- January 2008, week 4 (#256)

Date:	Thu, 24 Jan 2008 10:07:53 -0800
Reply-To:	maryann <JiangqiYangfang@GMAIL.COM>
Sender:	"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:	maryann <JiangqiYangfang@GMAIL.COM>
Organization:	http://groups.google.com
Subject:	Select by Looping through rows
Comments:	To: sas-l@uga.edu
Content-Type:	text/plain; charset=ISO-8859-1

I am trying to figure out how to do looping in SQL. I have table like below:

ID System Material 1 Floor Wood 1 Floor Carpet 1 Wall Dry wall 1 Wall Paper 2 Floor Wood 2 Floor Carpet

I 'd like to end up with results like: ID System Material 1 Floor Wood, Carpet 1 Wall Dry Wall, Paper 2 Floor Wood, Carpet

Any suggestions? Thanks,