topic Re: Round value upto 8 decimal palces in SAS Programming

Round value upto 8 decimal palces

nishukhawale — Mon, 24 Oct 2016 13:10:13 GMT

Hi,

I am trying to round off the value upto its 8 decimal places I tried following functions and getting results against it but it is not as expect it to be

e.g. value 0.00932304

round function=0

ceil=1

floor=0

int=0

what shall I try so that I can get some result other than these?

I am trying it for column.

Thank You

Re: Round value upto 8 decimal palces

Loko — Mon, 24 Oct 2016 13:13:02 GMT

Hello,

Could you post the code you've tried ?

This one works fine:

data want;
x=0.009323049;
y=round(x,.00000001);
run;

Re: Round value upto 8 decimal palces

ballardw — Mon, 24 Oct 2016 14:05:49 GMT

You might also consider just associating an appropriate display format:

Proc print data=your data;

var yourvariable;

format yourvariable f16.8;

run.

will display the value rounded to 8 decimal places and does not require an additional pass through your data to modify the varible(s).

Re: Round value upto 8 decimal palces

nishukhawale — Tue, 25 Oct 2016 04:54:28 GMT

actually I would like make the process automated and Proc print will not work for me. but thank you very much for your reply and good news is I got the answer for that Var_new= round(var, 10**-dp)

Re: Round value upto 8 decimal palces

nishukhawale — Tue, 25 Oct 2016 05:15:16 GMT

thank you for your reply however I got the output
by using following function
Var_new= round(var, 10**-dp)

Re: Round value upto 8 decimal palces

nishukhawale — Tue, 25 Oct 2016 05:18:30 GMT

yours also gives the same output

Re: Round value upto 8 decimal palces

ballardw — Tue, 25 Oct 2016 14:08:13 GMT

ANY SAS Procedure will accept a format and you can permanently associate the format in either a data step or use Proc Datasets to modify the format for existing variables in existing data sets.

Proc Print was just an example of how to use in a procedure.