BookmarkSubscribeRSS Feed
MerAgSo
Calcite | Level 5

Hi, 

I am trying to run a proc univariate for a large dataset, but some of the variables' output is expressed in scientific notation and I want the absolute numbers. I can change them manually but would rather do it auotmatically. 

Here is my code:

 

proc univariate data=corregida normaltest;
var edad INL bmi; 

run;

 

Thank you. 

2 REPLIES 2
PaigeMiller
Diamond | Level 26

Normally, if the output contains 12 or more digits to the left of the decimal, the default is to create results in scientific notation.

 

Instead of the output as a printed report, you can ask PROC UNIVARIATE to output the results to a SAS data set, and then apply whatever format you want to change the appearance. And then print it whatever way you please with the formatted values.

--
Paige Miller
Rick_SAS
SAS Super FREQ

Use ODS OUTPUT to create a data set that contains the statistics. Then use PROC PRINT to display the value in whatever format you want. For example, the following captures two output tables and uses the 20.16 format to print the numerical values of the statistics:

 

data corregida;
call streaminit(123);
do i = 1 to 100;
   edad=rand("normal",0,1e-10);
   output;
end;
run;

ods trace on;
proc univariate data=corregida normaltest;
var edad ; 
ods output Moments=Moments
           BasicMeasures=BM;
run;

proc print data=Moments;
format nValue1 nValue2 20.16;
run;

proc print data=BM;
format locValue VarValue 20.16;
run;

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1085 views
  • 0 likes
  • 3 in conversation