topic combining two variables in SAS Procedures

combining two variables

kumarnaidu — Thu, 26 Apr 2012 07:30:19 GMT

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;

Re: combining two variables

Patrick — Thu, 26 Apr 2012 07:57:53 GMT

length my_variable $20;

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

Re: combining two variables

shivas — Thu, 26 Apr 2012 08:20:50 GMT

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

Re: combining two variables

Jagadishkatam — Thu, 26 Apr 2012 08:40:54 GMT

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

Re: combining two variables

kumarnaidu — Thu, 26 Apr 2012 08:53:46 GMT

Thanks shivas it is working.