control the number of decimal places in SAS proc means

sas decimal proc
EbrahimA picture EbrahimA · Feb 1, 2015 · Viewed 7.5k times · Source

I am trying to report my proc means output with 10 decimal places by specifying maxdec=10. However, SAS does not report more than 7 decimal places. Here is the warning I get: WARNING: NDec value is inappropriate, BEST format will be used. I appreciate any suggestion.

Answer

DomPazz picture DomPazz · Feb 1, 2015

If you look at the documentation, it states that MEANS will print out 0-8 decimal places based on the value of MAXDEC. If you want more, you will need to save the results and print them yourself.

Try this:

data test;
format x 12.11;
do i=1 to 1000;
   x = rannor(0);
   output;
end;
drop i;
run;

proc means data=test noprint;
var x;
output out=means_out mean=mean std=std;
run;

proc print data=means_out noobs;
var mean std;
format mean std 12.11;
run;

Related questions

Nested ifelse statement

I'm still learning how to translate a SAS code into R and I get warnings. I need to understand where I'm making mistakes. What I want to do is create a variable which summarizes and differentiates 3 status of a population: …

Read More
SAS function for using 'power' / exponential

I may be missing something obvious, but how do you calculate 'powers' in SAS? Eg X squared, or Y cubed? what I need is to have variable1 ^ variable2, but cannot find the syntax... (I am using SAS 9.1.3)

Read More
sas date - convert today() into yyyymmdd format

How do I convert a SAS date such as "30JUL2009"d into YYYYMMDD format (eg 20090730)? So for instance: data _null_; format test ?????; test=today(); put test=; run; Would give me "test=20090730" in the log...

Read More