Delete IDs with less than 3 observations

[YoLohse]

Hi 

I have a panel data set where each individual has a unique 'RunnerID'. I want to remove all the IDs that have less than 3 observations from my data set

Hope you guys can help, thanks!

[novinosrin]

Please post samples data of what you HAVE and the expected OUTPUT(WANT) for your input. I mean a few records

[YoLohse]

The data I have looks like this, the data lines I want to keep are the yellow ones

[PeterClemmensen · Accepted solution]

Do something like this

data have;
input RunnerID var;
datalines;
1 1
1 2
1 3
1 4
2 5
2 6
;

proc sql;
   create table want as
   select *
   from have
   group by RunnerID
   having count(RunnerID) ge 3;
quit;

[YoLohse]

Thanks man, just what i needed!

[ballardw]

Here is an example of one way using SASHELP.CLASS data.

Proc freq data=sashelp.class noprint;
   tables age /out=work.agecount (where=(count>3));
run;

proc sql;
   create table want as
   select b.* 
   from work.agecount as a
        left join
        sashelp.class as b
        on a.age=b.age
   ;
quit;

"RunnerID would take the place of the variable Age in the above code. Obviously your data set would replace SASHELP.CLASS.