Help using Base SAS procedures

Proc transpose

Reply
Frequent Contributor
Posts: 120

Proc transpose

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
Super Contributor
Posts: 275

Re: Proc transpose

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

Re: Proc transpose

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;

Ask a Question
Discussion stats
  • 2 replies
  • 274 views
  • 0 likes
  • 3 in conversation