topic A question about working with SAS datasets in SAS Programming

A question about working with SAS datasets

viollete — Mon, 17 Dec 2012 23:02:11 GMT

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?

Re: A question about working with SAS datasets

art297 — Mon, 17 Dec 2012 23:36:28 GMT

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

Re: A question about working with SAS datasets

PGStats — Tue, 18 Dec 2012 01:35:13 GMT

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;