Proc summary-Display in millions

Ronein — Wed, 07 Dec 2022 10:05:10 GMT

Hello

I want to display summary report in millions.

I see that only the sum is in millions, why?

How can we make also max in millions?

data have;
_wgt=1/1000000;
input ID  wealth obligo;
cards;
1 300000 450000
2 20000 30000
3 800000 900000
4 0 10000
5 2000 5000
;
Run;

proc summary data=have nway;
weight _wgt; 
output out=want
max(wealth   obligo   ) = max_wealth   max_obligo   
sum(wealth   obligo   ) = Sum_wealth   Sum_obligo ;
run;

Re: Proc summary-Display in millions

PaigeMiller — Wed, 07 Dec 2022 12:29:27 GMT

Here is your data set HAVE.

In PROC SUMMARY, min and max do not use the WEIGHT statement, they report the actual min or max values. How could you fix this when you create data set HAVE (or elsewhere)? Please provide examples of your attempt to fix this.

What is the method/technique in SAS to make numbers APPEAR different?

topic Re: Proc summary-Display in millions in SAS Programming

Proc summary-Display in millions

Re: Proc summary-Display in millions