I have a list of medical providers which includes their name, address, city zip, phone, and fax information in a different column, something like this: Practice_Name Address_1 City ZIP OfficeA 123 Main St Denver 80202 OfficeB 841 20th St Denver 80012 OfficeC 425 Fern Ave Denver 80202 What I want is to have these practices listed by ZIP code, arranged as such: ZIP Practice1 Address1 City1 Practice 2 Address2 City2 80202 OfficeA 123 Main St Denver OfficeC 425 Fern Ave Denver 80012 OfficeB 841 20th St Denver When I try a PROC TRANSPOSE: PROC TRANSPOSE Data=B out=C
PREFIX=Site;
By Zip;
VAR Address_1 Address_2 Phone Fax;
run; I get this How do I code this so that the multiple attributes of each provider are their own column?
... View more