SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 


#Analytics
#SPSSStatistics
#Analyticstools
 View Only

  • 1.  Syntax to complete rows

    Posted 10/26/23 03:11 AM
    Hi can you advise please. I have a very large data file with individuals with differing number of rows( 1-400). For some of these individuals they experienced an event (S). I want to ensure that for those individuals S appears in every row associated with their id number. I’ve tried various IF commands using ids and lag ids and adding a counter for rows but not working. Many thanks Julie

    Sent from my iPhone


  • 2.  RE: Syntax to complete rows

    Posted 10/26/23 08:27 AM

    I would use the aggregate add variable command on the participant ID. 



    ------------------------------
    Art Jack
    ------------------------------



  • 3.  RE: Syntax to complete rows

    Posted 10/26/23 10:01 AM
    Take a look at AGGREGATE.

    --





  • 4.  RE: Syntax to complete rows

    Posted 10/26/23 12:05 PM
    Thanks very much to you and Art for the tip.  It worked fine and in case it helps anybody else can be used  with date variables too.  Julie


    Professor of Education and Adoption, CBE, The Rees Centre, 15 Norham Gardens, Oxford OX2 6PY

    Recent publications 

    Selwyn J (2023) Outcomes for children adopted from care in the UK. In Fenton-Glynn C.& Lowe N. Research Handbook on Adoption Law Chapter 13 229-248. Edward Elgar Publishers
    Selwyn, J., & Lewis, S. (2023). Keeping in touch: Looked after children and young people's views on their contact arrangements. Adoption & Fostering, 47,2, pp120-137  
    Suh E., & Selwyn J (2023), Exploring Local Authority Variation in Looked After Young People's Subjective Well-being, The British Journal of Social Work, 53, 1, pp 177–197
    Selwyn J, Briheim-Crookall L. & the Bright Spots Team (2022) 10,000 Voices: the views of children in care views on their well-being https://coramvoice.org.uk/for-professionals/bright-spots/resource-bank/10091/   
    Palacios J. & Selwyn et al.,  (2019) Adoption in the service of child protection. An international interdisciplinary perspective.  Psychology, Public Policy and Law.  25, 2, 57–72

    Palacios J.& Selwyn et al., (2019) Adoption breakdown: Concept, research and Implications, Research on Social Work Practice. 29,2, 130-142





    Original Message


Related Content