topic Re: How to get the Max columns ? in SAS Programming

How to get the Max columns ?

Midi — Wed, 25 Sep 2019 09:07:46 GMT

Hello Everyone , i'm new with SaS , and i have this dataset :

User	Orders	Fam	Size
2563	1542	66	4
2563	2251	66	5
2563	1544	66	6
2563	2222	28	2
2563	2335	28	1

AND i want to get the maximum of the size for each user , like the output would be like this :

User	fam_Max	Szie_Max
	66	6
2563	28	2

Can anyone give me hand ? , that would be great , thank you.

Re: How to get the Max columns ?

PeterClemmensen — Wed, 25 Sep 2019 09:13:17 GMT

One way

data have;
input User Orders Fam Size;
datalines;
2563 1542 66 4
2563 2251 66 5
2563 1544 66 6
2563 2222 28 2
2563 2335 28 1
;

proc summary data=have nway;
    class fam;
    var Size;
    output out=want(drop=_:) max=;
run;

Re: How to get the Max columns ?

sustagens — Mon, 30 Sep 2019 06:42:13 GMT

The sample output you provided doesn't really get the maximum size for each User, but for each Fam.

Here is code to achieve the same output:

proc sql;
create table want as(
select distinct a.User
,max(a.Fam) as Max_of_Fam
,max(a.Size) as Max_of_Size 
from have a
group by a.Fam
);
quit;

If you want the maximum size for each User:

proc sql;
create table want as(
select a.User
,max(a.Fam) as Max_of_Fam
,max(a.Size) as Max_of_Size 
from have a
group by a.User
);
quit;

Re: How to get the Max columns ?

Midi — Mon, 30 Sep 2019 09:27:20 GMT

Thank You.