topic Re: Delete IDs with less than 3 observations in SAS Data Management

Delete IDs with less than 3 observations

YoLohse — Thu, 21 Mar 2019 16:34:07 GMT

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!

Re: Delete IDs with less than 3 observations

novinosrin — Thu, 21 Mar 2019 16:35:32 GMT

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

Re: Delete IDs with less than 3 observations

PeterClemmensen — Thu, 21 Mar 2019 16:38:49 GMT

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;

Re: Delete IDs with less than 3 observations

YoLohse — Thu, 21 Mar 2019 16:40:00 GMT

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

Re: Delete IDs with less than 3 observations

ballardw — Thu, 21 Mar 2019 16:42:10 GMT

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.

Re: Delete IDs with less than 3 observations

YoLohse — Thu, 21 Mar 2019 16:43:41 GMT

Thanks man, just what i needed!