topic Repeating records based on a numeric variable in SAS Enterprise Guide

Repeating records based on a numeric variable

DDawaba — Tue, 09 May 2023 09:34:54 GMT

For the below table, I need the first combination of "A, 194 and 2" to be duplicated or repeated 23 times and the second combination to be duplicated or repeated 14 times.

This code worked on another example but failed on this one. Any help?

do _N_= 1 to Domain;

output; end;

Error: "Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero,
or invalid."

NAME	BR_CODE	BKT	Domain
A	194	2	23
A	194	3	14
A	194	4	8

Repeated 23 times...

	BR_CODE	BKT	Domain
A	194	2	23
A	194	2	23
A	194	2	23
A	194	2	23
A	194	2	23
A	194	2	23
A	194	2	23
A	194	2	23
A	194	2	23
A	194	2	23
A	194	2	23
A	194	2	….
A	194	2	….
A	194	2	….
A	194	2	….

Re: Repeating records based on a numeric variable

PeterClemmensen — Tue, 09 May 2023 09:38:08 GMT

I suspect this happens because Domain = . in one of the obs. Try this

data have;
input NAME $ BR_CODE BKT Domain;
datalines;
A 194 2 23 
A 194 3 14 
A 194 4 8  
A 194 4 .  
;

data want;
   set have;
   do _N_ = 1 to max(Domain, 0);
      output;
   end;
run;

Re: Repeating records based on a numeric variable

DDawaba — Tue, 09 May 2023 12:22:49 GMT

Yes! Thanks.
The variable contained (.)