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

HyunJee — Tue, 17 Jul 2012 17:19:51 GMT

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)

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

Linlin — Tue, 17 Jul 2012 17:27:16 GMT

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;

topic Combining 3 numeric variables to create a single character variable with parentheses and dashes in ODS and Base Reporting

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

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