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 🙂
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.