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)
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;
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;
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.