topic Re: Going from long file to wide file in SAS Programming

Going from long file to wide file

Walternate — Fri, 01 Apr 2022 20:17:44 GMT

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!

Re: Going from long file to wide file

PaigeMiller — Fri, 01 Apr 2022 20:23:42 GMT

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.

Re: Going from long file to wide file

Rick_SAS — Sat, 02 Apr 2022 10:50:36 GMT

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

Re: Going from long file to wide file

mkeintz — Sat, 02 Apr 2022 14:58:16 GMT

Please help us help you.

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
Do the same with the desired output layout.