BookmarkSubscribeRSS Feed
Ronein
Meteorite | Level 14

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;
1 REPLY 1
PaigeMiller
Diamond | Level 26

Here is your data set HAVE.

 

PaigeMiller_0-1670412442154.png

 

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?

--
Paige Miller

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 289 views
  • 0 likes
  • 2 in conversation