Take the top two scores

[Mick_lb]

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, 

[ed_sas_member]

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;

[PeterClemmensen]

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;