How to create sas views with more records?

[PravinMishra]

HI,

I have a simple query regarding view creation. I have a table with 10 records. I want to create a view using this table. but I want my contains 100 records. I don't care if the records are duplicate.

means I want to fetch more records what is there in base data?

[ballardw · Accepted solution]

Since you know that you have 10 records and want 100 the easiest would be to duplicate each 10 times.

This datastep code will create 10 copies of each input record as a view.

data want/view=want;
   set have;
   do i=1 to 10;
   output;
   end;
   drop i;
run;