New user - Help with changing column values into row values

[sasusername]

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

[Linlin]

using proc transpose:

data have;

  input (p m s)($);

  cards;

p1 m1 s1

p1 m1 s2

p1 m1 s3

p2 m2 s4

p2 m2 s5

p3 m3 s6

;

proc transpose data=have out=want(drop=_:) prefix=s;

by p m;

var s;

run;

proc print;run;

                        Obs    p     m     s1    s2    s3

                          1     p1    m1    s1    s2    s3

                          2     p2    m2    s4    s5

                          3     p3    m3    s6

[sasusername]

Thanks.