creation of new variable

[shalmali]

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.

[PGStats · Accepted solution]

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;

PG

[shalmali]

Thanks PGstats for the prompt solution.