Need code to create a dummy variable

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 96
Accepted Solution

Need code to create a dummy variable

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

SS


Accepted Solutions
Solution
‎03-12-2014 10:10 PM
Respected Advisor
Posts: 4,651

Re: Need code to create a dummy variable

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;

PG

PG

View solution in original post


All Replies
Super Contributor
Posts: 644

Re: Need code to create a dummy variable

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.

Frequent Contributor
Posts: 96

Re: Need code to create a dummy variable

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).

SS

Solution
‎03-12-2014 10:10 PM
Respected Advisor
Posts: 4,651

Re: Need code to create a dummy variable

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;

PG

PG
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 181 views
  • 3 likes
  • 3 in conversation