Differences between wide and long format datasets

While long and wide format datasets provide most of the same data, they are configured differently. The central difference is that wide format datasets are set up for multilevel modeling (MLM), and long format datasets provide more detailed information about each prompt.

The following chart compares each format:




Not organized for MLM 

Organized for MLM 

Shows Prompt Response Lapse 

Shows time between prompts 

Provides prompt order in session 

Prompts are listed from left to right in the order they were presented unless ordering was randomized 

Shows Prompt ID 

Doesn’t show Prompt ID 

Shows Prompt Type 

Doesn’t show Prompt Type 

Shows Prompt Label 

Prompt Label is listed in column heading 

Shows the Prompt (Question) 

Doesn’t show the Prompt (Question) 

Shows "Comments" which help identify the prompt instance 

Doesn’t provide “Comments” 


Have more questions? Submit a request