Differences between wide and long format datasets

For the most part, long and wide format provide the same data, but is organized differently. The central difference is that wide format is set up for multilevel modeling, and long format provides more detailed information about each prompt. 

Please see the following chart which compares each format. 




Not organized for MLM

Organized for MLM

Shows prompt response lapse

Shows time between initiated prompts

Order in session

Prompts are in order in their columns

Shows prompt ID

Not included

Shows prompt Type

Not included

Shows prompt Label

Listed in column

Shows the prompt (Question)

Not included

Shows "Comments" which help identify the prompt instance

Not included


Please contact us with further questions about wide and long datasets. 

Have more questions? Submit a request