topic Re: Concatenate in SAS Programming

Concatenate

meiryem — Sun, 16 Apr 2023 11:10:15 GMT

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

Re: Concatenate

Shmuel — Sun, 16 Apr 2023 13:22:23 GMT

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;

Re: Concatenate

meiryem — Sun, 16 Apr 2023 14:12:37 GMT

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