Date:         Thu, 22 May 2003 13:16:46 -0400
Reply-To:     VJ <vjoshi73@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         VJ <vjoshi73@YAHOO.COM>
Subject:      Concatenate columns

Hi,
I have a dataset with ~ 200 columns(Word1--Word200).
Dataset looks like below :
ID    Word1    Word2    Word3    Word4 -------- Word200
1      Sql     Oracle            Java
2      Sql                       Java
3      SQL     ORACLE            Jave

What I would like is to have a dataset that looks like this:

ID    Words_found
1     Sql, Oracle, Java
2     Sql, Java
3     Sql, Oracle

I know I could just concatenate all these fields and use the compbl
function etc..but does anyone have a suggestion for a more efficient way to
do this?

Thanks in advance for your help.
Vaishali