topic New user - Help with changing column values into row values in SAS Health and Life Sciences

New user - Help with changing column values into row values

sasusername — Thu, 24 Jan 2013 23:41:56 GMT

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

Re: New user - Help with changing column values into row values

Linlin — Thu, 24 Jan 2013 23:57:57 GMT

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

Re: New user - Help with changing column values into row values

sasusername — Mon, 28 Jan 2013 15:44:56 GMT

Thanks.