11-25-2011 07:04 AM
11-25-2011 10:48 AM
Since all you appear to want is the cartesian product of the two files, I would think that using proc sql would be the easiest way to get it. E.g.,
create table want as
11-26-2011 04:36 AM
Thanks for the reply, I can see how it would be possible with sql, though a bit complex.
Would still prefer to be able to compare each row of file1 with every row on file2.
The data would be from a survey on a 50 x 50 meter grid where file1 would contain two numerical
values x1 y1 where one unit represents 50m with the origin at say 0 0.
file2 would contain a grid x2 y2 with an origin of 25 by 25.
Rows in file1 represent points that cannot be accessed and need to be moved by a maximum radius
to a point on the second grid such that points from file1 will be allocated to points in file2 only once
and points in file2 will only be matched with a point from file1 once.
Both files could be in the thousands.