the below is the data set. and i need to compute the countries which have highest and lowest Amount
so anyone can help me
and another question is to create a report to have Country wise Category based sum of Amount
First do a proc Means to get your totals into an output data set
proc means data=product sum;
class country;
var amount;
output out=summary(where=(_type_=1)) sum=total;
run;
Then to get the maximum and minimum
proc sql;
select country, total
from summary
having total=max(total) or total=min(total);
quit;
A simple report can be generated with Proc Print
proc print data=summary;
var country total;
title "Country Totals";
run;
Of course much more elaborate reports can be produced with SAS but as you give no further details I've just shown the simplest method 🙂
Without having opened your data, do something like this and adjust the class variables to your liking.
proc means data=product sum;
class Country;
var Amount;
run;
i want which country has the highest amount n lowest amount
i tried sorting the data set and display the first obs which is the lowest n last obs
First do a proc Means to get your totals into an output data set
proc means data=product sum;
class country;
var amount;
output out=summary(where=(_type_=1)) sum=total;
run;
Then to get the maximum and minimum
proc sql;
select country, total
from summary
having total=max(total) or total=min(total);
quit;
A simple report can be generated with Proc Print
proc print data=summary;
var country total;
title "Country Totals";
run;
Of course much more elaborate reports can be produced with SAS but as you give no further details I've just shown the simplest method 🙂
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!
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.