Hi,
I am looking for a solution to the following problem. I have two String Arrays that I want to combine into a third.
let string no1 = {a, b, c, d, e };
let string no2 = {b Col1, d Col2, e Col3} ;
no1
A
B
C
D
E
no2
B COL1
D COL2
E COL3
And the wanted result:
no3
A .
B COL1
C .
D COL2
E COL3
I hope someone can provide a simple solution 🙂
Peter
1 Answer
0
The GAUSS function outerJoin does exactly what you want. However, as of the writing of this answer, it does not work for string arrays. However, I think this code below will do exactly what you want:
new;
cls;
string no1 = { "a", "b", "c", "d", "e" };
string no2 = { "b" "Col1",
"d" "Col2",
"e" "Col3"};
print outerJoinSA(no1, 1, no2, 1);
proc (1) = outerJoinSA(a, ca, b, cb);
retp(cvtosa(outerJoin(satocv(no1), 1, satocv(no2), 1)));
endp;
Your Answer
1 Answer
The GAUSS function outerJoin does exactly what you want. However, as of the writing of this answer, it does not work for string arrays. However, I think this code below will do exactly what you want:
new;
cls;
string no1 = { "a", "b", "c", "d", "e" };
string no2 = { "b" "Col1",
"d" "Col2",
"e" "Col3"};
print outerJoinSA(no1, 1, no2, 1);
proc (1) = outerJoinSA(a, ca, b, cb);
retp(cvtosa(outerJoin(satocv(no1), 1, satocv(no2), 1)));
endp;