Date: Thu, 17 Jun 1999 14:25:41 -0700
Reply-To: glaser@pacific-science.com
Sender: "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From: Dale Glaser <glaser@PACIFIC-SCIENCE.COM>
Subject: massed data to individual records
In-Reply-To: <C02FEF109018D3118C9900A024CDCB6476E3B9@HERMES>
Content-Type: text/plain; charset="iso-8859-1"
Possibly there is some easy algorithm to get at the following, but my
perusal of Defining Complex Files in the Base Manual did not quite get at
what I need....any help greatly appreciated:
I have received data as follows:
Subject sup4 notsup4 ambig4 sup2 notsup2 ambig2
1 0 0 4 2 0
0
2 0 1 3 1 1
0
3 1 1 2 2 0
0
sup=support
notsup=not support
amibig=ambiguous
The numbers following the ascription in the variable name are the number of
scenarios presented....I won't delve into the experimental context, but in a
nutshell subject #1 receives four descriptions of a scenario, of which they
rate each description as either being supporting, not supporting, or
ambiguous; this is a completely within-subject design, so in this sample of
data, subject #1 was presented with four situations and rated four as being
ambiguous; subsequently they are given two situations (related to the same
scenario) and rate them again (in this instance s#1 rates them both as being
supportive); the above datapoints are for one scenario, so they actually had
4 scenarios each........we were interested at looking at the type of
scenario x rating interaction (e.g., 4 x 3 chi-square), however, beyond the
experimental logistics that may advise against this type of analysis (i.e.,
nonindependence of data), this analysis was mainly a check after the fact to
see if any descriptions are particularly problematic (i.e., ambiguous);
well, unfortunately the data came to me in the above fashion meaning it was
aggregated with each cell representing a sum (e.g., subject #3 said two
descriptions were ambiguous for the '4' condition [ambig4]), instead of
being true count data; I know how to use syntax to convert multiple records
into one (e.g., vector outside a loop structure), but I am having troubles
using some type of 'repeating data' command to create multiple records for
each subject, and be able to convert the massed count for each cell into a
RATING type variable, as described below......so, ideally my data should
look like the following (for one subject and two contiguous scenarios):
RATING
Support=1
Not support=2
Ambiguous=3
SCENARIO
4 descriptions=1
2 descriptions=2
Subject Rating Scenario
1 3 1
1 3 1
1 3 1
1 3 1
1 1 2
1 1 2
Are there any aggregate or looped commands that may remediate my
perpelexity?
Thank you for any assistance
Dale Glaser, Ph.D.
Pacific Science & Engineering/SDSU
San Diego, CA
| 
