topic Re: how to stack variables in different columns? in SAS Procedures

how to stack variables in different columns?

Ramgem — Mon, 13 Oct 2014 09:48:57 GMT

I have a data table that consists of customers ID's and their telephone numbers in the following manner:

Which function enables me to have the following format :

Customer ID	telephone number 1	telephone number 2
5550	9613456789	9613657894
6758	9611567854	.

Thank you in advance for all your help

RamKumar — Mon, 13 Oct 2014 10:01:41 GMT

Have a look at proc transpose.

Loko — Mon, 13 Oct 2014 10:28:54 GMT

Hello,

data have;
input Customer_ID telephone_number $;
datalines;
5550 9613456789
5550 9613657894
6758 9611567854
;

proc transpose data=have out=want(drop=_name_) prefix=Telephone;
by Customer_ID;
var telephone_number;
run;

Ramgem — Mon, 13 Oct 2014 12:34:07 GMT

Thank you that was very helpfull