combining two variables

[kumarnaidu]

my variable	Mean	Std
.±.	69.7454545	7.56262296
69.75±7.56	68.0612245	8.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;

[Patrick]

  length my_variable $20;

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

[shivas · Accepted solution]

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

[Jagadishkatam]

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

[kumarnaidu]

Thanks shivas it is working.