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