topic Panel data:trim data based on dummy values in SAS Procedures

Panel data:trim data based on dummy values

namrata — Sat, 21 Jul 2012 05:58:48 GMT

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 — Sat, 21 Jul 2012 11:33:41 GMT

try:

data have;

input firm dummy;

cards;

1 0

1 1

1 0

1 1

2 0

2 1

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