topic creation of new variable in SAS Programming

creation of new variable

shalmali — Sun, 02 Sep 2012 23:18:43 GMT

I am trying to create a variable from the following dataset.

Company year OUT

A 2001 0

A               2002     0
A               2003     0
A               2004     1
A               2005     0
A               2006     0
A               2007     0
A               2008     0
B               2000     0
B               2001     0
B               2002     0
B               2003     1

B 2004 0

B 2005 0

B 2006 0

B 2007 0

B 2008 0

B 2009 0

I want to create a new variable NEW for all firm-observations where OUT =1 and year less than 2009.

Company year OUT NEW

A 2001 0 1

A               2002     0          1
A               2003     0          1
A               2004     1          1
A               2005     0          1
A               2006     0          1
A               2007     0          1
A               2008     0          1
B               2000     0          0
B               2001     0          0
B               2002     0          0
B               2003     1          0

B 2004 0 0

B 2005 0 0

B 2006 0 0

B 2007 0 0

B 2008 0 0

B 2009 0 0

Any suggession will be helpful.

Re: creation of new variable

PGStats — Mon, 03 Sep 2012 00:04:09 GMT

Simpler this time, if I understand your request correctly :

data have;
input Company $ year OUT;
datalines;
A               2001                    0
A               2002                    0
A               2003                    0
A               2004                    1
A               2005                    0
A               2006                    0
A               2007                    0
A               2008                    0
B               2000                    0
B               2001                    0
B               2002                    0
B               2003                    1
B               2004                    0
B               2005                    0
B               2006                    0
B               2007                    0
B               2008                    0
B               2009                    0
;

proc sql;

create table want as
select *, max(OUT) > 0 and max(year) < 2009 as NEW
from have
group by company
order by company, year;

select * from want;
quit;

Re: creation of new variable

shalmali — Mon, 03 Sep 2012 00:06:24 GMT

Thanks PGstats for the prompt solution.