Combining 3 numeric variables to create a single character variable with parentheses and dashes

[HyunJee]

I have 3 variables: mean, lowerCLmean and upperCLmean. I want to combine them and add in parentheses around the lowerCLmean and upperCLmean as well as a dash between the lowerCLmean and upperCLmean. Below is an example of what my data is currently like and the data under new variable is how I would like it to look at the end. Thank you for any help you can give.

Mean          lowerCLmean          upperCLmean

45               30                         50

20               15                         30

new variable

45 (30-50)

20 (15-30)

[Linlin · Accepted solution]

data have;

input Mean   :       lowerCLmean       :   upperCLmean;

cards;

45               30                         50

20               15                         30

;

data want;

  set have;

  length new $ 12;

  new=cat(mean,' (',lowerclmean,'-',upperclmean,')');

proc print;run;