Hello @Lokesh4,
Whatever your need is, here you have it:
data test;
input Company $ ID Designation $;
Datalines;
ABC 1 Employee
ABC 1 Supervisor
ABC 2 Manager
run;
Data want;
set test;
new_var= CATX('-',ID,Designation);
run; /*The result below*/
... View more
