The CATX() function will ignore missing (including all blank character values) when building the result. If you want to keep the space for missing values then build the string yourself. For just a few values just list them, for more use some type of DO loop.
string=cat(trim(a),'-',trim(b),'-',trim(c));
... View more
