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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.