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!
CATX using of to reference array.
CATX ("-", of 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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.