A question about working with SAS datasets

Reply
Contributor
Posts: 62

A question about working with SAS datasets

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?

PROC Star
Posts: 7,474

Re: A question about working with SAS datasets

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

Respected Advisor
Posts: 4,925

Re: A question about working with SAS datasets

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

PG
Ask a Question
Discussion stats
  • 2 replies
  • 183 views
  • 3 likes
  • 3 in conversation