topic Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000 in SAS Programming

Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

ettinenivarma — Sun, 25 Jun 2017 14:55:28 GMT

Hi All,

I request you to help me rounding mean value -0.00015367 to -0.000 , when i round by using below code

STRIP(PUT(round(MEAN,0.001),8.3)); I am getting 0.000

If I increase decimals to round(MEAN,0.0001) {x=STRIP(PUT(round(MEAN,0.0001),8.3)); }
in order to get -0.000 but this may effect other data ,if possible please do help me with other way of doing..

Thanks in Advance..

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

Jagadishkatam — Sun, 25 Jun 2017 15:08:30 GMT

Please dont round just convert as below

data have;
x=-0.00015367;
x2=put(x,8.3);
put x2=;
run;

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

PaigeMiller — Sun, 25 Jun 2017 15:10:54 GMT

@ettinenivarma wrote:

Hi All,

I request you to help me rounding mean value -0.00015367 to -0.000 , when i round by using below code

STRIP(PUT(round(MEAN,0.001),8.3)); I am getting 0.000

If I increase decimals to round(MEAN,0.0001) {x=STRIP(PUT(round(MEAN,0.0001),8.3)); }
in order to get -0.000 but this may effect other data ,if possible please do help me with other way of doing..

Thanks in Advance..

So maybe you mean something different by the word "rounding" than the ROUND function in SAS means, and something different than the normal mathematical meaning of the word "rounding".

You are doing this "rounding" and creating characters, not numbers, is that really what you want? If so, then I think your code works, and I don't understand the point of your question.

I also don't understand "but this may effect [sic] other data". Could you explain?

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

ettinenivarma — Sun, 25 Jun 2017 15:50:24 GMT

Yes your correct i mean to say round funcation it self ,Yes my end varaible should be char.

Other data means ,in my varaible i had many observation like mean ,sd values etc..

for example : when i round -0.00015367 by using above code i get 0.000 but my requirment is -0.000.

Thanks for your response

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

ettinenivarma — Sun, 25 Jun 2017 16:20:44 GMT

Thanks for quick response.

Your below code gives required output (It truncates ) for that record when i had 0.000XXX but i required do rounding when i had value other then zero value

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

art297 — Sun, 25 Jun 2017 16:29:53 GMT

Would the following suffice?:

data have;
  input mean;
  rmean=round(MEAN,.001);
  if mean lt 0 then rmean=rmean-.00001;
  x=PUT(rmean,8.3);
  cards;
-0.00015367
0
0.00015367
;

Art, CEO, AnalystFinder.com

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

varmae — Sun, 25 Jun 2017 16:49:40 GMT

But could not do hardcoding ".00001" because that variable may contain other values in real time data

Thanks your post sir

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

ettinenivarma — Sun, 25 Jun 2017 17:02:33 GMT

Yes, I can not do hardcording of values...

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

art297 — Sun, 25 Jun 2017 17:09:21 GMT

Couldn't you do hard coding for that one case? e.g.:

data have;
  input mean;
  rmean=round(MEAN,.001);
  if mean lt 0 and rmean eq 0 then rmean=rmean-.00001;
  x=PUT(rmean,8.3);
  cards;
-0.00015367
0
0.00015367
;

Art, CEO, AnalystFinder.com

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

Reeza — Sun, 25 Jun 2017 17:20:18 GMT

@ettinenivarma You use the same function, we don't have your code or data or computer in front of us so you're not going to get something that's exact for your code. The 'hardcoding' is for testing and demonstration purposes with the intention that you take the formula and use it on your data with your own variables.

Please disregard above, this is not correct for your situation. Note that 0 is well 0, there's no sign attached to it, which is why you're seeing those results.

The solution proposed by @Jagadishkatam seems to produce what you want though, otherwise you're probably likely to need to create your own custom function/format.

want = put(myVariable, 8.3);

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

ettinenivarma — Sun, 25 Jun 2017 18:12:56 GMT

Hi Reeza,

Thanks for response.

I to convenced same to my boss saying 0 is 0 there will not be any sign to it, he said as it is financial data he wants as suggested above. I already tryied applying round function and put as well but I want to trying different way of doing to get minus.

Any way thanks all for suggestion and inputs

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

Patrick — Sun, 25 Jun 2017 22:46:28 GMT

@ettinenivarma

I believe you could make this work via a custom format.

proc format;
  value fin_fmt(default=10)
     -0.0005 <-< 0    = '-0.000'
    other         =[f32.3]
    ;
run;

data test;
  do i= -0.001 to +0.001 by 0.000001;
    value_num=i;
    value_char=put(i,fin_fmt.);
    value_round=round(i,0.001);
    output;
  end;
  format value_num fin_fmt. i best32.;
run;

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

ettinenivarma — Mon, 26 Jun 2017 10:31:02 GMT

Thanks sir

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

ettinenivarma — Mon, 26 Jun 2017 10:32:02 GMT

Thanks Patrick for your input

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

Patrick — Mon, 26 Jun 2017 12:26:06 GMT

@ettinenivarma

I believe a custom format is the easiest solution for you.

Financial reports often use Proc Report and should your boss be very demanding then you can also add conditional formatting to make him/her happy as documented here: http://support.sas.com/kb/23/353.html

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

Astounding — Mon, 26 Jun 2017 13:01:39 GMT

Perhaps the simplest solution: stop rounding your data. Instead, just apply a format for printing purposes:

format mean 8.3;

Then a printing procedure should include the negative sign in the report.

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

ettinenivarma — Mon, 26 Jun 2017 17:49:32 GMT

Thanks astounding, but I need to round my data as it is a requirement from client.. when I apply format just truncation of data happens to decimals but not rounding.. thanks for input

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

Astounding — Mon, 26 Jun 2017 17:59:06 GMT

The discussion has centered around the SAS code, but not on the form of the data being provided to the client. If you are providing a text file, you can easily apply the format to unrounded data. Here's a test program, for example, to illustrate:

data _null_;

pos = 0.0001345;

neg = -0.0001345;

put pos 8.3 ',' neg 8.3;

run;

If you are exporting a SAS data set to a .csv file, you can take the generated SAS code (available in the log), and change it slightly by adding your own formats to the PUT statement.

Re: Please help me on rounding the value to 3 decimals places -0.00015367 to -0.000

ChrisNZ — Tue, 27 Jun 2017 05:52:47 GMT

As others have said, the format rounds and keeps the sign.

data HAVE ;
  X= +0.0001345; output;
  X= -0.0001345; output;
  X= +0.0005345; output;
  X= -0.0005345; output;
  X= +5345.1234; output;
  X= -5345.1234; output;
  X= +5345.1236; output;
  X= -5345.1236; output;
run;
data WANT;
  set HAVE;
  Y=put(X,10.3);
  putlog Y=;
run;

Y=0.000
Y=-0.000
Y=0.001
Y=-0.001
Y=5345.123
Y=-5345.123
Y=5345.124
Y=-5345.124