Join similar string values

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

Rcosta14
Posts: 1
Joined: Thu Aug 13, 2015 11:21 am

Join similar string values

Postby Rcosta14 » Thu Aug 13, 2015 11:26 am

Hello,

I need some help with spss 20.

I have a database with 6 fields (name, e-mail, ID, course, date and gender). Database it's about selling courses online.

i want to know how mutch courses have the e-mails be cause i have e-mails that only buy one course and anothers tha buy 2 or 3.

How can i make this? i want to create a table that shows me how many e-mails buy 1 course, how many e-mails buy 2 courses, how many buy 3 courses...

Can you help me?

Thank You,
Ricardo
GerineL
Moderator
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: Join similar string values

Postby GerineL » Thu Aug 13, 2015 1:34 pm

your question is a bit hard to follow, but what I got is this:

You have a dataset with name, e-mail, ID, course, date and gender.

The data looks like this (with some other vars):

Email................course
a@b.nl..............firstcoursename
a@b.nl..............secondcoursename
a@b.nl..............thirdcoursename
b@c.nl..............secondcoursename

and you want spss to tell you that the person with email adress a@b.nl has taken 3 courses, whereas person b@c.nl has taken only one course.
correct?

Who is online

Users browsing this forum: No registered users and 1 guest

cron