02-29-2016 12:05 PM
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
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
Your help is greatly appreciated, thank you!
02-29-2016 12:17 PM
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.
Need further help from the community? Please ask a new question.