reading file random without point

[rajeshm]

how to read observations from a dataset 3 times,how many ways(without point)

have dataset:

ranks

1

2

want dataset:

ranks

1

2

1

2

1

2

[data_null__ · Accepted solution]

set have have have;

[Ksharp]

And check some functions about it like   fetchobs( )  .

[RW9]

Can I check why?  It seems in your example you want a dataset with a 1, 2 combination 3 times.  There are better ways than creating one dataset and then appending that three times, do loops for instance, retain statement setting the value != previous etc.

[rajeshm]

sorry.

could u pls provide me the logic

[stat_sas]

One more way

proc sql;

select * from have

union all

select * from have

union all

select * from have;

quit;

[PGStats]

If you don't want to waste space, create a view:

data want / view=want;

set have have have;

run;

PG

[Astounding]

How silly are we allowed to get?  Why write something simple when you can confuse everybody with a macro?

%macro silly;

%local N i j;

data _null_;

   set have nobs=_total_obs_;

   call symputx ('N', _total_obs_);

run;
data want;

   %do i=1 %to 3;

      %do j=1 %to &N;

         set have (firstobs=&j obs=&j);

         output;

      %end;

   %end;

run;

%mend silly;

%silly

[RW9]

First rule of obfuscation club is...