topic Re: SAS Proc Means for Choosing Max Value in SAS Programming

SAS Proc Means for Choosing Max Value

Zozo1998 — Tue, 11 Jan 2022 17:55:01 GMT

Hi,

I have this dataset, where Col A could have a repeating value (e.g. 990).

I would like the dataset to look like this (select for highest value of '990' so =3)

I tried this code that I found on SAS communities (and a few other variations of it):

proc means data=sashelp;

class record_id ColA;

var ColB;

output out=want max(ColB)=ColB;

run;

I ended up getting this output where instead of sas giving me the highest value, I got the average of the values of 990.

How do I fix it so that SAS gives me only the highest value for a repeating observation instead of the average?

Thanks in advance!

Re: SAS Proc Means for Choosing Max Value

sbxkoenk — Tue, 11 Jan 2022 18:03:25 GMT

That's easy

, but can you provide us with your (sample) data by means of a data step with datalines (cards) statement?
We cannot code against a picture.
When pasting your SAS code (the requested data step), use the running man icon in the toolbar.

Thanks,

Koen

Re: SAS Proc Means for Choosing Max Value

PaigeMiller — Tue, 11 Jan 2022 18:06:25 GMT

@Zozo1998 wrote:

Hi,

I have this dataset, where Col A could have a repeating value (e.g. 990).

I would like the dataset to look like this (select for highest value of '990' so =3)

I tried this code that I found on SAS communities (and a few other variations of it):

proc means data=sashelp;

class record_id ColA;

var ColB;

output out=want max(ColB)=ColB;

run;

I ended up getting this output where instead of sas giving me the highest value, I got the average of the values of 990.

How do I fix it so that SAS gives me only the highest value for a repeating observation instead of the average?

Thanks in advance!

What is the format on variable ColB, according to PROC CONTENTS?

Re: SAS Proc Means for Choosing Max Value

sbxkoenk — Tue, 11 Jan 2022 18:07:21 GMT

Hello,

This code should do the trick, but records are not returned in same order.

proc sort data=work.have out=work.want0;
 by record_id ColA descending ColB;
run;

data work.want1;
 set work.want0;
 by record_id ColA descending ColB;
 if first.ColA then output;
run;
/* end of program */

Koen

Re: SAS Proc Means for Choosing Max Value

Zozo1998 — Sat, 15 Jan 2022 16:37:19 GMT

Re: SAS Proc Means for Choosing Max Value

PaigeMiller — Sat, 15 Jan 2022 21:09:59 GMT

Its fine that you have marked the answer as correct, as I'm sure it is correct.

But, there's no reason that PROC MEANS won't give you the correct maximum either ... and so again I conclude that there's something going in your specific data that you haven't told us about (and maybe it is something you aren't even aware of), and again I suspect you have formatted the variable somehow.

For anyone else reading along, PROC MEANS ought to do the job properly.