DATA Step, Macro, Functions and more

Concatenating charater array

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

Concatenating charater array

Is there a sas function that can conactenate all members of a temporary character array using a given seperator? Something like CatX(" ", of myArr)  but this doesn't work. Here is a sample code of what I want to accomplish using some function.

Data _null_;

     Array myArr {4} $ _temporary_ ("A" "B" "C" "D");

     Length catResult $100;

     catResult="";

     Do i=1 to dim(myArr);

          catResult=CatX(" ", catResult,myArr{i});

     End;

     Put catResult;

Run;

    

Thanks


Accepted Solutions
Solution
‎09-26-2013 09:40 AM
Respected Advisor
Posts: 3,124

Re: Concatenating charater array

Is this you are after?

Data _null_;

  Array myArr {4} $ _temporary_ ("A" "B" "C" "D");

  Length catResult $100;

  catResult="";

/* Do i=1 to dim(myArr);*/

  catResult=CatX(" ", of myArr{*});

/* End;*/

  Put catResult;

Run;

Haikuo

View solution in original post


All Replies
Solution
‎09-26-2013 09:40 AM
Respected Advisor
Posts: 3,124

Re: Concatenating charater array

Is this you are after?

Data _null_;

  Array myArr {4} $ _temporary_ ("A" "B" "C" "D");

  Length catResult $100;

  catResult="";

/* Do i=1 to dim(myArr);*/

  catResult=CatX(" ", of myArr{*});

/* End;*/

  Put catResult;

Run;

Haikuo

Respected Advisor
Posts: 3,777

Re: Concatenating charater array

What version of SAS are you using?  This should work with temp array V9.2+

catResult=CatX(" ",of myArr{*});

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 193 views
  • 4 likes
  • 3 in conversation