Creating a subsample from the existing sample

shalmali — Tue, 25 Nov 2014 18:57:20 GMT

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,

Re: Creating a subsample from the existing sample

Reeza — Tue, 25 Nov 2014 19:39:45 GMT

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;

Re: Creating a subsample from the existing sample

shalmali — Tue, 25 Nov 2014 22:12:44 GMT

Thank you for the prompt reply.

topic Re: Creating a subsample from the existing sample in SAS Programming

Creating a subsample from the existing sample

Re: Creating a subsample from the existing sample

Re: Creating a subsample from the existing sample