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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.