Concatenate

[meiryem]

Helow
I have a data like this
C1, c2, c3 ,c4
1, 22, . , .
35 ,765 ,4
1 ,677,.,.
2, 5 ,3 ,7
And i iwant to concatenate with seperator - like this
M1 m2 m3 m4
1 ,1-22. . ,.
35 .35-765. 35-765-4. .
1 ,1-677
2, 2-5 ,2-5-3 ,2-5-3-7
How can i do it with array and do stetment
Tanks for your help
Meir

[Shmuel · Accepted solution]

data want(keep=m1-m4);

 set have;

       length m1-m4 $30;  /* adapt to max length needed */

       array cx {4} c1-c4;   /* input data */

       array mx {4} m1-m4; /* calulated for output */

       do i=1 to dim(cx);

            if i=1 then m1 = c1; else m(xi) = catx('-',mx(i-1),cx(i));

       end;

run;

[meiryem]

תודה רבה שמואל
עבד מעולה
יום טוב ובריאות איתנה