Dear Friends,
I have a data which has a firm identier and a dummy variable SOX. Although most of the firms in my sample have both 0 and 1 values for SOX, some firms have only 0 or 1 value for SOX. I want to delete firms that do not have both 0 or 1 for SOX.
Firm SOX
A 0
A 1
B 0
B 1
C 0
D 0
D 1
E 1
Expected Output
Firm SOX
A 0
A 1
B 0
B 1
D 0
D 1
I would appreciate if someone would provide me with the code.
Thank you.
data have;
input Firm $ SOX;
cards;
A 0
A 1
B 0
B 1
C 0
D 0
D 1
E 1
;
data want;
set have;
by firm;
if first.firm and last.firm then delete;
run;
proc print;run;
data have;
input Firm $ SOX;
cards;
A 0
A 1
B 0
B 1
C 0
D 0
D 1
E 1
;
data want;
set have;
by firm;
if first.firm and last.firm then delete;
run;
proc print;run;
Thank you Linlin.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.