I have 4 columns I am trying to concatenate and unconcatenate later Var Samp Test Unit
A Sample1 Test1
A Sample2 kg I tried the following catx("-", Var, Samp, Test, Unit); which will give me the following and doesn't leave any room for spaces. I would like to concatenate with the space so that I can unconcatenate later. New
A-Sample1-Test1
A-Sample2-kg Want A-Sample1-Test1-
A-Sample2- -kg As for unconcatenating, I would try somethig like the following but am unsure how to use the scan function. data want;
set have;
array var(3) $;
do i = 1 to dim(var);
var[i]=scan(row,i,'-','M');
end;
run;
... View more