BookmarkSubscribeRSS Feed
cindyforest7
Calcite | Level 5


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,

2 REPLIES 2
stat_sas
Ammonite | Level 13

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;

PGStats
Opal | Level 21

In SAS 9.4 at least, you can ask for METHOD=SQEUCLID to get squared distances. - PG

PG
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1356 views
  • 0 likes
  • 3 in conversation