The SELECT clause specifies three columns: HOUSE, STORE, and DIST. The
arithmetic expression uses the square root function (SQRT) to create the values
of DIST, which contain the distance from HOUSE to STORE for each row. The
double asterisk (**) represents exponentiation. LABEL= assigns a label to
STORE and to DIST.
proc sql;
title 'Each House and the Closest Store';
select house, store label='Closest Store',
sqrt((abs(s.x-h.x)**2)+(abs(h.y-s.y)**2)) as dist
label='Distance' format=4.2
from stores s, houses h