topic Re: reading file random without point in SAS Programming

reading file random without point

rajeshm — Thu, 28 Aug 2014 11:25:58 GMT

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

have dataset:

ranks

want dataset:

ranks

Re: reading file random without point

data_null__ — Thu, 28 Aug 2014 11:43:51 GMT

set have have have;

Re: reading file random without point

Ksharp — Thu, 28 Aug 2014 12:11:36 GMT

And check some functions about it like fetchobs( ) .

Re: reading file random without point

RW9 — Thu, 28 Aug 2014 12:13:52 GMT

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.

Re: reading file random without point

stat_sas — Thu, 28 Aug 2014 19:37:06 GMT

One more way

proc sql;

select * from have

union all

select * from have

union all

select * from have;

quit;

Re: reading file random without point

PGStats — Thu, 28 Aug 2014 20:28:01 GMT

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

data want / view=want;

set have have have;

run;

Re: reading file random without point

Astounding — Thu, 28 Aug 2014 20:49:55 GMT

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;

run;

%mend silly;

%silly

Re: reading file random without point

RW9 — Fri, 29 Aug 2014 07:49:57 GMT

First rule of obfuscation club is...

Re: reading file random without point

rajeshm — Fri, 29 Aug 2014 09:41:04 GMT

sorry.

could u pls provide me the logic