topic Create sequential years in SAS Procedures

Create sequential years

dapenDaniel — Fri, 13 Apr 2018 02:58:29 GMT

I have some IDs as following below.

I would like to create a panel table for these ID. The expected panel data is as following below.

ID Year

1 1990

1 1991

1 1992

2 1990

2 1991

2 1992

Can anyone tell me how I can add the year? Thanks.

novinosrin — Fri, 13 Apr 2018 03:26:17 GMT

data have;
input id;
datalines;
1
2
3
;

data want;
set have;
do year=1990 to 1992;
output;
end;
run;

dapenDaniel — Fri, 13 Apr 2018 03:28:48 GMT

Thank you so much, novinosrin!!!