Global AI and Data Science

 View Only
  • 1.  Recoding a variable with multiple values

    Posted Thu July 25, 2024 02:54 PM

    Hi,

    I need some help to recode a string variable with multiple values.

    I have a postcode variable where respondents entered their postcodes as text. Some postcodes are repeated, while others are identical but written differently. The list of postcode responses is extensive, and I want to group them into 5 categories. How can I recode these multiple postcode values into 5 distinct categories?

    Any help would be greatly appreciated.

    Best,

    Mina



    ------------------------------
    Mina
    ------------------------------

    #AIandDSSkills


  • 2.  RE: Recoding a variable with multiple values

    Posted Thu August 01, 2024 12:31 PM

    Hi Mina,

    Could you please ask your question in the product community that is associated with your question. You will get a faster response. Is your question related to SPSS? 

    Thanks,

    Nick

    AI Community Manager



    ------------------------------
    Nick Plowden
    AI Community Engagement
    IBM
    ------------------------------



  • 3.  RE: Recoding a variable with multiple values

    Posted Fri August 02, 2024 05:32 PM

    Hi Mina,

    Just wondering if AUTORECODE would help? or alternatively, you could use CHAR.SUBSTR to split the postcodes into multiple, shorter strings, and recode these?

    Roger



    ------------------------------
    Roger Fiedler
    ------------------------------