DATA Step, Macro, Functions and more

Combining multiple variables

Reply
New Contributor
Posts: 4

Combining multiple variables

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!

Respected Advisor
Posts: 4,644

Re: Combining multiple variables

Looks fine to me. Please give an example. What do the error messages say? - PG

PG
Super User
Posts: 10,483

Re: Combining multiple variables

if the code in a data step looks like:

DXCombined = catx(" ", dx1, dx2, dx3, ..., dx25);

or

( 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.

Super User
Posts: 5,080

Re: Combining multiple variables

Just for ease of coding and simplicity, this variation should work (although I can't test it today):

dxcombined = catx(' ', of dx1-dx25);

Ask a Question
Discussion stats
  • 3 replies
  • 234 views
  • 0 likes
  • 4 in conversation