topic Re: Creating multiple rows per id variable in SAS Programming

Creating multiple rows per id variable

costasRO — Wed, 29 Jun 2022 10:32:07 GMT

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

B 1990

. .

Z 1990

A 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

Re: Creating multiple rows per id variable

PeterClemmensen — Wed, 29 Jun 2022 10:41:32 GMT

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;

Re: Creating multiple rows per id variable

costasRO — Wed, 29 Jun 2022 11:15:35 GMT

Thank you!