topic Re: help with the code in SAS Programming

help with the code

pk2012 — Mon, 08 Oct 2012 22:36:01 GMT

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.

Re: help with the code

Linlin — Mon, 08 Oct 2012 23:33:59 GMT

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;

Re: help with the code

pk2012 — Mon, 08 Oct 2012 23:43:03 GMT

Thank you Linlin.