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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.