Date:         Wed, 2 May 2007 08:57:07 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: concatenating variables with similar first letter fo

with var1-var3 it is simple.

define a array for that and use a loop to put it together.

But what about "all variables which start with V"

var1
vxy2
vaa
vbbb

?

You could extract the names, you want from SASHELP.VCOLUMN, write that to
a macro variable with SQL ... INTO...

and use that macro variable to define a array.
Gerhard



On Wed, 2 May 2007 08:28:03 -0400, Ankur Arora <ankur.arora@NAGARRO.COM>
wrote:

>Hi All,
>
>Does anybody have an idea about concatenating variables
>which start with same prefix.
>
>example suppose we have variable var1 var2 var3
>
>i tried using call catx(separator,variablerequired,var:)
>
>var: defines all variables starting with var get concatenates
>
>but this doesn't work.
>
>Your help is highly appreciated.
>
>Thanks
>Ankur