string cases to variables

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

psdixon
Posts: 1
Joined: Fri Oct 21, 2016 9:04 pm

string cases to variables

Postby psdixon » Fri Oct 21, 2016 9:15 pm

Hello,

I am returning to SPSS after 14 years and I am completely stymied by a project. I was able to get the following string data into SPSS (I have 1600 individual names):

John Smith
Los Angeles
California
Mary Hall
Portland
Oregon
Meg Gonzales
Orlando
Florida

But I would like to transform them to the following so I can do analysis:

name city state
John Smith Los Angeles California
Mary Hall Portland Oregon
Meg Gonzales Orlando Florida

I have looked through all my old SPS files, but cannot find anything to jog my memory or my creativity!

MANY thanks for any guidance.

Scott

Who is online

Users browsing this forum: No registered users and 1 guest

cron