Creating a subsample from the existing sample

[shalmali]

Hi All,

I am trying to divide the data set into two subset. The information that I have is as follows:

Firm     Year     High     Change

A          2000     0          0

A          2001     1          0

A          2002     1          0

A          2003     0          1

A          2004     0          0

B          2000     0          0

B          2001     1          0

B          2002     0          0

B          2003     1          1

B          2004     0          0

I want to divide this dataset into two subset: Subset 1 will have firms where High=1 when Change=1. Subset 2 is all other firms. For instance,

Subset 1 will be:

Firm     Year     High     Change

B          2000     0          0

B          2001     1          0

B          2002     0          0

B          2003     1          1

B          2004     0          0

Subset 2 will be:

Firm     Year     High     Change

A          2000     0          0

A          2001     1          0

A          2002     1          0

A          2003     0          1

A          2004     0          0

I would appreciate if someone help me with the coding.

Thanks,

S

[Reeza · Accepted solution]

proc sql;

create table subset1 as

select * from have

where firm in (select firm from have where high=1 and change=1);

quit;

proc sql;

create table subset2 as

select * from have

where firm not in (select firm from have where high=1 and change=1);

quit;

[shalmali]

Thank you for the prompt reply.

S