topic Re: How to create sas views with more records? in SAS Data Science

How to create sas views with more records?

PravinMishra — Thu, 04 Aug 2016 15:13:11 GMT

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?

Re: How to create sas views with more records?

ballardw — Thu, 04 Aug 2016 15:26:59 GMT

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;