topic Re: Take the top two scores in New SAS User

Take the top two scores

Mick_lb — Wed, 29 Jan 2020 09:14:33 GMT

Hello everyone,

I have a table containing one satisfaction score on three criteria for several individuals.

My table is presented as follows :

Note_A / Note_B / Note_C

10 12 14

16 14 8

15 16 12

......

I want to create two new columns "Max_note_1" and "Max_note_2" that take the two highest scores for each person.

How can I do this ?

Thank you in advance for your help !

Best regards,

Re: Take the top two scores

ed_sas_member — Wed, 29 Jan 2020 09:26:21 GMT

Hi @Mick_lb

You can use the LARGEST() function that returns the xth largest non-missing value.

best,

data have;
	input Note_A Note_B Note_C;
	datalines;
10 12 14
16 14 8
15 16 12
;
run;

data want;
	set have;
	Max_note_1 = largest(1, Note_A, Note_B, Note_C);
	Max_note_2 = largest(2, Note_A, Note_B, Note_C);
run;

Re: Take the top two scores

PeterClemmensen — Wed, 29 Jan 2020 09:29:43 GMT

I assume that each observation is one person?

In that case, use the Largest function

data have;
input Note_A Note_B Note_C;
datalines;
10 12 14
16 14 8
15 16 12
;

data want;
    set have;
    Max_note_1 = max(of Note:);
    Max_note_2 = largest(2, of Note:);
run;