Hi All, I'm trying to create a product information table and would like to create a flat file of our supplies by distributors. There is a maximum of three suppliers per part number. Here is how our data is structured and what I want to do.. Part# 1 Manuf 1 Supplier 1 Part# 1 Manuf 1 Supplier 2 Part# 1 Manuf 1 Supplier 3 Part# 2 Manuf 2 Supplier 4 Part# 2 Manuf 2 Supplier 5 Part# 3 Manuf 3 Supplier 6 TO.. Part# 1 Manuf 1 Supp1 Supp2 Supp3 Part# 2 Manuf 2 Supp4 Supp5 Blank Part# 3 Manuf 3 Supp6 Blank Blank I just started using SAS and I'm slowly learning the code. Is this possible in SAS? Thanks for your help - J ... View more