Creating a subsample from the existing sample

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 96
Accepted Solution

Creating a subsample from the existing sample

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


Accepted Solutions
Solution
‎11-25-2014 02:39 PM
Super User
Posts: 19,167

Re: Creating a subsample from the existing sample

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;

View solution in original post


All Replies
Solution
‎11-25-2014 02:39 PM
Super User
Posts: 19,167

Re: Creating a subsample from the existing sample

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;

Frequent Contributor
Posts: 96

Re: Creating a subsample from the existing sample

Thank you for the prompt reply.

S

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 301 views
  • 0 likes
  • 2 in conversation