Transpose a DataSet by a UNIQUE Variable

[SNG1]

Hi All,

I am bit new to SAS, I searched the boards but could not find an answer to the dilemma I am facing -

I have a SAS Data Set that looks like the attached picture, as you can see that Once address could have multiple phone numbers and/or multiple First Name. I am trying to transpose this data do I can see it something like this (as headings and then the data underneath) -

Address    First Name1    First Name2    FirstName...n    Phone1    Phone2     Phone3     Phone4    Phone...n

For Example for  first two records, I would like to see:

1 52 2 Niagara     Menzies Justin    Menzies Justin    5198450640     5198451608

if there are multiple names or phone numbers then a extra column gets added for each...

Any help is much appreciated....Thanks!

[Reeza]

You're transposing multiple varialbes so you'll need to eitehr:

1. Use an ARRAY() https://stats.idre.ucla.edu/sas/modules/reshaping-data-long-to-wide-using-the-data-step/

2. Use multiple PROC TRANSPOSE and merge the results. https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

The latter is usually easier if you're a beginner. 

There's a macro called 'A Better Way to Flip" and you can use that to get what you want as well. 

http://www.sascommunity.org/wiki/A_Better_Way_to_Flip_(Transpose)_a_SAS_Dataset

---

@SNG1 wrote:

Hi All,

I am bit new to SAS, I searched the boards but could not find an answer to the dilemma I am facing -

I have a SAS Data Set that looks like the attached picture, as you can see that Once address could have multiple phone numbers and/or multiple First Name. I am trying to transpose this data do I can see it something like this (as headings and then the data underneath) -

Address    First Name1    First Name2    FirstName...n    Phone1    Phone2     Phone3     Phone4    Phone...n

For Example for  first two records, I would like to see:

1 52 2 Niagara     Menzies Justin    Menzies Justin    5198450640     5198451608

if there are multiple names or phone numbers then a extra column gets added for each...

Any help is much appreciated....Thanks!

---

[SNG1]

Thanks...worked perfect