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