Hi all,
I have created a distance matrix using the following codes:
proc distance data=C02 out=dist method=Euclid;
var interval (pass_rate);
id contract_id;
run;
The distance metric is simply an absolute value of the difference between two pass rates. Now I want to square the difference for each single cell in the matrix, how I can do that?
Any input will be appreciated.
Thanks,
proc sql;
select distinct contract_id into :c separated by ' ' from dist;
quit;
data want;
set dist;
array ct{*} &c;
do i=1 to dim(ct);
ct{i}=(ct{i})**2;
end;
run;
proc print data=want;
run;
In SAS 9.4 at least, you can ask for METHOD=SQEUCLID to get squared distances. - 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.