topic Rounding for decimals with + in SAS Health and Life Sciences

Rounding for decimals with +

mkop — Fri, 23 May 2014 01:50:35 GMT

I have a variable with data

X= +0.0125

X= +7.90

X= - 0.0076

X= - 0.5

Can anyone help me get all these numbers with same decimal place while keeping the + and - sign in the begining of each number.

Thank you- sign in the begining

Re: Rounding for decimals with +

stat_sas — Fri, 23 May 2014 02:15:36 GMT

Try this.

data have;

input x $;

datalines;

+0.0125

+7.90

-0.0076

-0.5

;

Re: Rounding for decimals with +

ballardw — Fri, 23 May 2014 14:32:34 GMT

How many decimal points do you want displayed? Do want trailing 0 to pad to that length?

Assuming you want 4 decimals then a custom format such as this should work. Make sure the data is read as numeric not character.

proc format library=work;
picture MyDec
low -<0 = '0009.9999'(prefix='-')
0 - high= '0009.9999'(prefix='+');
run;

data have;
input x ;
datalines;
+0.0125
+7.90
-0.0076
-0.5
;
run;

proc print data=have;
format x MyDec.;
var x;
run;

Re: Rounding for decimals with +

Patrick — Sat, 24 May 2014 09:15:27 GMT

You've taken exactly the approach I was playing with as well when I run into some "picture" behaviour I didn't understand. https://communities.sas.com/thread/58118

Suggest you add "round" to your format like data _null_ suggested in the link posted.

...and: I believe '0' should just be '0' and not +0