Please refer the solution below . Proc transpose data=final out=a; by phone_type; var phone number; run; Proc transpose data=a out=b (drop-_name_) ; var coll col2 col3 col4>>add all colums created; id phone type; run; If any doubts plz reach out me on LinkedIn http://linkedin.com/in/mayur-chaudhari-77010821b ... View more