- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Could you post the code you've tried ?
This one works fine:
data want;
x=0.009323049;
y=round(x,.00000001);
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
by using following function
Var_new= round(var, 10**-dp)
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.