topic Re: Proc transpose in SAS Procedures

Proc transpose

chennupriya — Fri, 20 Nov 2015 21:37:40 GMT

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

Re: Proc transpose

slchen — Fri, 20 Nov 2015 21:56:00 GMT

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

Re: Proc transpose

Steelers_In_DC — Fri, 20 Nov 2015 22:04:51 GMT

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;