Help using Base SAS procedures

combining two variables

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

combining two variables

my variableMeanStd

.±.

69.74545457.56262296
69.75±7.5668.06122458.51079746

Hi I want to combine Mean and std deviation as Mean ± Std .And I am doing this by using below code.But you can see My variable column it is not correct result.Can any one tell me why it is happening.

data average2;

my variable=compress(round(mean,0.01)||'±'||round(std,0.01));

set average1;run;


Accepted Solutions
Solution
‎04-26-2012 04:20 AM
Super Contributor
Posts: 349

Re: combining two variables

Hi Kumar,

Try this code..you results will come correct...You are combining mean and std before set statement.

data average2;

set average1;

myvariable=compress(round(mean,0.01)||'±'||round(std,0.01));

run;

Thanks,

Shiva

View solution in original post


All Replies
Respected Advisor
Posts: 4,173

Re: combining two variables

Posted in reply to kumarnaidu

  length my_variable $20;

  my_variable=cats(round(mean,0.01),'±',round(std,0.01));

Solution
‎04-26-2012 04:20 AM
Super Contributor
Posts: 349

Re: combining two variables

Hi Kumar,

Try this code..you results will come correct...You are combining mean and std before set statement.

data average2;

set average1;

myvariable=compress(round(mean,0.01)||'±'||round(std,0.01));

run;

Thanks,

Shiva

Trusted Advisor
Posts: 1,137

Re: combining two variables

Posted in reply to kumarnaidu

Hi Kumar,

you can use catx() to solve your problem. Please check the below code. hope it helps.

data concat;

input mean std;

myvariable=catx('±',mean,std);

cards;

69.7454545    7.56262296

68.0612245    8.51079746

;

run;

Output of myvariable:

69.7454545 ± 7.56262296

68.0612245 ± 8.51079746

Thanks,
Jag
Occasional Contributor
Posts: 13

Re: combining two variables

Posted in reply to kumarnaidu

Thanks shivas it is working.

🔒 This topic is solved and locked.

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

Discussion stats
  • 4 replies
  • 281 views
  • 3 likes
  • 4 in conversation