Hi all, The following code is the significant figures implemented through PROC FCMP. However, if you don't familiar FCMP since there are tiny differences between SAS data step and FCMP, you can easily code in data step or in MACRO form.
******************************************************************************
Significant Figure(digit)
******************************************************************************;
* Function to show a number to its significant figure form which could be
widely used for scientific number presentation ;
libname my "Your physical location...";
proc fcmp outlib=my.func.format;
function rndgt(x, sf);
* Round to the specified digit according to significant figure ;
if x ~= 0 then out=round(x, 10**(ceil(log10(abs(x))) - sf)); else out=0;
return(out);
endsub;
function extsf(x) $30;
* Extract significant digits from a number ;
attrib sfc length=$30;
if x~=0 then do;
xc=compress(put(x, best.)); /* Char. of x */
sfc=prxchange("s/[-\.]//", 2, xc); /* Eliminate . and - */
sfc=prxchange("s/0*([1-9][0-9]*)/$1/", -1, sfc); /* Eliminate leading 0's */
end; else sfc=' ';
return(sfc);
endsub;
function sigFig(x, sf) $30;
* Show significant figure result as a Char. ;
attrib sfc length=$30;
attrib out length=$30;
if x=. then do; out=' '; go to return; end; /* If input is missing */
xr=rndgt(x, sf); /* Rounding result */
xrc=compress(put(xr, BEST30.)); /* Char. of xr */
* Adding trailing 0's ;
n0=sf - lengthn(extsf(xr)); /* Number of adding 0's */
if n0 > 0 then do; /* The case we need to add 0's */
zeros=repeat("0", n0 - 1); /* zeros we add*/
if index(xrc, ".") then out=cats(xrc, zeros); else
out=cats(xrc, ".", zeros); /* For integer, adding decimal point */
end; else out=xrc;
return:
return(out);
endsub;
options cmplib=my.func;
* TEST ;
data one;
length result $30;
input x;
sf=3;
xr=rndgt(x, sf);
sig=extsf(x);
result=sigFig(x, sf);
datalines;
.
-0.007777
0.012
0.01235
0.01234
0.0001
1.1
1.125
100.1
0
;
run;
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.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.