Calcite | Level 5

## Concatenate

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
Meir
1 ACCEPTED SOLUTION

Accepted Solutions
Garnet | Level 18

## Re: Concatenate

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;

2 REPLIES 2
Garnet | Level 18

## Re: Concatenate

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;

Calcite | Level 5

## Re: Concatenate

תודה רבה שמואל
עבד מעולה
יום טוב ובריאות איתנה
Discussion stats
• 2 replies
• 199 views
• 0 likes
• 2 in conversation