Fluorite | Level 6

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Quartz | Level 8

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

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

6 REPLIES 6
Lapis Lazuli | Level 10

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

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;

?

Fluorite | Level 6

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

Thank you!

Tourmaline | Level 20

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

``````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;

``````
Fluorite | Level 6

Quartz | Level 8

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

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

Quartz | Level 8

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

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

Discussion stats
• 6 replies
• 1129 views
• 2 likes
• 4 in conversation