DATA Step, Macro, Functions and more

Using DO Loop to create a new dataset with 5 times more records

Reply
Contributor
Posts: 42

Using DO Loop to create a new dataset with 5 times more records

Dear All,

I would like to use Do Loop to create a new dataset with 5 times more records than Table(5*5 - Total 25 Records (Inside Do using SET Statement). Is it Possible ?

Appreciate for the help.

Regards,

S Ravuri.

Frequent Contributor
Posts: 139

Using DO Loop to create a new dataset with 5 times more records

Posted in reply to sambasiva_ravuri_tcs_com

Pleaae give the example of input and output.

thanks

Respected Advisor
Posts: 3,156

Using DO Loop to create a new dataset with 5 times more records

Posted in reply to sambasiva_ravuri_tcs_com

if your "5 times more records" means adding same record repeatly, is this what you want?

data have;

do i=1 to 3;

   output;

end;

run;

data want;

   set have;

     do _n_=1 to 5;

output;

end;

  run;

  proc print;run;

Regards,

Haikuo

Ask a Question
Discussion stats
  • 2 replies
  • 226 views
  • 0 likes
  • 3 in conversation