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
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;
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;
Thank you for the prompt reply.
S
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.