SPSS Statistics

 View Only
  • 1.  address

    Posted Thu June 02, 2022 02:10 PM
    Hello, I have a table with all of the streets in our county.  I was hoping there was a way to reference that table somehow, search for the string in the table, assign the table street name to the spss file, and all from the spss syntax window.  The cells have other text info also and no consistent pattern.  I was thinking something like this.

    reference table and run this code:
    (check street variable in other table) if char.index(upper(address), 'STREET NAME')>0 (assign street to current spss file) street_variable='STREET NAME'.

    Is something like this possible?

    Thanks
    Arthur

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

    #SPSSStatistics


  • 2.  RE: address

    IBM Champion
    Posted Thu June 02, 2022 03:09 PM
    Yes, but I would need details and sample files.  You could send the files to me at jkpeck@gmail.com

    --