Array

[Ronein]

Hello

I want to concatenate multiple times and I am using array.

In the result data set the new variables have null value. What is the problem with the code?

Data RawTbl;
INFILE DATALINES DLM=',';
input ID Customer1901 $ Branch1901 $ Customer1902 $ Branch1902 $ Customer1903 $ Branch1903 $ Customer1904 $ Branch1904 $;
cards;
3188,22339829,855,22339829,855,22339829,855,22339829,855
3195,40031612,832,40031612,832,40031612,832,40031612,832
;
run;

Data wanted;
set  RawTbl;
Array Customer(4) Customer1901 Customer1902 Customer1903 Customer1904;
Array Branch(4) Branch1901 Branch1902 Branch1903 Branch1904;
Array CustBranch(4) CustBranch1901 CustBranch1902 CustBranch1903 CustBranch1904;
Do i=1 to 4;
CustBranch(i)=CATX('-',Customer(i),Branch(i));
end;
Run;

[PeterClemmensen · Accepted solution]

Create your arrays with the proper type and length

Data wanted;
    set RawTbl;

    Array Customer(4) $ Customer1901 Customer1902 Customer1903 Customer1904;
    Array Branch(4) $ Branch1901 Branch1902 Branch1903 Branch1904;
    Array CustBranch(4) $ 100 CustBranch1901 CustBranch1902 CustBranch1903 CustBranch1904;

    Do i=1 to 4;
        CustBranch(i)=CATX('-',Customer(i),Branch(i));
    end;
Run;

[Ronein]

As I see there were 2 problems in the array that I defined:

1- I didn't use $ sign to tell that the variables are chars

2- I didn't use 100 in length 

[PeterClemmensen]

You are correct.