frequencies

[sophia_SAS]

Hi SAS community-

Below is a abbreviated version of an output from a proc freq.

ID         Frequency      Percent      and so on . . .

a          4                    0.40

b          2                    0.20

c          1                    0.10

d          1                    0.10

e          1                    0.10

f           1                    0.10

I would like to view only the IDs that have a frequency of 2 or more (therefore would exclude IDs 'c-f').

Please advise as to how I can do this procedure.

Thanks!

[Linlin]

example:

proc freq data =sashelp.class noprint;

  tables sex  / out=temp ;

  run;

data want;

  set temp;

  if count>9;

run;

[art297 · Accepted solution]

Or, just use a where statement to eliminate the ids that don't meet your criterion.  e.g.:

proc freq data=have;

  tables id/out=want (where=(count ge 2));

run;

[Linlin]

Thank you Art!  - Linlin