Going from long file to wide file

[Walternate]

Hi all, I have a long file with ID, time 1, and time 2. There can be multiple of the same ID in the file: Not sure whether it matters, but time1 and time2 are NOT sequential. Or rather, they could be but they are not measuring the same thing over time or anything like that so they could be identical, time1 > time2, or time2>time1. ID time1 time2 1 1 3 1 2 2 1 3 1 2 1 4 2 3 2 3 2 2 What I want is a file that is wide, ie, gives each set of time1 and time2 for a specific ID: ID time1_1 time2_1 time1_2 time2_2 time1_3 time2_3 1 1 3 2 2 3 1 2 1 4 3 2 3 2 2 As you can see, IDs can but don't necessarily have multiple records. The number of time pairings has no upper limit. Any help is much appreciated!

[PaigeMiller]

Please show us (a portion of) the data, as SAS data step code (instructions).

Also, could you explain why this wide format is necessary, what can you do better with a wide format compared to a long format.

[Rick_SAS]

There are many ways to convert data from a long form to a wide form in SAS.

• SAS provides "SAS Notes" that show how to convert from long to wide
• You can look at the %MAKEWISE macro, which is provided by Gerhard Svolba (@gsvolba) 
• You can post your data in the form of a DATA step and you'll get multiple other ways

[mkeintz]

Please help us help you.

1. Please make clear the arrangement of the data you have to start with, in the form of a working data step, as per the 
   instructions link provided by @PaigeMiller 
   
   
2. Do the same with the desired output layout.