For this example, we simply want to identify the three closest zip codes for each mailing address in the marketing campaign, so let's use the TRANSPOSE procedure to create three new columns in our data set (and in the process turn 'Zip_A' into our primary key): proc transpose data = ...