The SAS Output Delivery System and reporting techniques

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

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

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

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)


Accepted Solutions
Solution
‎07-17-2012 01:27 PM
Super Contributor
Posts: 1,636

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

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;

View solution in original post


All Replies
Solution
‎07-17-2012 01:27 PM
Super Contributor
Posts: 1,636

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

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 3388 views
  • 0 likes
  • 2 in conversation