topic Re: Need code to create a dummy variable in SAS Programming

Need code to create a dummy variable

shalmali — Thu, 13 Mar 2014 01:06:25 GMT

Hi All,

I need your help. I am trying to create a variable "Change" that takes value 1 for years after the CEO change. The information I have includes TIC (firm identifier), YEAR, and CEO. For instance,

TIC YEAR CEO

A 2005 Frank

A 2006 Frank

A 2007 TOD

A 2008 TOD

A 2009 TOD

The output I am trying to get is:

TIC YEAR CEO CHANGE

A 2005 Frank 0

A 2006 Frank 0

A 2007 TOD 1

A 2008 TOD 1

A 2009 TOD 1

I would appreciate if someone share with me the right code.

Thank you

Re: Need code to create a dummy variable

RichardinOz — Thu, 13 Mar 2014 02:07:47 GMT

You state "variable "Change" that takes value 1 for years after the CEO change" but in your example the variable persists for the next 2 years. Please confirm which is your requirement.

Richard.

Re: Need code to create a dummy variable

PGStats — Thu, 13 Mar 2014 02:10:13 GMT

A DO UNTIL loop will do the trick:

data have;

input TIC $ YEAR CEO$;

datalines;

A 2005 Frank

A 2006 Frank

A 2007 TOD

A 2008 TOD

A 2009 TOD

;

data want;

nCEO = 0;

do until (last.TIC);

set have; by TIC CEO notsorted;

nCEO + first.CEO;

CHANGE = nCEO > 1;

output;

end;

drop nCEO;

run;

proc print data=want noobs; run;

Re: Need code to create a dummy variable

shalmali — Thu, 13 Mar 2014 02:11:09 GMT

Hello Richard,

I would like the output as I showed above. That is, "CHANGE" should be 1 for 2007 (the year of change) and years after that (2008, 2009).