Help using Base SAS procedures

How do I figure out an average margin of points between two datasets?

Reply
New Contributor
Posts: 2

How do I figure out an average margin of points between two datasets?

Hi, I have two datasets and I have the points earned and the points given up for a list of sports teams. I want to find out the highest margin between points earned-points given up.

For example, if it was like this:

TeamPoints EarnedPoints Given up
Lions2010
Ravens3021
Broncos305

Then we would know the Broncos had the highest margin. How do I write a formula for this?

Any assistance would be greatly appreciated!!

Trusted Advisor
Posts: 1,204

Re: How do I figure out an average margin of points between two datasets?

data have;
input team $ points_earned points_give;
cards;
Lions 20 10
Ravens 30 21
Broncos 30 5
;

proc sql;
select * from have
having points_earned-points_give=max(points_earned-points_give);
quit;

Super Contributor
Posts: 305

Re: How do I figure out an average margin of points between two datasets?

Hello,

data have;
input  Team $ Points_Earned Points_Given_up ;
datalines;
Lions 20 10
Ravens 30 21
Broncos 30 5
Tigers 80 75
Baggers 80 55
;

data want (drop=i dif record) ;

length record $ 30;

do until(last);
set have end=last;
i+1;

if dif <Points_Earned-Points_Given_up then
do;
  dif=Points_Earned-Points_Given_up;
  record=i;
end;
else if dif=Points_Earned-Points_Given_up then
record=cats(i,"|",record);
end;


i=1;
if find(record,"|") then
do while (not(missing(scan(record,i,"| "))));
  acces=input(scan(record,i,"|"),8.);
  set have point=acces;
  output;
  i=i+1;
end;
else
do;
  acces=input(compress(record),8.);
  set have point=acces;
output;
end;
run;

Ask a Question
Discussion stats
  • 2 replies
  • 163 views
  • 0 likes
  • 3 in conversation