Proc transpose

[chennupriya]

Hi ,

I have a dataset like in data a an dnow i want the dataset to look like in data b  

can anyone pls help

data a
customer	phone	phonetype
lori	12356	cellphone
lori	45623	homephone
lori	23687	workphone
datab
customer	cellphone	homephone	workphone
lori	12356	45623	23687

[slchen]

proc transpose data=have out=want(drop=_:);
by customer;
id phonetype;
var phone;
run;

[Steelers_In_DC]

here you go:

data have;
infile cards dsd;
input customer$     phone$     phonetype $10.;
cards;
lori,12356,cellphone
lori,45623,homephone
lori,23687,workphone
;

proc transpose data=have out=want (drop=_name_);by customer;id phonetype;var phone;