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 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 11 Oct 2002 13:49:30 -0700
Reply-To:     "Gao, Peter" <>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Gao, Peter" <>
Subject:      Looking for help with syntax-data manipulation
Content-Type: text/plain; charset="iso-8859-1"

Dear list members,

I hope someone can help me with this:

I have a matrix of variables, the record line (case) is about disease names, the variables (columns) are names of foods or medicines. Not all entries have a value (have missing values here and there). I am trying to produce an output that will show one food associated with how many diseases or one disease associated with how many foods.

Example of my data (actual data file is large with 53 columns):

diseases meats dairy eggs medicine drug perfume oil bone cancer 1 1 . 1 . 1 . Brain cancer 1 . 1 . 1 . 1 Lung cancer . 1 . . . . 1

output or data will be something like:

bone cancer: meats, dairy medicine perfume Brain cancer: meats, eggs, drug, oil Lung cancer: dairy, oil

The resulting list has varied number of variables.

I wish someone with the expertise can write the syntax to do it. Many thanks in advance.

Have a nice weekend.

Peter Gao

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