Help using Base SAS procedures

Panel data:trim data based on dummy values

Reply
Contributor
Posts: 52

Panel data:trim data based on dummy values

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;

Super Contributor
Posts: 1,636

Re: Panel data:trim data based on dummy values

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

Ask a Question
Discussion stats
  • 1 reply
  • 142 views
  • 0 likes
  • 2 in conversation