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?
Can you provide an example and the maximum value that n might have?
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.