Manipulating a dataset

[alan0101]

Hi

I have a dataset that looks like this :

PersonId     Name     PhoneNumber

2                john          111   

2                john          222

3               mike          333

3               mike          444

3               mike          555

4               sue            666

4               sue            777

4               sue            888

4               sue            999

it needs to look like this :

PersonId     Name     PhoneNumber1     PhoneNumber2     PhoneNumber3     PhoneNumber4

2               john          111                         222                         -                         -

3               mike          333                         444                         555

4               sue           666                          777                         888                    999

Any ideas ?

[ballardw · Accepted solution]

proc transpose data=have out=want (drop=_name_) prefix=PhoneNumber;

by personid name;

var phonenumber;

run;

[alan0101]

Thanks - much appreciated !