topic Re: Concatenation of values in an array? in SAS Programming

Concatenation of values in an array?

DangIT — Mon, 29 Feb 2016 17:05:59 GMT

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!

Reeza — Mon, 29 Feb 2016 17:09:39 GMT

CATX using of to reference array.

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

Haikuo — Mon, 29 Feb 2016 17:17:33 GMT

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.