LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2006)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 24 Oct 2006 16:57:35 -0400
Reply-To:     Richard Ristow <wrristow@mindspring.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Richard Ristow <wrristow@mindspring.com>
Subject:      Re: Looping complexity for complex situation
Comments: To: Manmit Shrimali <MShrimali@marketrx.com>
In-Reply-To:  <9D4BEF69F83C9744AB34E5FE2F78F46DDA0CC5@matrix.mrxin.market
              rx.com>
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 06:20 PM 10/22/2006, Manmit Shrimali wrote:

>I will have multiple files

THAT shouldn't be a problem. You need to combine the multiple files into one, by whatever is the appropriate technique - ADD FILES, MATCH FILES, or whatever.

>My data is coded as follows: City_year1 New York Yes/No and so on.

Like this (SPSS draft output)?

* "My data is coded: City_year1 New York Yes/No and so on." . * Like this? YR1_PVD 'Visited Providence in year 1' . * YR1_CRNS 'Visited Cranston in year 1' . * YR1_WRWK 'Visited Warwick in year 1' . * YR2_PVD 'Visited Providence in year 2' . * YR2_CRNS 'Visited Cranston in year 2' . * YR2_WRWK 'Visited Warwick in year 2' . * YR3_PVD 'Visited Providence in year 3' . * YR3_CRNS 'Visited Cranston in year 3' . * YR3_WRWK 'Visited Warwick in year 3' . GET FILE=TESTDATA. TEMPORARY. STRING SPACE(A28). LIST.

List |-----------------------------|---------------------------| |Output Created |24-OCT-2006 16:43:46 | |-----------------------------|---------------------------| C:\Documents and Settings\Richard\My Documents \Temporary\SPSS \2006-10-23 Shrimali - Looping complexity for complex situation.SAV

CASE YR1_ YR1_ YR1_ YR2_ YR2_ YR2_ YR3_ YR3_ YR3_ _NUM PVD CRNS WRWK PVD CRNS WRWK PVD CRNS WRWK SPACE

001 1 0 0 1 1 0 0 0 1 002 1 1 1 0 1 0 0 0 1 003 0 1 1 0 1 1 0 0 1 004 0 1 0 1 1 1 1 0 0 005 0 0 0 0 1 0 1 0 0 006 0 1 0 0 1 0 0 1 0 007 0 1 0 0 0 1 0 0 0 008 0 1 1 0 0 0 1 0 1 009 1 1 0 0 0 0 1 0 1 010 0 0 1 1 0 0 1 0 1 011 0 0 1 0 0 0 1 0 0 012 0 1 1 1 0 1 0 0 0 013 0 0 0 0 0 0 0 0 1 014 1 0 0 0 0 1 0 0 1 015 0 0 0 0 1 0 0 0 0 016 0 0 1 0 0 0 0 0 0 017 1 1 0 0 0 1 0 0 0 018 0 1 1 0 0 1 0 1 0 019 0 0 0 0 0 1 0 0 1 020 0 1 1 1 0 0 1 1 1

Number of cases read: 20 Number of cases listed: 20

>I can have multiple combination and I want to get the analysis at >unique level. For e.g. let say in 1st year I get following group: >10 people visited city a b and c [...] >40 visited city fgh > >For each group I want to see which cities they visited in following >years till 5 year.

That *sounds* like you want to count all different patterns of visiting over the five years: the set of cities visited the first year BY the set visited the second year BY the set visited the third year....

That's easy with AGGREGATE (see below), but useless. With 3 cities and 3 years (in my test data) there are 2**(3*3)=512 possible combinations; as you see none occurs even twice in this test data. 35 cities and 5 years gives 2**(35*5)=5*10**52 combinations.

In the test data I've posted - three cities, three year - what are the categories you'd like to count?

(By the way, Hillel Vardi described this needing a many-to-many match. It probably doesn't. If your data is organized like the test data above, the many-to-many match is already done in the ata records.)

Illustration - count all combinations (SPSS draft output):

* "If 10 people visited city a in first year, I want to know,. * which cities they visited in year three, let say 5 visited . * and 5 did not visit at all. Out of 5 who visited in year . * two, which cities they visited in year 3 and so on" .

* Possibility one: count all combinations: ............... . * (This is easy with AGGREGATE, but impossible to analyze . * because there are so many combinations.) .

AGGREGATE OUTFILE=* /BREAK = YR1_PVD TO YR3_WRWK /INSTANCES 'Occurrences of this combination' = N. FORMATS INSTANCES (F4). TEMPORARY. STRING SPACE(A24). LIST.

List |-----------------------------|---------------------------| |Output Created |24-OCT-2006 16:43:48 | |-----------------------------|---------------------------| YR1_ YR1_ YR1_ YR2_ YR2_ YR2_ YR3_ YR3_ YR3_ PVD CRNS WRWK PVD CRNS WRWK PVD CRNS WRWK INSTANCES SPACE

0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 1 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 1 0 0 1 0 0 1 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 1 0 0 1 1 0 0 1 0 1 1 0 1 0 0 0 1 0 0 0 1 0 1 0 0 1 0 0 1 0 1 0 1 0 1 1 1 1 0 0 1 0 1 1 0 0 0 1 0 1 1 0 1 1 0 0 1 0 1 0 1 0 1 1 0 1 1 0 0 1 1 0 1 1 1 0 0 1 1 1 1 0 1 1 1 0 1 0 0 0 1 1 0 0 0 0 1 0 0 1 1 1 0 0 1 1 0 0 0 1 1 1 1 0 0 0 0 1 0 1 1 1 1 0 0 0 1 0 0 0 1 1 1 1 0 1 0 0 0 1 1

Number of cases read: 20 Number of cases listed: 20


Back to: Top of message | Previous page | Main SPSSX-L page