topic How can I create a new variable that has the highest freq across variables? in SAS Procedures

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

at16 — Mon, 11 Jun 2018 17:47:38 GMT

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 4

100 5

101 3

101 1

101 2

101 3

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!

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

pau13rown — Mon, 11 Jun 2018 17:59:03 GMT

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;

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

novinosrin — Mon, 11 Jun 2018 18:05:20 GMT

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;

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

at16 — Mon, 11 Jun 2018 18:12:00 GMT

Thank you!

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

at16 — Mon, 11 Jun 2018 18:12:43 GMT

Thank you for your help!

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

Andygray — Mon, 11 Jun 2018 18:14:42 GMT

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

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

Andygray — Mon, 11 Jun 2018 18:17:48 GMT

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