topic Re: SAS Equivalent of Excel Max if Statement in SAS Procedures

SAS Equivalent of Excel Max if Statement

Olaajay — Thu, 29 Oct 2015 21:46:16 GMT

Please I need assistance:

I have

Data ABC;

X Y

2 a

1 a

4 b

3 b

;

I want maximum of X for each of Y (maximum based on criteria).

so output would be

NEW

X Y

2 a

4 b

Thanks in advance!

Re: SAS Equivalent of Excel Max if Statement

hbi — Thu, 29 Oct 2015 21:51:25 GMT

Try this:

DATA ABC;
  x=2; y='a'; output;
  x=1; y='a'; output;
  x=4; y='b'; output;
  x=3; y='b'; output;
RUN;

PROC SQL;
  CREATE TABLE want AS 
  SELECT max(x) as max_x, y
  FROM ABC
  GROUP BY y;
QUIT;

Re: SAS Equivalent of Excel Max if Statement

PGStats — Thu, 29 Oct 2015 21:54:00 GMT

The simplest way is:

proc sql;
create table NEW as
select max(X) as X, Y
from ABC
group by Y;
quit;

Re: SAS Equivalent of Excel Max if Statement

ballardw — Thu, 29 Oct 2015 22:17:50 GMT

If result not appearance is acceptable:

proc means data=have max;
class y;
var x;
run;

I would recommend becoming familiar with the procs such as means as I can add large number of statistics such a min, median, mean, standard deviation, range, skewness, kurtosis, a number of percentiles and such by adding them to the list where MAX appears above.

Re: SAS Equivalent of Excel Max if Statement

Olaajay — Thu, 29 Oct 2015 23:27:55 GMT

Thank you all! I just used the first solution given and it worked, I appreciate your help!