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 🙂
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.