topic frequencies in SAS Procedures

frequencies

sophia_SAS — Tue, 27 Mar 2012 18:12:01 GMT

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 — Tue, 27 Mar 2012 19:08:28 GMT

example:

proc freq data =sashelp.class noprint;

tables sex / out=temp ;

run;

data want;

set temp;

if count>9;

run;

art297 — Tue, 27 Mar 2012 19:14:10 GMT

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 — Tue, 27 Mar 2012 19:27:30 GMT

Thank you Art! - Linlin