I have a very very large data base with several observations coming from one participant (multiple participants, multiple lines per participant). I want to copy and paste a value in a column to fill in the missing values in the same column. See an exemple :
| x | Variable 1 |
|---|---|
| P1 | 45 |
| P1 | – |
| P1 | – |
| P1 | – |
| P2 | 53 |
| P2 | – |
| P3 | 27 |
| P3 | – |
| P3 | – |
| P3 | – |
| P3 | – |
| P4 | 45 |
| P5 | 56 |
What syntax can I use to tell SPSS to copy paste the value, for exemple for P1 “45”, to the following empty values for this participant ?
Thank you for your help !
I tried doing it by hand but my database is huge and I will lose hours if I do not find a way.
New contributor
Dana Bonnardel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.