topic Create consecutive years before and after a year in SAS Programming

Create consecutive years before and after a year

mandyosu01 — Wed, 10 Jun 2020 18:38:27 GMT

Hello SAS users,

I want to create a dataset that shows three years before and two years after a certain year for each of the observations in my sample. Also there are some overlapped years in newly created column, and I need to keep all overlap years presented separately.

Data have:

Company	Year
A	2000
A	2001
B	1998

Data want:

Company	Year	New
A		1997
A		1998
A		1999
A	2000	2000
A		2001
A		2002
A		1998
A		1999
A		2000
A	2001	2001
A		2002
A		2003
B		1995
B		1996
B		1997
B	1998	1998
B		1999
B		2000

Thank you so much in advance!

Re: Create consecutive years before and after a year

smantha — Wed, 10 Jun 2020 18:49:03 GMT

data Final;

set input_data;

start_yr=year-3;

end_yr=year+2;

year2=year;

do new = start_yr to end_yr;

 if year != new then year=year2;

 else year=' ';

 output;

end;

drop year2 start_yr end_yr;

run;

Re: Create consecutive years before and after a year

r_behata — Wed, 10 Jun 2020 19:18:01 GMT

Data have;
	input Company $	Year;
	cards;
A 2000
A 2001
B 1998
;
run;

data want(rename=(year_=year));
	set have;

	do new=(Year-3) to (year +2);
		if new=year then
			year_=year;
		else year_=.;
		output;
	end;

	drop year;
run;

Re: Create consecutive years before and after a year

PGStats — Wed, 10 Jun 2020 19:30:39 GMT

Adapted from @r_behata :

Data have;
input Company $	Year;
datalines;
A 2000
A 2001
B 1998
;

data want(rename=(year=_year));
set have;
do new = _year-3 to _year +2;
	if new = _year 
		then year = _year;
		else call missing(year);
	output;
    end;
drop _year;
run;