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
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;
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;
Thank you!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: