topic Find out the countries which have highest and lowest Amount in SAS Programming

Find out the countries which have highest and lowest Amount

Karan_Dumbre — Wed, 06 Sep 2017 07:15:06 GMT

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

PeterClemmensen — Wed, 06 Sep 2017 07:55:23 GMT

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;

Karan_Dumbre — Wed, 06 Sep 2017 08:07:53 GMT

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

ChrisBrooks — Wed, 06 Sep 2017 08:19:03 GMT

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 🙂