Panel data:trim data based on dummy values

[namrata]

I have created a dummy 0/1 against years prior to an event and after an event.

I want to delete firms that have  dummy=0 less than 2 times and dummy=1 less than 3 times.

Is it possible to combine both the conditions?

The code below is wrong but what should be be corrected below?

proc sql;

create table want as

select dummy,count(dummy=0) as count1

select dummy,count(dummy=1) as count2

  from have

   group by gvkey having calculated count1 gt 2 & count2 gt 3 ;

quit;

[Linlin]

try:

data have;

  input firm dummy;

  cards;

  1 0

  1 1

  1 0

  1 0

  1 1

  1 1

  2 0

  2 1

  3 0

  3 0

  3 0

  ;

proc sql;

  create table  want as

    select firm

           ,sum(dummy=0) as  c1

          ,sum(dummy=1) as c2

   from have

     group by firm

  having c1>1 and c2>2;

quit;

proc print;run;

Linlin