Creating multiple rows per id variable

[costasRO]

Hello all,

I have a dataset that looks like this

ID Year

A   1990

B   1990

.        .

Z  1990

A 1991

B 1991

etc

I would like to repeat each ID-Year row N times. So say N=2 the data i want to have should be like:

ID Year

A   1990

A 1990

B   1990

B 1990

.        .

Z  1990

Z 1990

A 1991

A 1991

B 1991

B 1991

etc

Please also note that I actually need N to be a larger number, i only used 2 here to illustrate.

many thanks

Costas

[PeterClemmensen · Accepted solution]

data have;
input ID $ Year;
datalines;
A 1990 
B 1990 
Z 1990 
A 1991 
B 1991 
;

%let n = 2;

data want;
   set have;
   do _N_ = 1 to &n.;
      output;
   end;
run;

[costasRO]

Thank you!