topic Re: proc distance : maximum distances in SAS Programming

proc distance : maximum distances

SASdevAnneMarie — Mon, 20 Apr 2026 08:30:47 GMT

Hello Experts,

I'm applying the following code :

proc standard data=bdd_1 mean=0 std=1 out=bdd_2 _std_data;
run;

proc distance data= bdd_2 _std_data method=euclid out=distances;
	var interval (&var_all.);
	id LIB;
run;

How do I retrieve the 5 maximum distances? Thank you for your help !

Re: proc distance : maximum distances

Ksharp — Mon, 20 Apr 2026 09:25:51 GMT

data bdd_1;
 set sashelp.heart(obs=200);
 keep _numeric_;
run;

proc standard data=bdd_1 mean=0 std=1 out=bdd_2_std_data;
run;

proc distance data= bdd_2_std_data method=euclid out=distances;
	var interval (_numeric_);
run;



data temp;
set distances;
array x{*} _numeric_;
row=_n_;
do col=1 to _n_;
 distance=x{col};output;
end;
keep row col distance;
run;
proc sort data=temp out=want;
by descending distance;
run;

proc print data=want(obs=5) noobs;
run;

Re: proc distance : maximum distances

SASdevAnneMarie — Mon, 20 Apr 2026 17:35:07 GMT

Thank you, Ksharp!

Re: proc distance : maximum distances

FreelanceReinh — Tue, 21 Apr 2026 07:35:25 GMT

Hello @SASdevAnneMarie,

I'm sure you marked your own "thank you" post as the solution only by mistake. You can correct this easily: Select Ksharp's post as the solution after clicking "Not the Solution" in the option menu (see icon below) of the current solution.