Generally you want to use long format rather than wide format. So each observation is a case/row rather than each higher order unit.

e.g., Assuming nesting of children in classrooms in a two-level model

child_id class_id x1 dv

1 1. 7.6. 9.1

2 1. ... ...

3 1

4 1

5 1

6 1

7 1

8 2

9 2

10 2

11 2

... ...

and so on

If you are trying to create a multilevel model using SPSS, Heck et al. (2013) provided a relevant guide in their chapter two, entitled “Preparing and Examining the Data for Multilevel Analyses.” Besides, the video tutorial by Crowson (2018) could be helpful. It illustrates carrying out multilevel modeling involving two levels via SPSS.

Crowson, M. (2018, January 30). YouTube. https://www.youtube.com/watch?v=a4P_Bz0vJhE

Heck, R. H., Thomas, S. L., & Tabata, L. N. (2013). Multilevel and longitudinal modeling with IBM SPSS. Routledge. https://www.routledge.com/Multilevel-and-Longitudinal-Modeling-with-IBM-SPSS/Heck-Thomas-Tabata/p/book/9780415817110

Good luck,

Dear Salma Nusrat,

You have to separately subject your data to the required analysis and then arrange the results in a tabular form side by side logically for comparisons. If necessary, you can also add other relevant results for analysis in your tables expanding their size. Conservation of journal space is important. Try to achieve as much brevity as possible. Keep your descriptive content to a minimum. Hope, I have cleared your doubt.

Mohialdeen Alotumi Thank you so much for the help. The two levels (Managers and Subordinates are asked different questions which means we have different cross-sections for both levels how to arrange data in this case?

Watch https://m.youtube.com/watch?v=RU1ps6jaheI

Check http://wlm.userweb.mwn.de/SPSS/wlmsmixd.htm

You could have a look at Peugh and Enders (2005).

Peugh, J. L., & Enders, C. K. (2005). Using the SPSS mixed procedure to fit cross-sectional and longitudinal multilevel models. Educational and Psychological Measurement, 65(5), 717-741. https://doi.org/10.1177/0013164405278558

Good luck,

Hello Salma

use this procedure

https://www.uvm.edu/~statdhtx/fundamentals8/SPSSManual/SPSSLongerManual/SPSSChapter2.pdf