08-13-2015 07:48 PM
Hi I'm having a problem combining multiple variables into a single column (or perhaps more exactly, I think I want to concatenate the variables?) . I think I'm supposed to be using the catx function, but I keep getting a variety of syntax errors when I try. I'd like to combine the 5 character code that exists in 25 different variables that are labeled DX1-DX25 into a new column called DXCOMBINED with a space between each value. I'm so far stuck at catx (" ", dx1, dx2, dx3, ....dx25).
Thanks for your help!
08-14-2015 02:21 PM
if the code in a data step looks like:
DXCombined = catx(" ", dx1, dx2, dx3, ..., dx25);
( catx(" ", dx1, dx2, dx3, ..., dx25) ) as DXCombined in proc sql
then I wouldn't expect an error.
It could be that the error is arising from something earlier in the program code.
Post the errors from the log.
08-14-2015 02:22 PM
Just for ease of coding and simplicity, this variation should work (although I can't test it today):
dxcombined = catx(' ', of dx1-dx25);