DATA Step, Macro, Functions and more

Concatenation of values in an array?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 81
Accepted Solution

Concatenation of values in an array?

Hi,

I have the following table that is generated by a transpose statement:

 

ID PrdGrp_1 PrdGrp_2 Prd_Grp_3 etc..

1 1 . .

2 1 3 .

3 2 4 9

etc.

 

The above will have PrdGrp_n based on the transactional data prior to the transpose step.

I am looking to create a variable that concatenates PrdGrp_1 to PrdGrp_n separated by '-' so it would look something like this.

 

ID PrdGrp_1 PrdGrp_2 Prd_Grp_3 Description

1 1 . . 1

2 1 3 . 1-3

3 2 4 9 2-4-9

etc.

 

Your help is greatly appreciated, thank you!

 


Accepted Solutions
Solution
‎02-29-2016 12:32 PM
Super User
Posts: 17,819

Re: Concatenation of values in an array?

CATX using of to reference array.

 

CATX ("-", of array(*));

View solution in original post


All Replies
Solution
‎02-29-2016 12:32 PM
Super User
Posts: 17,819

Re: Concatenation of values in an array?

CATX using of to reference array.

 

CATX ("-", of array(*));

Respected Advisor
Posts: 3,124

Re: Concatenation of values in an array?

Just a note, you don't have to put them into an array in order to concatenate them:

 

Desp=catx('-', of Prodgrp:);
or 
Desp=catx('-', of prodgrp_1-prodprp_3);

And be aware, this method is more tolerant than Array method, you won't get warning if you mix up Char variables with Num variables.

 

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 232 views
  • 2 likes
  • 3 in conversation