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
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).
Hello,
Could you post the code you've tried ?
This one works fine:
data want;
x=0.009323049;
y=round(x,.00000001);
run;
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).
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.