A question about working with SAS datasets

[viollete]

I have SAS dataset with 2 variables and n observations, from this dataset how can i create a new SAS dataset  with n variables and n observations, and every cell represent the ratio of these variables?

[art297]

Can you provide an example and the maximum value that n might have?

[PGStats]

Is this what you want?

data have;
input v1 v2;
datalines;
1 2
3 4
2 3
5 6
4 2
;

data h;
set have;
i = _n_;
run;

proc sql;
/* i and j are added in case there are duplicate consecutive v1 or v2 values */
create table ratios as
select a.v1, a.i as i, b.v2, b.i as j, a.v1/b.v2 as ratio
from h as a cross join h as b;
quit;

proc transpose data=ratios
out=want(drop=_name_) delimiter=_;
by v1 i notsorted;
id j v2;
var ratio;
run;

PG