How can I create a new variable that has the highest freq across variables?

[at16]

Hello,

I need to create a new variable that contains the answer with the highest frequency across variables (SAS version 9.4). For example:

id  var

100 2

100 2

100 2

100 4

100 5

101 3

101 3

101 1

101 2

101 3

102 4

102 4

102 5

102 2

102 1

I want to add a new variable, so that:

id newvar

100 2

101 3

102 4

It seems like there should be a relatively simple answer, but can't seem to figure out. I can transpose to wide if that is better. Any advice will be great, thanks!

[pau13rown]

ods output onewayfreqs=test;

proc freq data=;

tables var;

by id;

run;

proc sort data=test;

by id descending frequency;

run;

proc sort data=test nodupkey;

by id;

run;

?

[at16]

Thank you!

[novinosrin]

data have;
input id  var;
cards;
100 2
100 2
100 2
100 4
100 5
101 3
101 3
101 1
101 2
101 3
102 4
102 4
102 5
102 2
102 1
;

proc freq data=have order=freq noprint;
by id;
tables var/out=temp(drop=percent);
run;

data want;
set temp;
by id;
if first.id;
run;

[at16]

Thank you for your help!

[Andygray]

@at16 I meant mark the one of the above  contributors who gave you the solution. lol

[Andygray · Accepted solution]

@at16 You could mark one of the two solutions that you intend to use as accepted and close the thread.