SPSSX Discussion

When is V16 coming out?

Classic

List

Threaded

2 messages Options

Charles Partridge-2

When is V16 coming out?

Greetings,

My time came to purchase a new computer at my workplace. Guess what-I got Vista.

Does anyone know what the anticipated timeline for SPSS V16 is?

-CRP

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Automatic digest processor
Sent: Tuesday, March 06, 2007 12:01 AM
To: Recipients of SPSSX-L digests
Subject: SPSSX-L Digest - 4 Mar 2007 to 5 Mar 2007 (#2007-65)

There are 41 messages totalling 3495 lines in this issue.

Topics of the day:

1. AW: Re: Import values in a part of the cases (3)
2. Analysis of a Stratified Cluster Sample
3. Dataset: reverse to saved
4. Reverse autorecode syntax (2)
5. Data restructuring problem (4)
6. Random effects logistic regression
7. disappearing data
8. Stat question: means ratio test (6)
9. [BULK] frist ? character of value
10. Multiple Files to Open & Analyze
11. SPSS 15 and AMOS 7 under Vista OS (6)
12. AW: Re: Import values in a part of the cases (2)
13. Exporting file from Blackboard to Excel to SPSS
14. =?us-ascii?Q?Re=3AReverse=20autorecode=20syntax?=
15. Looping and merging syntax support (6)
16. SPSS warning from regression (4)

----------------------------------------------------------------------

Date: Mon, 5 Mar 2007 09:07:54 +0100
From: Balmer Thomas <[hidden email]>
Subject: AW: Re: Import values in a part of the cases

>In another question you've raised,

>*Getting the file to update with the values from B1.
>GET
> FILE='C:\...\A.sav'.
>DATASET NAME DatenSet6 WINDOW=FRONT.
>
>SORT CASES by Nachname Vorname.
>UPDATE FILE = A
> / FILE = B1
> / RENAME = (Name, Str_Wohn, Mail_g=Nachname, Strasse, Email)
> /by Nachname Vorname.
>
>>Error # 63 in column 13. Text: A
>>The file does not exist.
>>This command not executed.
>
>>Error # 63 in column 9. Text: B
>>The file does not exist.
>
>>Note # 5146
>>There is no working file to restore. You must define a working file
>>before
>>proceeding with your analysis.
>
>I got the A-file in the front window, so it does exist!

>First, although the file in the front window was LOADED from file A, it
>isn't file A; it's a copy of it. Since it's the active file, you can
>refer to it as '*'.

>Second, you need to refer to file B1 the way you did when you saved it:
>'C:\...\B1.sav'.

>So your UPDATE command becomes
>
>UPDATE FILE = *
> / FILE = 'C:\...\B1.sav'
> / RENAME = (Name, Str_Wohn, Mail_g=Nachname, Strasse, Email)
> /by Nachname Vorname.

>That may do what you want. It assumes that,
>- File B1 is also sorted by Nachname Vorname
>- Neither file has more than one record for any combination of Nachname
>Vorname
>
>If the latter assumption is not correct, then it's time to think about
>MATCH FILES with the TABLE subcommand.

The UPDATE Command got the files now, but could not finish. It gave me
an error message with the first Nachname-Vorname-Combination which is
not unique - I suppose because of the point you mentioned: In File B1
Nachname and Vorname are unique combinations, but not so in File A. I'll
try the MACTCH FILES with TABLE.

------------------------------

Date: Mon, 5 Mar 2007 10:01:55 +0100
From: Balmer Thomas <[hidden email]>
Subject: AW: Re: Import values in a part of the cases

I tried the TABLE subcommand like this:

MATCH FILES /FILE=*
/TABLE='B1'
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse
/DROP= Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex
/BY Nachname Vorname.
EXE.

...renaming variables in the file B1 to match with the variables in the *-file (which is the master) and droping a few.
Strange Result: Nothing. The Syntax seems to work, because I got no error, but the values from B1 are not printed in the file *.

-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:[hidden email]] Im Auftrag von Melissa Ives
Gesendet: Freitag, 2. März 2007 16:30
An: [hidden email]
Betreff: Re: Import values in a part of the cases

You may want to use TABLE instead of UPDATE. Look at the Operations of
each to see which one retains the records you want. In TABLE, only
records that match in the FILE are included. In UPDATE, new records are
created in the master file if they are in the update file but not in the
master. I believe this means that they would work similarly IF you have
exactly the same records (per the matching variables) in both files.

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Balmer Thomas
Sent: Friday, March 02, 2007 7:01 AM
To: [hidden email]
Subject: [SPSSX-L] Import values in a part of the cases

Hi

The aim would be to import values of a couple of string variables in
these cases, which match with the values of two variables (Firstname and
Name).

But the matching command seems to allow just two other purposes: to add
new variables or to add new cases. I'd like to import just the values
in existing variables (Street, Town, Email) for the matching cases,
without adding new variables or cases.

It's probably a total different command I need...

Thanks for Help!

Tom

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at (309) 827-6026 for assistance.

------------------------------

Date: Mon, 5 Mar 2007 02:29:08 -0800
From: Alice P Chiu <[hidden email]>
Subject: Analysis of a Stratified Cluster Sample

Dear all,=0AI would like to seek some advice regarding the analysis of a St=
ratified Cluster Sample. =0AI would like to find the association between tw=
o variables. Within the 2x2 table, there was an expected count of less tha=
n 5.=0AI was told that Fisher's exact test should not be used in such a sce=
naario.=0ACan you please advice which test should be used instead?=0AThanks=
in advance!=0A=0AAlice.=0A=0A=0A =0A______________________________________=
______________________________________________=0AGet your own web address. =
=0AHave a HUGE year through Yahoo! Small Business.=0Ahttp://smallbusiness.=
yahoo.com/domains/?p=3DBESTDEAL

------------------------------

Date: Mon, 5 Mar 2007 12:56:07 +0100
From: Antoon Smulders <[hidden email]>
Subject: Dataset: reverse to saved

Hello all,

Although the possibility to open more files the same time is there since a
couple of versions ago, I have so far avoided it, because of some problems
(mainly caused by my ignorance, I'm sure).

I have a file called "computes.sps" wich starts with:

GET FILE "myfile.sav".

DATASET NAME= "myset".

COMPUTE varA = 2.

I have another file called "output.sps" , wich reads:

Cd "S:\".

Include "computes.sps".

Freq varA.

Now I start spss and when prompted for a file to open I choose output.sps.
The data window now shows in its title bar: untitled1 [dataset0].

Next I run my output.sps.Dataset0 (and untitled1) are closed and the title
bar reads: myfile.sav [myset]

So far so good, but now I make a big mess of it: (one thing I'm very good
at) so I want to "revert back to saved", but if I include my computes a
second time, the filename changes in "untitled2". There is also a warning in
the output window that "the active dataset wil replace the existing dataset
myset", but that is exactly what I want. To get my filename back I have to
run /include the computes file a third time.

Now how can I let SPSS use the real filename instead of "untitled", without
reopening it this third time.

Thanks in advance

Antoon Smulders

------------------------------

Date: Mon, 5 Mar 2007 13:06:06 +0100
From: Max Bell <[hidden email]>
Subject: Reverse autorecode syntax

Dear List,

I'm loooking for syntax to do reverse autorecode. I want to create a new
string variable based on the values of an existing variable. I found
this script
Reverse autorecode.SBS <Scripts/Labels/ReverseAutorecode.txt> To create
a new string variable containing the value labels of an existing
variable (this can also be done using syntax alone)=20

But the mentioned syntax I cannot find. Who can help me?

Thanks in advance,
Max

------------------------------

Date: Mon, 5 Mar 2007 12:47:55 +0000
From: Jennifer Thompson <[hidden email]>
Subject: Data restructuring problem

Dear SPSSers,

I have what I think is a fairly complicated (for me at least) data
restructuring problem and would be very grateful for any help or
suggestions.

I have 30+ files (one per experiment participant) with the same basic
structure, consisting of 5 variables:

1. Condition - which can be one of is one of 3 basic tasks: tapping in
synch with a sound (Synch), tapping without a sound (Unpaced) and tapping in
synch with a sound in preparation for Unpaced (Paced), each of which is done
seperately with the right hand (R), left hand (L) and with both together
(B), and repeated 3 times (so 27 different 'conditions'.)

2. RT - which is a timestamp for a response press or release

3. Response - which is 8 for a press and 8.5 for a release with the right
hand and 7 for a press / 7.5 for a release with the left hand

4. soundon - the timestamp for the onset of the pacing sound (not present
in the unpaced conditions)

5. soundoff - the timestamp for the offset of the pacing sound (not present
in the unpaced conditions)

The difficulty is that the timestamps occur consecutively in the file,
regardless of whether they are a press or release, or produced with the
right or left hand.

To begin to analyse the data I think I need to get it in a format where the
variables are something like this:

1. Condition

2. Press_R (press with right hand)

3. Release_R (release the right hand)

4. Press_L (press with left hand)

5. Release_L (release with right hand)

6. Sound onset

7. Sound offset

I've done this manually (!) for the first file, by sorting the data by
condition, response and RT and 'simply' copying / pasting the data as
appropriate, which took quite some time... There has to be an easier way to
do this, surely?

There is another problem. Some of the responses (releases only, from what I
can see so far) are missing, so the press / release RT columns don't always
match up. In this case, the 'release' RT will be a higher number than the
next 'press' RT, so I've been flagging this with the following syntax:

IF (Press_L < LAG(Release_L)) Error_L = 1 .

IF (Press_R < LAG(Release_R)) Error_R = 1 .

And then manually (copy/paste) lining up the data. But again, is there a
more 'automated' way I could do this?

Any thoughts / suggestions? I've struggled to explain the data but will
gladly send an example datafile if anyone would like to take a look.

Thanks for reading,

Jennifer

------------------------------

Date: Mon, 5 Mar 2007 08:15:43 -0500
From: Statisticsdoc <[hidden email]>
Subject: Re: Random effects logistic regression

Lou,

Another excellent source of information on this topic is Raudenbush, S.W.
and Bryk, A.S. (2002). Hierarchical Linear Models (Second Edition). Thousand
Oaks: Sage Publications, 482 pp. This text covers binomial and multinomial
cases.

HTH,

Stephen Brand

For personalized and professional consultation in statistics and research
design, visit
www.statisticsdoc.com

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
Lou
Sent: Thursday, March 01, 2007 11:29 AM
To: [hidden email]
Subject: Random effects logistic regression

Hi there,

Can anyone recommend some good references/websites for learning
about 'random effects logistic regression', please?

Thanks

Lou

------------------------------

Date: Mon, 5 Mar 2007 07:16:10 -0600
From: "Beadle, ViAnn" <[hidden email]>
Subject: Re: Data restructuring problem

There is information not specified here--what hypotheses are you testing, or in less formal terms, what are you trying to find out? This, in turn, will determine thee types of analyses to perform. And, those in turn, will determine the appropriate data structure(s).

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jennifer Thompson
Sent: Monday, March 05, 2007 6:48 AM
To: [hidden email]
Subject: Data restructuring problem

Dear SPSSers,

I have what I think is a fairly complicated (for me at least) data
restructuring problem and would be very grateful for any help or
suggestions.

I have 30+ files (one per experiment participant) with the same basic
structure, consisting of 5 variables:

1. Condition - which can be one of is one of 3 basic tasks: tapping in
synch with a sound (Synch), tapping without a sound (Unpaced) and tapping in
synch with a sound in preparation for Unpaced (Paced), each of which is done
seperately with the right hand (R), left hand (L) and with both together
(B), and repeated 3 times (so 27 different 'conditions'.)

2. RT - which is a timestamp for a response press or release

3. Response - which is 8 for a press and 8.5 for a release with the right
hand and 7 for a press / 7.5 for a release with the left hand

4. soundon - the timestamp for the onset of the pacing sound (not present
in the unpaced conditions)

5. soundoff - the timestamp for the offset of the pacing sound (not present
in the unpaced conditions)

The difficulty is that the timestamps occur consecutively in the file,
regardless of whether they are a press or release, or produced with the
right or left hand.

To begin to analyse the data I think I need to get it in a format where the
variables are something like this:

1. Condition

2. Press_R (press with right hand)

3. Release_R (release the right hand)

4. Press_L (press with left hand)

5. Release_L (release with right hand)

6. Sound onset

7. Sound offset

I've done this manually (!) for the first file, by sorting the data by
condition, response and RT and 'simply' copying / pasting the data as
appropriate, which took quite some time... There has to be an easier way to
do this, surely?

There is another problem. Some of the responses (releases only, from what I
can see so far) are missing, so the press / release RT columns don't always
match up. In this case, the 'release' RT will be a higher number than the
next 'press' RT, so I've been flagging this with the following syntax:

IF (Press_L < LAG(Release_L)) Error_L = 1 .

IF (Press_R < LAG(Release_R)) Error_R = 1 .

And then manually (copy/paste) lining up the data. But again, is there a
more 'automated' way I could do this?

Any thoughts / suggestions? I've struggled to explain the data but will
gladly send an example datafile if anyone would like to take a look.

Thanks for reading,

Jennifer

------------------------------

Date: Mon, 5 Mar 2007 14:20:33 +0000
From: Jennifer Thompson <[hidden email]>
Subject: Re: Data restructuring problem

Thanks for the comments, and I'm sorry that my initial post was vague. Here
is some more information:

The study is a comparison of neurological patients and healthy controls.
The task involves unimanual or bimanual finger tapping, which is either
paced with a tone (every 600 milliseconds) [the 'synch' condition] or
unpaced [the 'unpaced' condition], in which 10 pacing tones are initially
presented and the participant is required to continue tapping at the same
rate [performance on the initial pacing practice is also recorded as the
'paced' condition - although it isn't actually a condition as such].

I will be calculating the mean inter-tap interval and variability for paced
vs unpaced tapping, and unimanual vs bimanual tapping for each participant.
I was planning to do this using the LAG function, using something like:

COMPUTE Press_ITI_R = Press_R - LAG(Press_R)

I'll also be calculating the degree to which responses with either hand in
the bimanual condition are synchronised, by looking at the lag between
them.

The hypothesis is that the neurological patients will have a more variable
inter-tap interval, and that they will show less synchronisation of the two
hands when tapping bimanually. It is also hypothesised that the inter-tap
interval variability of neurological patients will be disproportionately
affected in the unpaced condition. We may also look at how the two groups
compare in the ability to actually synchronise their response with the
tones. The analysis will generally focus on the tap onset (press) but we'll
also be calculating the average response duration (hence the need for both
press and release reaction time data).

I hope this makes my problem more clear.

Many thanks,

Jennifer

On 3/5/07, Beadle, ViAnn <[hidden email]> wrote:

>
> There is information not specified here--what hypotheses are you testing,
> or in less formal terms, what are you trying to find out? This, in turn,
> will determine the types of analyses to perform. And, those in turn, will
> determine the appropriate data structure(s).
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Jennifer Thompson
> Sent: Monday, March 05, 2007 6:48 AM
> To: [hidden email]
> Subject: Data restructuring problem
>
> Dear SPSSers,
>
> I have what I think is a fairly complicated (for me at least) data
> restructuring problem and would be very grateful for any help or
> suggestions.
>
> I have 30+ files (one per experiment participant) with the same basic
> structure, consisting of 5 variables:
>
> 1. Condition - which can be one of is one of 3 basic tasks: tapping in
> synch with a sound (Synch), tapping without a sound (Unpaced) and tapping
> in
> synch with a sound in preparation for Unpaced (Paced), each of which is
> done
> seperately with the right hand (R), left hand (L) and with both together
> (B), and repeated 3 times (so 27 different 'conditions'.)
>
> 2. RT - which is a timestamp for a response press or release
>
> 3. Response - which is 8 for a press and 8.5 for a release with the
> right
> hand and 7 for a press / 7.5 for a release with the left hand
>
> 4. soundon - the timestamp for the onset of the pacing sound (not present
> in the unpaced conditions)
>
> 5. soundoff - the timestamp for the offset of the pacing sound (not
> present
> in the unpaced conditions)
>
> The difficulty is that the timestamps occur consecutively in the file,
> regardless of whether they are a press or release, or produced with the
> right or left hand.
>
>
> To begin to analyse the data I think I need to get it in a format where
> the
> variables are something like this:
>
> 1. Condition
>
> 2. Press_R (press with right hand)
>
> 3. Release_R (release the right hand)
>
> 4. Press_L (press with left hand)
>
> 5. Release_L (release with right hand)
>
> 6. Sound onset
>
> 7. Sound offset
>
> I've done this manually (!) for the first file, by sorting the data by
> condition, response and RT and 'simply' copying / pasting the data as
> appropriate, which took quite some time... There has to be an easier way
> to
> do this, surely?
>
> There is another problem. Some of the responses (releases only, from what
> I
> can see so far) are missing, so the press / release RT columns don't
> always
> match up. In this case, the 'release' RT will be a higher number than the
> next 'press' RT, so I've been flagging this with the following syntax:
>
> IF (Press_L < LAG(Release_L)) Error_L = 1 .
>
> IF (Press_R < LAG(Release_R)) Error_R = 1 .
>
> And then manually (copy/paste) lining up the data. But again, is there a
> more 'automated' way I could do this?
>
> Any thoughts / suggestions? I've struggled to explain the data but will
> gladly send an example datafile if anyone would like to take a look.
>
> Thanks for reading,
>
> Jennifer
>

------------------------------

Date: Mon, 5 Mar 2007 10:01:22 -0500
From: "Zdaniuk, Bozena" <[hidden email]>
Subject: disappearing data

Hello, I opened a data file in spss 14 that was created in earlier
version of spss and about a half of the cases did not appear in the
'data' window. The analyses still ran on all the cases even though I
could not see half of them. However, once I made a small change in the
file, the analyses started showing only the number of cases seen in the
file. The rest mysteriously disappeared... Any idea what happened and
how I can fix it? Thanks.
bozena

Bozena Zdaniuk, Ph.D.

University of Pittsburgh

UCSUR, 6th Fl.

121 University Place

Pittsburgh, PA 15260

Ph.: 412-624-5736

Fax: 412-624-4810

email: [hidden email]

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Jennifer Thompson
Sent: Monday, March 05, 2007 7:48 AM
To: [hidden email]
Subject: Data restructuring problem

Dear SPSSers,

I have what I think is a fairly complicated (for me at least) data
restructuring problem and would be very grateful for any help or
suggestions.

I have 30+ files (one per experiment participant) with the same basic
structure, consisting of 5 variables:

1. Condition - which can be one of is one of 3 basic tasks: tapping in
synch with a sound (Synch), tapping without a sound (Unpaced) and
tapping in
synch with a sound in preparation for Unpaced (Paced), each of which is
done
seperately with the right hand (R), left hand (L) and with both together
(B), and repeated 3 times (so 27 different 'conditions'.)

2. RT - which is a timestamp for a response press or release

3. Response - which is 8 for a press and 8.5 for a release with the
right
hand and 7 for a press / 7.5 for a release with the left hand

4. soundon - the timestamp for the onset of the pacing sound (not
present
in the unpaced conditions)

5. soundoff - the timestamp for the offset of the pacing sound (not
present
in the unpaced conditions)

The difficulty is that the timestamps occur consecutively in the file,
regardless of whether they are a press or release, or produced with the
right or left hand.

To begin to analyse the data I think I need to get it in a format where
the
variables are something like this:

1. Condition

2. Press_R (press with right hand)

3. Release_R (release the right hand)

4. Press_L (press with left hand)

5. Release_L (release with right hand)

6. Sound onset

7. Sound offset

I've done this manually (!) for the first file, by sorting the data by
condition, response and RT and 'simply' copying / pasting the data as
appropriate, which took quite some time... There has to be an easier
way to
do this, surely?

There is another problem. Some of the responses (releases only, from
what I
can see so far) are missing, so the press / release RT columns don't
always
match up. In this case, the 'release' RT will be a higher number than
the
next 'press' RT, so I've been flagging this with the following syntax:

IF (Press_L < LAG(Release_L)) Error_L = 1 .

IF (Press_R < LAG(Release_R)) Error_R = 1 .

And then manually (copy/paste) lining up the data. But again, is there
a
more 'automated' way I could do this?

Any thoughts / suggestions? I've struggled to explain the data but will
gladly send an example datafile if anyone would like to take a look.

Thanks for reading,

Jennifer

------------------------------

Date: Mon, 5 Mar 2007 18:16:55 +0300
From: Anton Balabanov <[hidden email]>
Subject: Stat question: means ratio test

Dear Listers,

I feel stucked with the following question.
Suppose, I have two samples from independent populations. And I whant to
test the hypothesis that one mean is as twice as the other mean, that is:
H0: m1 = 2*m2.

It seems, doubling values for the second sample (before using standard
t-test) is not correct practice, because it will affect variance.
Is there a simple way to do such a test, and if "yes", how can I manage it
in SPSS?

Many thanks in advance,

Anton

------------------------------

Date: Mon, 5 Mar 2007 09:27:15 -0600
From: Melissa Ives <[hidden email]>
Subject: Re: AW: Re: Import values in a part of the cases

Thomas,

(As noted in my message to you on Fri 3/2/2007 11:28 AM) Remember that the order of the files matters, so IF the variables you want to add from the lookup table are already IN the main file, then the /TABLE= subcommand needs to come BEFORE the /FILE= subcommand. (works the same way in regular match with 2 (or more) /FILE= statements) If a variable is common to both files, the one in the first listed file is what is retained.

So you would need to switch your file order in the MATCH command to be:
MATCH FILES
/TABLE='B1'
/FILE=*
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse /DROP= Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname Vorname.
EXE.

Melissa
The bubbling brook would lose its song if you removed the rocks.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Balmer Thomas
Sent: Monday, March 05, 2007 3:02 AM
To: [hidden email]
Subject: [SPSSX-L] AW: Re: Import values in a part of the cases

I tried the TABLE subcommand like this:

MATCH FILES /FILE=*
/TABLE='B1'
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse /DROP= Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname Vorname.
EXE.

...renaming variables in the file B1 to match with the variables in the *-file (which is the master) and droping a few.
Strange Result: Nothing. The Syntax seems to work, because I got no error, but the values from B1 are not printed in the file *.

-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:[hidden email]] Im Auftrag von Melissa Ives
Gesendet: Freitag, 2. März 2007 16:30
An: [hidden email]
Betreff: Re: Import values in a part of the cases

You may want to use TABLE instead of UPDATE. Look at the Operations of each to see which one retains the records you want. In TABLE, only records that match in the FILE are included. In UPDATE, new records are created in the master file if they are in the update file but not in the master. I believe this means that they would work similarly IF you have exactly the same records (per the matching variables) in both files.

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Balmer Thomas
Sent: Friday, March 02, 2007 7:01 AM
To: [hidden email]
Subject: [SPSSX-L] Import values in a part of the cases

Hi

The aim would be to import values of a couple of string variables in these cases, which match with the values of two variables (Firstname and Name).

But the matching command seems to allow just two other purposes: to add new variables or to add new cases. I'd like to import just the values in existing variables (Street, Town, Email) for the matching cases, without adding new variables or cases.

It's probably a total different command I need...

Thanks for Help!

Tom

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND CONFIDENTIAL information and is intended only for the use of the addressee. If you are not the designated recipient, or an employee or agent authorized to deliver such transmittals to the designated recipient, you are hereby notified that any dissemination, copying or publication of this transmittal is strictly prohibited. If you have received this transmittal in error, please notify us immediately by replying to the sender and delete this copy from your system. You may also call us at (309) 827-6026 for assistance.

------------------------------

Date: Mon, 5 Mar 2007 08:31:17 -0700
From: "Ornelas, Fermin" <[hidden email]>
Subject: Re: Stat question: means ratio test

Correct me if my interpretation of this is not right?
But you do not go and alter the means of the second sample. What you
should do is calculate their means as they are and do the test to verify
that the means do not met the condition that you just mentioned.

That is you Ho: m1_sample1= 2*(m2_sample2);
Ha: m1_sample1 <> 2*(m2_sample2);
Then use the two tail t-table values to see if you results validate or
fail to reject Ho.

Fermin Ornelas, Ph.D.
Management Analyst III, AZ DES
Tel: (602) 542-5639
E-mail: [hidden email]
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Anton Balabanov
Sent: Monday, March 05, 2007 8:17 AM
To: [hidden email]
Subject: Stat question: means ratio test

Dear Listers,

I feel stucked with the following question.
Suppose, I have two samples from independent populations. And I whant to
test the hypothesis that one mean is as twice as the other mean, that
is:
H0: m1 = 2*m2.

It seems, doubling values for the second sample (before using standard
t-test) is not correct practice, because it will affect variance.
Is there a simple way to do such a test, and if "yes", how can I manage
it
in SPSS?

Many thanks in advance,

Anton

NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR
CONFIDENTIAL information and is intended only for the use of the
specific individual(s) to whom it is addressed. It may contain
information that is privileged and confidential under state and federal
law. This information may be used or disclosed only in accordance with
law, and you may be subject to penalties under law for improper use or
further disclosure of the information in this e-mail and its
attachments. If you have received this e-mail in error, please
immediately notify the person named above by reply e-mail, and then
delete the original e-mail. Thank you.

------------------------------

Date: Mon, 5 Mar 2007 08:43:40 -0700
From: "Ornelas, Fermin" <[hidden email]>
Subject: Re: Stat question: means ratio test

Note also that your example is just increasing the second mean by a
constant. For examples on how to do this type of testing look at Netter,
et. Al. Applied Linear Regression in the ANOVA Chapters for examples on
means testing similar to the one you are doing.

Fermin Ornelas, Ph.D.
Management Analyst III, AZ DES
Tel: (602) 542-5639
E-mail: [hidden email]

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Anton Balabanov
Sent: Monday, March 05, 2007 8:17 AM
To: [hidden email]
Subject: Stat question: means ratio test

Dear Listers,

I feel stucked with the following question.
Suppose, I have two samples from independent populations. And I whant to
test the hypothesis that one mean is as twice as the other mean, that
is:
H0: m1 = 2*m2.

It seems, doubling values for the second sample (before using standard
t-test) is not correct practice, because it will affect variance.
Is there a simple way to do such a test, and if "yes", how can I manage
it
in SPSS?

Many thanks in advance,

Anton

NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR
CONFIDENTIAL information and is intended only for the use of the
specific individual(s) to whom it is addressed. It may contain
information that is privileged and confidential under state and federal
law. This information may be used or disclosed only in accordance with
law, and you may be subject to penalties under law for improper use or
further disclosure of the information in this e-mail and its
attachments. If you have received this e-mail in error, please
immediately notify the person named above by reply e-mail, and then
delete the original e-mail. Thank you.

------------------------------

Date: Mon, 5 Mar 2007 18:52:43 +0300
From: Anton Balabanov <[hidden email]>
Subject: Re: Stat question: means ratio test

Ah... Did you mean, I should calculate all the statistics (means and
standard deviations) and then compute t-statistic "manually", substituting
sample mean m2 with 2*m2?

Indeed, it seems enough for me. I need to do it only once and do not need
more general solution. Thank you very much!

> -----Original Message-----
> From: Ornelas, Fermin [mailto:[hidden email]]
> Sent: Monday, March 05, 2007 6:31 PM
> To: Anton Balabanov; [hidden email]
> Subject: RE: Stat question: means ratio test
>
> Correct me if my interpretation of this is not right?
> But you do not go and alter the means of the second sample.
> What you should do is calculate their means as they are and
> do the test to verify that the means do not met the condition
> that you just mentioned.
>
> That is you Ho: m1_sample1= 2*(m2_sample2);
> Ha: m1_sample1 <> 2*(m2_sample2); Then use the
> two tail t-table values to see if you results validate or
> fail to reject Ho.
>
>
> Fermin Ornelas, Ph.D.
> Management Analyst III, AZ DES
> Tel: (602) 542-5639
> E-mail: [hidden email]
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]]
> On Behalf Of Anton Balabanov
> Sent: Monday, March 05, 2007 8:17 AM
> To: [hidden email]
> Subject: Stat question: means ratio test
>
> Dear Listers,
>
> I feel stucked with the following question.
> Suppose, I have two samples from independent populations. And
> I whant to test the hypothesis that one mean is as twice as
> the other mean, that
> is:
> H0: m1 = 2*m2.
>
> It seems, doubling values for the second sample (before using standard
> t-test) is not correct practice, because it will affect variance.
> Is there a simple way to do such a test, and if "yes", how
> can I manage it in SPSS?
>
> Many thanks in advance,
>
> Anton
>
> NOTICE: This e-mail (and any attachments) may contain
> PRIVILEGED OR CONFIDENTIAL information and is intended only
> for the use of the specific individual(s) to whom it is
> addressed. It may contain information that is privileged and
> confidential under state and federal law. This information
> may be used or disclosed only in accordance with law, and you
> may be subject to penalties under law for improper use or
> further disclosure of the information in this e-mail and its
> attachments. If you have received this e-mail in error,
> please immediately notify the person named above by reply
> e-mail, and then delete the original e-mail. Thank you.
>

------------------------------

Date: Mon, 5 Mar 2007 08:58:33 -0700
From: "Ornelas, Fermin" <[hidden email]>
Subject: Re: Stat question: means ratio test

Yes, that is the way to proceed. Once you get your means multiply the
second mean by the constant and calculate your t-test, then compute the
t-table values for a two tail test (assuming that you are only
interested in the means not being equal to such values) with the
corresponding degrees of freedom and the confidence level alpha.

Anytime, ...

Fermin Ornelas, Ph.D.
Management Analyst III, AZ DES
Tel: (602) 542-5639
E-mail: [hidden email]

-----Original Message-----
From: Anton Balabanov [mailto:[hidden email]]
Sent: Monday, March 05, 2007 8:53 AM
To: Ornelas, Fermin; [hidden email]
Subject: RE: Stat question: means ratio test

Ah... Did you mean, I should calculate all the statistics (means and
standard deviations) and then compute t-statistic "manually",
substituting
sample mean m2 with 2*m2?

Indeed, it seems enough for me. I need to do it only once and do not
need
more general solution. Thank you very much!

------------------------------

Date: Mon, 5 Mar 2007 09:04:14 -0700
From: "Ornelas, Fermin" <[hidden email]>
Subject: Re: Stat question: means ratio test

I see the point of you question. For example in ANOVA analysis when
there are multiple tests using SAS one can actually manually figure it
out what hypotheses about the means one is interested in testing and
these are put as statements in the program then once the output comes
out the testing of the results is conducted against the table values.

Fermin Ornelas, Ph.D.
Management Analyst III, AZ DES
Tel: (602) 542-5639
E-mail: [hidden email]

-----Original Message-----
From: Anton Balabanov [mailto:[hidden email]]
Sent: Monday, March 05, 2007 8:53 AM
To: Ornelas, Fermin; [hidden email]
Subject: RE: Stat question: means ratio test

Ah... Did you mean, I should calculate all the statistics (means and
standard deviations) and then compute t-statistic "manually",
substituting
sample mean m2 with 2*m2?

Indeed, it seems enough for me. I need to do it only once and do not
need
more general solution. Thank you very much!

------------------------------

Date: Mon, 5 Mar 2007 16:28:20 +0000
From: behnaz shirazi <[hidden email]>
Subject: Re: [BULK] frist ? character of value

Thank you so much Oliver,
It works fine for me .Just I have a original problem which I don't know how
to fix.My main problem is that I have several dates ,let's say , T1, T2,
T3....... to T24.I want to find the max T (date) .Up to now it is ok because
I get the max of all dates but each date has number and other
characteristics which I need to have them as well.But I don't know how I can
get this variables after findinf max T.
In fact I don't know after findind MAX how I can search it through my file
to catch the number of this T and other information.

Do you have any idea in this case?

I appreciated your help
Thanks again
Behnaz

>From: "Oliver, Richard" <[hidden email]>
>Reply-To: "Oliver, Richard" <[hidden email]>
>To: [hidden email]
>Subject: Re: [BULK] frist ? character of value
>Date: Fri, 2 Mar 2007 12:30:38 -0600
>
>In this case, it would appear that you want everything prior to "|", so:
>
>*create some sample data.
>data list list (",") /oldstring (a15).
>begin data
>1|01/02/2005
>1|02/03/2005
>14|04/08/2006
>end data.
>*now the code to create the new variable.
>string newstring (a3).
>compute newstring=substr(oldstring, 1, index(oldstring, "|")-1).
>execute. /*to see the result immediately.
>
>-----Original Message-----
>From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
>behnaz shirazi
>Sent: Friday, March 02, 2007 12:03 PM
>To: [hidden email]
>Subject: [BULK] frist ? character of value
>Importance: Low
>
>Hello Dear All,
>
>I wonder if you know how I can get the 2 or 3 first character of a
>value.for
>example I have XX variable with following value:
>
>1|01/02/2005
>1|02/03/2005
>14|04/08/2006
>..
>..
>I want to create a new variable from this variable which contains just
>frist
>2 or 3 character of this values:
>1
>1
>14
>
>
>Do you have any idea?
>
>Thanks in advance
>Behnaz Shirazi
>
>
>
>
>
>..
>
>_________________________________________________________________
>FREE pop-up blocking with the new MSN Toolbar - get it now!
>http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

------------------------------

Date: Mon, 5 Mar 2007 11:42:33 -0500
From: "Roberts, Michael" <[hidden email]>
Subject: Re: Multiple Files to Open & Analyze

Hi Will,

If you are using ver. 14 or better, the programmability option
simplifies what you are trying to do. In ver. 14.01 (version 15 has it
built in) you will need to download the integration package, (available
from SPSS' website), the Python (freeware) from their website, the
modules from SPSS' website, load everything following programmability
directions available on SPSS' site, and you should be good to go.

I was facing the same knotty problem, and with help from Jon Peck and
John Bauer was up and running very shortly thereafter.

HTH

Mike

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Will Bailey [Statman]
Sent: Saturday, March 03, 2007 8:29 AM
To: [hidden email]
Subject: Multiple Files to Open & Analyze

A client has this situation:

About 200 files over which we have to run a syntax. All the files are
named after the subject number, e.g. 10001_R4.sav

The syntax starts with opening the file, e.g. GET
FILE="H:\10001_R4.sav".
Then there are several analyses and next we save the file, e.g.
OUTFILE="H:\10001_G4.sav" (thus, under a different name: R4->G4)

They currently have to change the name every time we want to run the
syntax; replace 10001 by 10002 to get the next file (we use ctrl H, find
and replace).

Does anyone know if there is some sort of loop function which allows us
to automatically change and run the syntax? Thanks for the help!
================

Tks,
Will

------------------------------

Date: Mon, 5 Mar 2007 12:05:57 -0500
From: Claudiu Tufis <[hidden email]>
Subject: SPSS 15 and AMOS 7 under Vista OS

Hi all,

Just an update and a question regarding Vista compatibility.

I got a new computer with Vista, I installed SPSS 15 and AMOS 7 and was able
to license them using the authorization wizard without any problems.

After a restart, both SPSS and AMOS stopped working, giving me a license
error message.

I uninstalled both, reinstalled them again and asked for a trial license.
Surprise . it worked.

Right now I am able to run analyses using the trial license, which expires
in 2 weeks. (The only incompatibility I found was that SPSS does not work
with Vista's Aero interface and forces Vista to switch to the regular
interface.)

However, if I try to license the software using my license, the
authorization wizard runs, it says authorization was successful, but the
license is not updated: both SPSS and AMOS remain on the trial license.

I called tech support and when they found out I was on a Vista system they
did not even want to try and solve the problem.

All the tech guy told me was basically "Kudos to you for managing to install
and run SPSS with a trial license, but we do not support SPSS under Vista"

His suggestion was to wait for SPSS 16 and buy the new version, a solution I
find a little bit offensive.

SPSS knew for a long time that Vista was coming but it seems like they did
not eve try to make their product compatible with it. A very disappointing
business attitude towards the customer.

Did anyone manage to license SPSS 15 under Vista?

Does anybody know if (and when) SPSS is going to come out with a patch that
will make SPSS run under Vista?

It seems like SPSS does not care very much about my problem (because I am
just an individual user) but some of you may have a better relationship with
SPSS and my know more about this issue.

Best,

Claudiu Tufis

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Claudiu Tufis

Graduate student

314 Pond Laboratory

Department of Political Science

Penn State University

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

------------------------------

Date: Mon, 5 Mar 2007 19:44:40 +0100
From: Balmer Thomas <[hidden email]>
Subject: Re: AW: Re: Import values in a part of the cases

Thanks, Melissa, for your patience.

I've tried it now this way and got a new error: SPSS claims: Each case =
on a TABLE file in MATCH FILES must be uniquely identified by the by =
variables.

Thats probably not the case: In the A-File (*-File) are different cases =
with the same BY-variables Nachname and Vorname. They are unique only in =
the TABLE file. But thats exactly what Iwant: to put in the A-file by =
all these matching cases the values of different variables from the =
B-file (TABLE file). But first I have to rename the variables in the =
B-file in order to be the same as in the A-file. So I ended with this =
Syntax and the mentioned error:
MATCH FILES
/TABLE=3D'B1'
/RENAME Name=3DNachname Mail_g=3DEmail Ort_Wohn=3DOrt =
Str_Wohn=3DStrasse =20
/FILE=3D*
/BY Nachname Vorname.
EXE.

-----Urspr=FCngliche Nachricht-----
Von: SPSSX(r) Discussion im Auftrag von Melissa Ives
Gesendet: Mo 05.03.2007 16:27
An: [hidden email]
Betreff: Re: AW: Re: Import values in a part of the cases
=20
Thomas,

(As noted in my message to you on Fri 3/2/2007 11:28 AM) Remember that =
the order of the files matters, so IF the variables you want to add from =
the lookup table are already IN the main file, then the /TABLE=3D =
subcommand needs to come BEFORE the /FILE=3D subcommand. (works the =
same way in regular match with 2 (or more) /FILE=3D statements) If a =
variable is common to both files, the one in the first listed file is =
what is retained.

So you would need to switch your file order in the MATCH command to be:
MATCH FILES
/TABLE=3D'B1'
/FILE=3D*
/RENAME Name=3DNachname Mail_g=3DEmail Ort_Wohn=3DOrt =
Str_Wohn=3DStrasse /DROP=3D Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 =
Sex /BY Nachname Vorname.
EXE.

Melissa
The bubbling brook would lose its song if you removed the rocks.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of =
Balmer Thomas
Sent: Monday, March 05, 2007 3:02 AM
To: [hidden email]
Subject: [SPSSX-L] AW: Re: Import values in a part of the cases

I tried the TABLE subcommand like this:

MATCH FILES /FILE=3D*
/TABLE=3D'B1'
/RENAME Name=3DNachname Mail_g=3DEmail Ort_Wohn=3DOrt Str_Wohn=3DStrasse =
/DROP=3D Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname =
Vorname.
EXE.

...renaming variables in the file B1 to match with the variables in the =
*-file (which is the master) and droping a few.
Strange Result: Nothing. The Syntax seems to work, because I got no =
error, but the values from B1 are not printed in the file *.

-----Urspr=FCngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:[hidden email]] Im Auftrag =
von Melissa Ives
Gesendet: Freitag, 2. M=E4rz 2007 16:30
An: [hidden email]
Betreff: Re: Import values in a part of the cases

You may want to use TABLE instead of UPDATE. Look at the Operations of =
each to see which one retains the records you want. In TABLE, only =
records that match in the FILE are included. In UPDATE, new records are =
created in the master file if they are in the update file but not in the =
master. I believe this means that they would work similarly IF you have =
exactly the same records (per the matching variables) in both files.

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of =
Balmer Thomas
Sent: Friday, March 02, 2007 7:01 AM
To: [hidden email]
Subject: [SPSSX-L] Import values in a part of the cases

Hi

The aim would be to import values of a couple of string variables in =
these cases, which match with the values of two variables (Firstname and =
Name).

But the matching command seems to allow just two other purposes: to add =
new variables or to add new cases. I'd like to import just the values =
in existing variables (Street, Town, Email) for the matching cases, =
without adding new variables or cases.

It's probably a total different command I need...

Thanks for Help!

Tom

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND =
CONFIDENTIAL information and is intended only for the use of the =
addressee. If you are not the designated recipient, or an employee or =
agent authorized to deliver such transmittals to the designated =
recipient, you are hereby notified that any dissemination, copying or =
publication of this transmittal is strictly prohibited. If you have =
received this transmittal in error, please notify us immediately by =
replying to the sender and delete this copy from your system. You may =
also call us at (309) 827-6026 for assistance.

------------------------------

Date: Mon, 5 Mar 2007 10:47:40 -0800
From: Dennis Deck <[hidden email]>
Subject: Re: Exporting file from Blackboard to Excel to SPSS

I assume from this that:
Each course is identified by a number or string
The course variable imports as a string that contains up to 18 course
responses delimited by some character (probably a space or comma)

Given these assumptions, you will need to "parse" the string to separate
out the individual responses. The parsing algorithm will depend on how
the string is laid out. For example, assuming every response (including
last) has a trailing space, the code might be something like:

/* the following checks for each of 18 course strings (c) and assigns 0
or 1 to the corresponding expanded course variable */
DO REPEAT
x = x1 to x18
/c = 'C1 ' 'C2 ' 'C3 ' . . . 'C18 ' .
+ COMPUTE x = (INDEX(strvar,c) > 0) .
END REPEAT .

You will need to clarify your question if this does not help.

Dennis Deck, PhD
RMC Research Corporation
[hidden email]
-----Original Message-----
From: Martin Sherman [mailto:[hidden email]]
Sent: Friday, March 02, 2007 11:44 AM
Subject: Exporting file from Blackboard to Excel to SPSS

Dear List: I just received an Excel Data file that has a variable which
includes up to 18 responses. That is, students had to indicate which
courses they took from a list of 18 (thus a student could have eighteen
responses on this variable). When exported from Blackboard to Excel the
list of courses can occupy over 1000 columns. When importing to SPSS one
is only able to see the first 50 columns within the data view. What I
really need is a way to expand the responses so that each potential
course that a student took occupies its own variable. Thus what I want
is 18 variables from which I can then work with. Any suggestions. I
recognize that this is a bit confusing. It would have been better if the
investigator had consulted with me before hand and I would not have this
problem. For example if one uses SurveyMonkey one can import a data
file which Expands the potential responses where one allows multiple
responses. Thanks. martin sherman

------------------------------

Date: Mon, 5 Mar 2007 14:10:30 -0500
From: "Valdiserri, Colin" <[hidden email]>
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

I just ordered a notebook with Vista Business and will get the chance to
see if I can get SPSS to work on Vista.

I agree, SPSS as well as all other software developers new this was
coming out, why can't they create a patch to work earlier versions with
Vista.

I find it offensive too and reinforces the monopoly SPSS has and how
they plan to enjoy it.

Something needs to be done to get this to work with Vista.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Claudiu Tufis
Sent: Monday, March 05, 2007 12:06 PM
To: [hidden email]
Subject: SPSS 15 and AMOS 7 under Vista OS

Hi all,

Just an update and a question regarding Vista compatibility.

I got a new computer with Vista, I installed SPSS 15 and AMOS 7 and was
able
to license them using the authorization wizard without any problems.

After a restart, both SPSS and AMOS stopped working, giving me a license
error message.

I uninstalled both, reinstalled them again and asked for a trial
license.
Surprise . it worked.

Right now I am able to run analyses using the trial license, which
expires
in 2 weeks. (The only incompatibility I found was that SPSS does not
work
with Vista's Aero interface and forces Vista to switch to the regular
interface.)

However, if I try to license the software using my license, the
authorization wizard runs, it says authorization was successful, but the
license is not updated: both SPSS and AMOS remain on the trial license.

I called tech support and when they found out I was on a Vista system
they
did not even want to try and solve the problem.

All the tech guy told me was basically "Kudos to you for managing to
install
and run SPSS with a trial license, but we do not support SPSS under
Vista"

His suggestion was to wait for SPSS 16 and buy the new version, a
solution I
find a little bit offensive.

SPSS knew for a long time that Vista was coming but it seems like they
did
not eve try to make their product compatible with it. A very
disappointing
business attitude towards the customer.

Did anyone manage to license SPSS 15 under Vista?

Does anybody know if (and when) SPSS is going to come out with a patch
that
will make SPSS run under Vista?

It seems like SPSS does not care very much about my problem (because I
am
just an individual user) but some of you may have a better relationship
with
SPSS and my know more about this issue.

Best,

Claudiu Tufis

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Claudiu Tufis

Graduate student

314 Pond Laboratory

Department of Political Science

Penn State University

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

_______________________________________________
This message was scanned for viruses prior to entering the Moen network

_______________________________________________________________________

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
_______________________________________________________________________

------------------------------

Date: Mon, 5 Mar 2007 13:15:21 -0600
From: Melissa Ives <[hidden email]>
Subject: Re: AW: Re: Import values in a part of the cases

Dear listers, to complete this thread, I am including my response to Thomas below. (Note that the syntax is untested).
Thomas, please note the small edit in the 4th line.

This error says that the records in your TABLE file has more than one record with the same Nachname and Vorname.

Try running the wizard for identifying duplicate cases on the Data menu.

Alternatively (if you don't have that option on the Data menu (I think it was added in V. 14) you could use the following syntax to get a list of the duplicate combination(s):

Sort cases by Nachname Vorname.
Compute dupeNN=0.
If (nachname=lag(nachname) and vorname=lag(vorname)) dupeNN=1.
Freq dupenn.

Temp.
Sel if dupenn=1.
List vars=nachname vorname (and any other variables you need to see to find the duplicates).

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Balmer Thomas
Sent: Monday, March 05, 2007 12:45 PM
To: [hidden email]
Subject: Re: [SPSSX-L] AW: Re: Import values in a part of the cases

Thanks, Melissa, for your patience.

I've tried it now this way and got a new error: SPSS claims: Each case on a TABLE file in MATCH FILES must be uniquely identified by the by variables.

Thats probably not the case: In the A-File (*-File) are different cases with the same BY-variables Nachname and Vorname. They are unique only in the TABLE file. But thats exactly what Iwant: to put in the A-file by all these matching cases the values of different variables from the B-file (TABLE file). But first I have to rename the variables in the B-file in order to be the same as in the A-file. So I ended with this Syntax and the mentioned error:
MATCH FILES
/TABLE='B1'
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse
/FILE=*
/BY Nachname Vorname.
EXE.

-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion im Auftrag von Melissa Ives
Gesendet: Mo 05.03.2007 16:27
An: [hidden email]
Betreff: Re: AW: Re: Import values in a part of the cases

Thomas,

(As noted in my message to you on Fri 3/2/2007 11:28 AM) Remember that the order of the files matters, so IF the variables you want to add from the lookup table are already IN the main file, then the /TABLE= subcommand needs to come BEFORE the /FILE= subcommand. (works the same way in regular match with 2 (or more) /FILE= statements) If a variable is common to both files, the one in the first listed file is what is retained.

So you would need to switch your file order in the MATCH command to be:
MATCH FILES
/TABLE='B1'
/FILE=*
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse /DROP= Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname Vorname.
EXE.

Melissa
The bubbling brook would lose its song if you removed the rocks.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Balmer Thomas
Sent: Monday, March 05, 2007 3:02 AM
To: [hidden email]
Subject: [SPSSX-L] AW: Re: Import values in a part of the cases

I tried the TABLE subcommand like this:

MATCH FILES /FILE=*
/TABLE='B1'
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse /DROP= Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname Vorname.
EXE.

...renaming variables in the file B1 to match with the variables in the *-file (which is the master) and droping a few.
Strange Result: Nothing. The Syntax seems to work, because I got no error, but the values from B1 are not printed in the file *.

-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:[hidden email]] Im Auftrag von Melissa Ives
Gesendet: Freitag, 2. März 2007 16:30
An: [hidden email]
Betreff: Re: Import values in a part of the cases

You may want to use TABLE instead of UPDATE. Look at the Operations of each to see which one retains the records you want. In TABLE, only records that match in the FILE are included. In UPDATE, new records are created in the master file if they are in the update file but not in the master. I believe this means that they would work similarly IF you have exactly the same records (per the matching variables) in both files.

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Balmer Thomas
Sent: Friday, March 02, 2007 7:01 AM
To: [hidden email]
Subject: [SPSSX-L] Import values in a part of the cases

Hi

The aim would be to import values of a couple of string variables in these cases, which match with the values of two variables (Firstname and Name).

But the matching command seems to allow just two other purposes: to add new variables or to add new cases. I'd like to import just the values in existing variables (Street, Town, Email) for the matching cases, without adding new variables or cases.

It's probably a total different command I need...

Thanks for Help!

Tom

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND CONFIDENTIAL information and is intended only for the use of the addressee. If you are not the designated recipient, or an employee or agent authorized to deliver such transmittals to the designated recipient, you are hereby notified that any dissemination, copying or publication of this transmittal is strictly prohibited. If you have received this transmittal in error, please notify us immediately by replying to the sender and delete this copy from your system. You may also call us at (309) 827-6026 for assistance.

------------------------------

Date: Mon, 5 Mar 2007 12:27:06 -0700
From: David Wasserman <[hidden email]>
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

The tech support section of the SPSS web site states clearly that no version
of SPSS is compatible with Windows Vista. I experienced the same problems
as other have reported, and am unable to use SPSS 15.0 on my Home Vista
Premium desktop computer. I received no reply to an e-mail to SPSS tech
support.

Despite the web site, SPSS 13 seems to run ok under Vista. There are a
couple of error messages that come up on first opening SPSS, but analyses
and syntax that I tried ran correctly.

David Wasserman
Custom Data Analysis and SPSS Programming

----- Original Message -----
From: "Valdiserri, Colin" <[hidden email]>
To: <[hidden email]>
Sent: Monday, March 05, 2007 12:10 PM
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

>I just ordered a notebook with Vista Business and will get the chance to
> see if I can get SPSS to work on Vista.
>
> I agree, SPSS as well as all other software developers new this was
> coming out, why can't they create a patch to work earlier versions with
> Vista.
>
> I find it offensive too and reinforces the monopoly SPSS has and how
> they plan to enjoy it.
>
> Something needs to be done to get this to work with Vista.
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Claudiu Tufis
> Sent: Monday, March 05, 2007 12:06 PM
> To: [hidden email]
> Subject: SPSS 15 and AMOS 7 under Vista OS
>
> Hi all,
>
>
>
> Just an update and a question regarding Vista compatibility.
>
>
>
> I got a new computer with Vista, I installed SPSS 15 and AMOS 7 and was
> able
> to license them using the authorization wizard without any problems.
>
> After a restart, both SPSS and AMOS stopped working, giving me a license
> error message.
>
> I uninstalled both, reinstalled them again and asked for a trial
> license.
> Surprise . it worked.
>
>
>
> Right now I am able to run analyses using the trial license, which
> expires
> in 2 weeks. (The only incompatibility I found was that SPSS does not
> work
> with Vista's Aero interface and forces Vista to switch to the regular
> interface.)
>
> However, if I try to license the software using my license, the
> authorization wizard runs, it says authorization was successful, but the
> license is not updated: both SPSS and AMOS remain on the trial license.
>
>
>
> I called tech support and when they found out I was on a Vista system
> they
> did not even want to try and solve the problem.
>
> All the tech guy told me was basically "Kudos to you for managing to
> install
> and run SPSS with a trial license, but we do not support SPSS under
> Vista"
>
> His suggestion was to wait for SPSS 16 and buy the new version, a
> solution I
> find a little bit offensive.
>
> SPSS knew for a long time that Vista was coming but it seems like they
> did
> not eve try to make their product compatible with it. A very
> disappointing
> business attitude towards the customer.
>
>
>
> Did anyone manage to license SPSS 15 under Vista?
>
> Does anybody know if (and when) SPSS is going to come out with a patch
> that
> will make SPSS run under Vista?
>
> It seems like SPSS does not care very much about my problem (because I
> am
> just an individual user) but some of you may have a better relationship
> with
> SPSS and my know more about this issue.
>
>
>
> Best,
>
> Claudiu Tufis
>
>
>
>
>
>
>
>
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Claudiu Tufis
>
> Graduate student
>
>
>
> 314 Pond Laboratory
>
> Department of Political Science
>
> Penn State University
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> _______________________________________________
> This message was scanned for viruses prior to entering the Moen network
>
>
> _______________________________________________________________________
>
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this in error, please contact the sender and delete the material from any
> computer.
> _______________________________________________________________________
>

------------------------------

Date: Mon, 5 Mar 2007 14:34:10 -0500
From: "Valdiserri, Colin" <[hidden email]>
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

I would really lie to hear what a rep from SPSS has to say about this
instead of ignoring it.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
David Wasserman
Sent: Monday, March 05, 2007 2:27 PM
To: [hidden email]
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

The tech support section of the SPSS web site states clearly that no
version
of SPSS is compatible with Windows Vista. I experienced the same
problems
as other have reported, and am unable to use SPSS 15.0 on my Home Vista
Premium desktop computer. I received no reply to an e-mail to SPSS tech
support.

Despite the web site, SPSS 13 seems to run ok under Vista. There are a
couple of error messages that come up on first opening SPSS, but
analyses
and syntax that I tried ran correctly.

David Wasserman
Custom Data Analysis and SPSS Programming

----- Original Message -----
From: "Valdiserri, Colin" <[hidden email]>
To: <[hidden email]>
Sent: Monday, March 05, 2007 12:10 PM
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

>I just ordered a notebook with Vista Business and will get the chance
to
> see if I can get SPSS to work on Vista.
>
> I agree, SPSS as well as all other software developers new this was
> coming out, why can't they create a patch to work earlier versions
with
> Vista.
>
> I find it offensive too and reinforces the monopoly SPSS has and how
> they plan to enjoy it.
>
> Something needs to be done to get this to work with Vista.
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf
Of

> Claudiu Tufis
> Sent: Monday, March 05, 2007 12:06 PM
> To: [hidden email]
> Subject: SPSS 15 and AMOS 7 under Vista OS
>
> Hi all,
>
>
>
> Just an update and a question regarding Vista compatibility.
>
>
>
> I got a new computer with Vista, I installed SPSS 15 and AMOS 7 and

was
> able
> to license them using the authorization wizard without any problems.
>
> After a restart, both SPSS and AMOS stopped working, giving me a
license

> error message.
>
> I uninstalled both, reinstalled them again and asked for a trial
> license.
> Surprise . it worked.
>
>
>
> Right now I am able to run analyses using the trial license, which
> expires
> in 2 weeks. (The only incompatibility I found was that SPSS does not
> work
> with Vista's Aero interface and forces Vista to switch to the regular
> interface.)
>
> However, if I try to license the software using my license, the
> authorization wizard runs, it says authorization was successful, but

the
> license is not updated: both SPSS and AMOS remain on the trial
license.

>
>
>
> I called tech support and when they found out I was on a Vista system
> they
> did not even want to try and solve the problem.
>
> All the tech guy told me was basically "Kudos to you for managing to
> install
> and run SPSS with a trial license, but we do not support SPSS under
> Vista"
>
> His suggestion was to wait for SPSS 16 and buy the new version, a
> solution I
> find a little bit offensive.
>
> SPSS knew for a long time that Vista was coming but it seems like they
> did
> not eve try to make their product compatible with it. A very
> disappointing
> business attitude towards the customer.
>
>
>
> Did anyone manage to license SPSS 15 under Vista?
>
> Does anybody know if (and when) SPSS is going to come out with a patch
> that
> will make SPSS run under Vista?
>
> It seems like SPSS does not care very much about my problem (because I
> am
> just an individual user) but some of you may have a better

relationship

> with
> SPSS and my know more about this issue.
>
>
>
> Best,
>
> Claudiu Tufis
>
>
>
>
>
>
>
>
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Claudiu Tufis
>
> Graduate student
>
>
>
> 314 Pond Laboratory
>
> Department of Political Science
>
> Penn State University
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> _______________________________________________
> This message was scanned for viruses prior to entering the Moen

network
>
>
>
_______________________________________________________________________
>
> The information transmitted is intended only for the person or entity
to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of,
or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you
received
> this in error, please contact the sender and delete the material from
any
> computer.
>
_______________________________________________________________________
>

_______________________________________________
This message was scanned for viruses prior to entering the Moen network

_______________________________________________________________________

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
_______________________________________________________________________

------------------------------

Date: Mon, 5 Mar 2007 20:37:39 +0100
From: =?us-ascii?Q?Jerabek=20Jindrich?= <[hidden email]>
Subject: =?us-ascii?Q?Re=3AReverse=20autorecode=20syntax?=

Hello Max,

You can turn numeric variable into string / or string to num with the Autorecode command.
Menu/Transform/Autorecode ...

The syntax is
AUTORECODE
VARIABLES=var00001 /INTO NewVar
/DESCENDING /*optional, Descending reverse the value order - highest value coded as the lowest */.

HTH
Jindra

> ------------ Pùvodní zpráva ------------
> Od: Max Bell <[hidden email]>
> Pøedmìt: Reverse autorecode syntax
> Datum: 05.3.2007 13:11:10
> ----------------------------------------
> Dear List,
>
> I'm loooking for syntax to do reverse autorecode. I want to create a new
> string variable based on the values of an existing variable. I found
> this script
> Reverse autorecode.SBS <Scripts/Labels/ReverseAutorecode.txt> To create
> a new string variable containing the value labels of an existing
> variable (this can also be done using syntax alone)
>
> But the mentioned syntax I cannot find. Who can help me?
>
>
> Thanks in advance,
> Max
>
>
>

------------------------------

Date: Mon, 5 Mar 2007 15:42:48 -0500
From: Claudiu Tufis <[hidden email]>
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

The thing that bothers me the most is that SPSS 15 runs on Vista with a
trial license but I cannot update my license. This suggests to me that the
problem is not with SPSS but with the License Activation program they are
using.

For a company that claims to offer the best predictive solution, SPSS Inc.
failed miserably to predict that once Vista is available people would start
using it and they would still like to use the software they need.

The tech support was a joke. First he tried to explain to me that rewriting
the code for Vista would take months (what have they done until now - it's
not like they had to wait for a retail copy to see how to write code for
Vista) and then he offered me two solutions: either uninstall Vista and
downgrade to XP, or wait for SPSS 16. Seriously? Is this all they can come
up with?

Maybe it's time to rethink their approach to customer support.

Claudiu Tufis

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
David Wasserman
Sent: Monday, March 05, 2007 2:27 PM
To: [hidden email]
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

The tech support section of the SPSS web site states clearly that no version
of SPSS is compatible with Windows Vista. I experienced the same problems
as other have reported, and am unable to use SPSS 15.0 on my Home Vista
Premium desktop computer. I received no reply to an e-mail to SPSS tech
support.

Despite the web site, SPSS 13 seems to run ok under Vista. There are a
couple of error messages that come up on first opening SPSS, but analyses
and syntax that I tried ran correctly.

David Wasserman
Custom Data Analysis and SPSS Programming

----- Original Message -----
From: "Valdiserri, Colin" <[hidden email]>
To: <[hidden email]>
Sent: Monday, March 05, 2007 12:10 PM
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

> The thing that bothers me the most is that SPSS 15 runs on Vista with a
> trial license but I cannot update my license. This suggests to me that the
> problem is not with SPSS but with the License Activation program they are
> using.
>
> For a company that claims to offer the best predictive solution, SPSS Inc.
> failed miserably to predict that once Vista is available people would start
> using it and they would still like to use the software they need.
>
> The tech support was a joke. First he tried to explain to me that rewriting
> the code for Vista would take months (what have they done until now - it's
> not like they had to wait for a retail copy to see how to write code for
> Vista) and then he offered me two solutions: either uninstall Vista and
> downgrade to XP, or wait for SPSS 16. Seriously? Is this all they can come
> up with?
>
> Maybe it's time to rethink their approach to customer support.
>
> Claudiu Tufis
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> David Wasserman
> Sent: Monday, March 05, 2007 2:27 PM
> To: [hidden email]
> Subject: Re: SPSS 15 and AMOS 7 under Vista OS
>
> The tech support section of the SPSS web site states clearly that no version
> of SPSS is compatible with Windows Vista. I experienced the same problems
> as other have reported, and am unable to use SPSS 15.0 on my Home Vista
> Premium desktop computer. I received no reply to an e-mail to SPSS tech
> support.
>
> Despite the web site, SPSS 13 seems to run ok under Vista. There are a
> couple of error messages that come up on first opening SPSS, but analyses
> and syntax that I tried ran correctly.
>
> David Wasserman
> Custom Data Analysis and SPSS Programming
>
> ----- Original Message -----
> From: "Valdiserri, Colin" <[hidden email]>
> To: <[hidden email]>
> Sent: Monday, March 05, 2007 12:10 PM
> Subject: Re: SPSS 15 and AMOS 7 under Vista OS
>
>
>> I just ordered a notebook with Vista Business and will get the chance to
>> see if I can get SPSS to work on Vista.
>>
>> I agree, SPSS as well as all other software developers new this was
>> coming out, why can't they create a patch to work earlier versions with
>> Vista.
>>
>> I find it offensive too and reinforces the monopoly SPSS has and how
>> they plan to enjoy it.
>>
>> Something needs to be done to get this to work with Vista.
>>
>> -----Original Message-----
>> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
>> Claudiu Tufis
>> Sent: Monday, March 05, 2007 12:06 PM
>> To: [hidden email]
>> Subject: SPSS 15 and AMOS 7 under Vista OS
>>
>> Hi all,
>>
>>
>>
>> Just an update and a question regarding Vista compatibility.
>>
>>
>>
>> I got a new computer with Vista, I installed SPSS 15 and AMOS 7 and was
>> able
>> to license them using the authorization wizard without any problems.
>>
>> After a restart, both SPSS and AMOS stopped working, giving me a license
>> error message.
>>
>> I uninstalled both, reinstalled them again and asked for a trial
>> license.
>> Surprise . it worked.
>>
>>
>>
>> Right now I am able to run analyses using the trial license, which
>> expires
>> in 2 weeks. (The only incompatibility I found was that SPSS does not
>> work
>> with Vista's Aero interface and forces Vista to switch to the regular
>> interface.)
>>
>> However, if I try to license the software using my license, the
>> authorization wizard runs, it says authorization was successful, but the
>> license is not updated: both SPSS and AMOS remain on the trial license.
>>
>>
>>
>> I called tech support and when they found out I was on a Vista system
>> they
>> did not even want to try and solve the problem.
>>
>> All the tech guy told me was basically "Kudos to you for managing to
>> install
>> and run SPSS with a trial license, but we do not support SPSS under
>> Vista"
>>
>> His suggestion was to wait for SPSS 16 and buy the new version, a
>> solution I
>> find a little bit offensive.
>>
>> SPSS knew for a long time that Vista was coming but it seems like they
>> did
>> not eve try to make their product compatible with it. A very
>> disappointing
>> business attitude towards the customer.
>>
>>
>>
>> Did anyone manage to license SPSS 15 under Vista?
>>
>> Does anybody know if (and when) SPSS is going to come out with a patch
>> that
>> will make SPSS run under Vista?
>>
>> It seems like SPSS does not care very much about my problem (because I
>> am
>> just an individual user) but some of you may have a better relationship
>> with
>> SPSS and my know more about this issue.
>>
>>
>>
>> Best,
>>
>> Claudiu Tufis
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>> Claudiu Tufis
>>
>> Graduate student
>>
>>
>>
>> 314 Pond Laboratory
>>
>> Department of Political Science
>>
>> Penn State University
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>> _______________________________________________
>> This message was scanned for viruses prior to entering the Moen network
>>
>>
>> _______________________________________________________________________
>>
>> The information transmitted is intended only for the person or entity to
>> which it is addressed and may contain confidential and/or privileged
>> material. Any review, retransmission, dissemination or other use of, or
>> taking of any action in reliance upon, this information by persons or
>> entities other than the intended recipient is prohibited. If you received
>> this in error, please contact the sender and delete the material from any
>> computer.
>> _______________________________________________________________________
>>

------------------------------

Date: Tue, 6 Mar 2007 05:08:07 +0530
From: Manmit Shrimali <[hidden email]>
Subject: Looping and merging syntax support

Dear All:

=20

I am writing after considerable amount of efforts with no results. I
have slightly tricky situation. Below is the case.

=20

Q1. Question read : Including the current trip how many trips you had in
last 10 years - if greater than one trip in any year count that as 1 for
that year.

Q2. For the year 2000 and onwards please provide all the places where
you stayed (there are 2 hotels- if respondent stayed in the hotel, they
select 1 else it will be 0). Respondent can select multiple hotels in
year. We ask data only for prior trip i.e. not including the current.
Repeat the cycle for maximum upto 5 times. Do not ask pre-2000 year
data.

=20

Data file1, based on above e.g. looks like this.

Total_trip_old Trip # in year 2000 Hotel_a_5
Hotel_b_5 Hotel_a_4 Hotel_b_4

10 9 1
0 . .

=20

Hotel_a_4 and hotel_b_4 is empty as we do not ask pre 2000 year data.

=20

Hotel_a_5 is cycle 5th and Hotel_b_4 is cycle 4 and so on. So if someone
has mentioned 10 in total trip and 9 in year 2000 then he will answer
only for cycle one. If someone has mentioned 9 in total_trip_old and 1
in trip # then we will take data for 8, 7,6,5 and 4th trip.

=20

Data file 2: We re-fielded the survey and then from same respondents
collected the data for pre-2000. However, this time we did not limit to
only five cycles but had asked all prior trips. =20

=20

Total_trip_new Trip # in year 2000 Hotel_a_1 Hotel_b_1
Hotel_a_2 Hotel_b_2

=20

=20

Problem: I need to merge the data file 1 with data file 2.

=20

How to do that? This is what I have so far:

=20

Comp diff=3Dtotal_trip_old-trip#.

vector hotel_old=3D hotel_a_5 to hotel_b_1.

vector hotel_new=3D hotel_a_5_new to hotel_b_1_new.

loop #A=3D1 to 26.

do if diff=3D1.

comp hotel_old (#a)=3D hotel_a_5_new .

end if.

end loop.

=20

Eventually I need to create a data there has records of all the prior
trips of respondent.

=20

Any help is greatly appreciated.

=20

Manmiot

------------------------------

Date: Mon, 5 Mar 2007 19:40:55 -0500
From: Richard Ristow <[hidden email]>
Subject: Re: Looping and merging syntax support

At 06:38 PM 3/5/2007, Manmit Shrimali wrote:

Your question comes through hard to understand. Let me ask for some
clarifications:

You have two files for the same respondents,

To start with: How many records in each file, for each respondent? Can
it be more than one?

Then, are you trying to end up with one record per respondent, or more?

If you can, give us the EXACT list of variables in your two files.

>Problem: I need to merge the data file 1 with data file 2.
>
>How to do that? This is what I have so far:
>
>Comp diff=total_trip_old-trip#.
>vector hotel_old= hotel_a_5 to hotel_b_1.
>vector hotel_new= hotel_a_5_new to hotel_b_1_new.
>loop #A=1 to 26.
>do if diff=1.
>comp hotel_old (#a)= hotel_a_5_new .
>end if.
>end loop.

The problem is, this has nothing to do with merging the files. That may
be a MATCH FILES or an ADD FILES, depending on what your files look
like, and what you want.

------------------------------

Date: Mon, 5 Mar 2007 19:43:01 -0500
From: Richard Ristow <[hidden email]>
Subject: Re: Reverse autorecode syntax

At 07:06 AM 3/5/2007, Max Bell wrote:

>I'm loooking for syntax to do reverse autorecode. I want to create a
>new
>string variable based on the values of an existing variable. I found
>this script
>Reverse autorecode.SBS <Scripts/Labels/ReverseAutorecode.txt> To
>create a new string variable containing the value labels of an
>existing variable (this can also be done using syntax alone)

In SPSS 14 and 15, there's the VALUELABEL function to do exactly what
you want. Does this do it, or are you running an earlier release?

------------------------------

Date: Tue, 6 Mar 2007 07:20:54 +0530
From: Manmit Shrimali <[hidden email]>
Subject: Re: Looping and merging syntax support

Clarifications:
File 1 has 150 records and file 2nd has 150 records. The data is from
hotel so there can be multiple same ID's in both the file. I don't need
to have one record for multiple ID's. I simply want to merge pre 2000
data with the post 2000 data in file 1.

Variables in file 1 (2000>). Maximum file cycles so if someone says 11
as total trips, and was on 9th trip in year 2000 then we will ask the
cycle for 10th, and 9th trip as pre-2000 we ask in file 2. For this
respondent the data will be in Q36_5.....and Q36_4.
Total_trips
Trip_no_in_year_2000
Q36_Marriott_5
q36_Hyatt_5
Q36_Four_season_5
Q36_Marriott_4
q36_Hyatt_4
Q36_Four_season_4
Q36_Marriott_3
q36_Hyatt_3
Q36_Four_season_3
Q36_Marriott_2
q36_Hyatt_2
Q36_Four_season_2
Q36_Marriott_1
q36_Hyatt_1
Q36_Four_season_1

Data file 2 - there can be maximum 19 trips: For above mentioned case,
the respondent's pre-2000 year will be in variable q36_8th till q36_1

Q36_Marriott_19
q36_Hyatt_19
Q36_Four_season_19
TO.....
Q36_Marriott_4
q36_Hyatt_4
Q36_Four_season_4
Q36_Marriott_3
q36_Hyatt_3
Q36_Four_season_3
Q36_Marriott_2
q36_Hyatt_2
Q36_Four_season_2
Q36_Marriott_1
q36_Hyatt_1
Q36_Four_season_1

Now, I want to merge the pre-2000 data of above case into file 1 so that
I have data from his 1st trip till 10th trip.

Hope I have communicated in required form.

Thanks for your input

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Richard Ristow
Sent: Tuesday, March 06, 2007 6:11 AM
To: [hidden email]
Subject: Re: Looping and merging syntax support

At 06:38 PM 3/5/2007, Manmit Shrimali wrote:

Your question comes through hard to understand. Let me ask for some
clarifications:

You have two files for the same respondents,

To start with: How many records in each file, for each respondent? Can
it be more than one?

Then, are you trying to end up with one record per respondent, or more?

If you can, give us the EXACT list of variables in your two files.

>I have files consisting of 5 variables:
>
>1. Condition - which can be one of is one of 3 basic tasks: tapping
>in synch with a sound (Synch), tapping without a sound (Unpaced) and
>tapping in synch with a sound in preparation for Unpaced (Paced), each
>of which is done seperately with the right hand (R), left hand (L) and
>with both together (B), and repeated 3 times (so 27 different
>'conditions'.)
>
>2. RT - which is a timestamp for a response press or release
>
>3. Response - which is 8 for a press and 8.5 for a release with the
>right hand and 7 for a press / 7.5 for a release with the left hand
>
>4. soundon - the timestamp for the onset of the pacing sound (not
>present in the unpaced conditions)
>
>5. soundoff - the timestamp for the offset of the pacing sound (not
>present in the unpaced conditions)
>
>The the timestamps occur consecutively in the file, regardless of
>whether they are a press or release, or produced with the right or
>left hand.
>
>I need to get it in a format where the variables are something like
>this:
>
>1. Condition
>2. Press_R (press with right hand)
>3. Release_R (release the right hand)
>4. Press_L (press with left hand)
>5. Release_L (release with right hand)
>6. Sound onset
>7. Sound offset

This is a bit of a bear, and I don't understand all your needs.

It looks like an experimental session is a run of what I'll call
'ticks', not being able to think of a better word. The 'ticks' are
about 600 msec apart (from your reply to Viann Beadle). A tick includes
various of the following 'events' you've listed as 2-7, above. Some
events may be missing inadvertently (you wrote that a press may be
missing), some by the experimental condition (the pacing sound may not
be being used).

Presently, you have separates records for all presses and releases,
giving their times; the times of sound onset and offset are in the
press-release records.

I'd like to have some test data to play with, covering at least several
'ticks'. But it sounds like the approach is to,
a. Assign each record to some 'tick'. Perhaps, any event more than
400msec after the preceding one is part of a new 'tick'.
b. Probably, use VARSTOCASES or XSAVE to create separate records for
the sound onset and offset times
c. Code records by type, regardless of the order they appear in within
a tick.
d. Sort records by tick number and type
e. Use CASESTOVARS to get the records you want.

Sound good?

-Good luck,
Richard

------------------------------

Date: Mon, 5 Mar 2007 14:50:12 -0800
From: Yifan Lu <[hidden email]>
Subject: SPSS warning from regression

Dear list,

=20

I am running multiple regression, but SPSS keeps telling me:

=20

Warnings

=20

There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.

=20

I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!

=20

Regards,

=20

Yifan Lu

=20

=20

------------------------------

Date: Mon, 5 Mar 2007 21:28:36 -0500
From: Richard Ristow <[hidden email]>
Subject: Re: Looping and merging syntax support

At 08:50 PM 3/5/2007, Manmit Shrimali wrote:

>Hope I have communicated in required form.

Not quite. You've given the list of *DATA* variables in the files, but
not the *IDENTIFYING* variables in the files.

>File 1 has 150 records and file 2nd has 150 records. The data is from
>hotel so there can be multiple same ID's in both the file.

Where an ID represents a person? So each person can occur more than
once in each file?

>I don't need to have one record for multiple ID's.

No. The question is, whether you need to reduce to a single record for
*one* ID. Or, do you want a separate record for each trip, so each
person ('ID') has as many records as they have trips, from the two
files combined?

>Q36_Marriott_5
>q36_Hyatt_5
>Q36_Four_season_5

Are these yes/no variables? That is, one will be 'yes' and the other
two 'no', depending on which of the three hotels they stayed in?

>Variables in file 1 (2000>). Maximum file cycles so if someone says 11
>as total trips, and was on 9th trip in year 2000 then we will ask the
>cycle for 10th, and 9th trip as pre-2000 we ask in file 2.

So you have 'wide' organization in both files - multiple trips per
record. And you want 'wide' organization afterward - one record per ID,
with all the person's trips in that record.

If that's right, I recommend that
a. In each file, you use VARSTOCASES to create 'long' organization -
one record per trip, with each ID having as many records as there are
associated trips
b. Use ADD FILES to merge the two 'long' files
c. Use CASESTOVARS to create a single record per ID

-Good luck,
Richard

------------------------------

Date: Mon, 5 Mar 2007 21:38:13 -0500
From: Richard Ristow <[hidden email]>
Subject: Re: SPSS warning from regression

At 05:50 PM 3/5/2007, Yifan Lu wrote:

>I am running multiple regression, but SPSS keeps telling me:
>
>>Warnings
>>There are no valid cases for models with dependent variable alldays.
>>Statistics cannot be computed.
>>No valid cases found. Equation-building skipped.
>
>Anybody also had such problem before? Any suggestions to fix the
>problem? Thank you!

The default (and recommended) practice for regression is 'listwise
deletion': a case is excluded if any of the dependent or independent
variables is missing. The problem you describe can arise when you lose
all data because each case has some variable missing.

>I checked the data and it seems all right. I also ran descriptives and
>the results come out right.

Descriptives won't tell you enough; they give the statistics on single
variables, not on all of them together.

Look at your variables, especially for
. Any that are missing for a large proportion of the cases
. Any that may be mutually exclusive - if one is present, the other
will be missing

In principle, you could get your problem from plain bad luck: you don't
have much missing data, but by chance every case has some missing
variable. (In this case, missing value imputation may be warranted.)

More commonly, though, there's something in the structure of your data
that ensures you don't have complete data for any case. Look for that
first.

-Good luck,
Richard Ristow

------------------------------

Date: Mon, 5 Mar 2007 20:41:16 -0600
From: "Beadle, ViAnn" <[hidden email]>
Subject: Re: SPSS warning from regression

When you ran descriptive, did you include all the variables used in regression? If so, what is the listwise N shown in the descriptives output? If any variable used in the regression has a missing value, that case is excluded from the analysis.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Yifan Lu
Sent: Monday, March 05, 2007 4:50 PM
To: [hidden email]
Subject: SPSS warning from regression

Dear list,

I am running multiple regression, but SPSS keeps telling me:

Warnings

There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.

I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!

Regards,

Yifan Lu

------------------------------

Date: Tue, 6 Mar 2007 08:25:56 +0530
From: Manmit Shrimali <[hidden email]>
Subject: Re: Looping and merging syntax support

Image ID as physician who gives multiple patient record. So one
physician can give multiple records so his ID will appear multiple
times. Also, I want a separate record for each trip, so each
person ('ID') has as many records as they have trips, from the two
files combined. If they stayed in hotel it will be 1 and if not 0. If
they are not eligible to answer then sysmis.

So you have 'wide' organization in both files - multiple trips per
record. And you want 'wide' organization afterward - one record per ID,
with all the person's trips in that record. THIS IS RIGHT. Let me try
var to case.

Thanks Richard for your input.

-----Original Message-----
From: Richard Ristow [mailto:[hidden email]]
Sent: Tuesday, March 06, 2007 7:59 AM
To: Manmit Shrimali; [hidden email]
Subject: Re: Looping and merging syntax support

At 08:50 PM 3/5/2007, Manmit Shrimali wrote:

>Hope I have communicated in required form.

Not quite. You've given the list of *DATA* variables in the files, but
not the *IDENTIFYING* variables in the files.

>File 1 has 150 records and file 2nd has 150 records. The data is from
>hotel so there can be multiple same ID's in both the file.

Where an ID represents a person? So each person can occur more than
once in each file?

>I don't need to have one record for multiple ID's.

No. The question is, whether you need to reduce to a single record for
*one* ID. Or, do you want a separate record for each trip, so each
person ('ID') has as many records as they have trips, from the two
files combined?

>Q36_Marriott_5
>q36_Hyatt_5
>Q36_Four_season_5

Are these yes/no variables? That is, one will be 'yes' and the other
two 'no', depending on which of the three hotels they stayed in?

>Variables in file 1 (2000>). Maximum file cycles so if someone says 11
>as total trips, and was on 9th trip in year 2000 then we will ask the
>cycle for 10th, and 9th trip as pre-2000 we ask in file 2.

So you have 'wide' organization in both files - multiple trips per
record. And you want 'wide' organization afterward - one record per ID,
with all the person's trips in that record.

If that's right, I recommend that
a. In each file, you use VARSTOCASES to create 'long' organization -
one record per trip, with each ID having as many records as there are
associated trips
b. Use ADD FILES to merge the two 'long' files
c. Use CASESTOVARS to create a single record per ID

-Good luck,
Richard

------------------------------

Date: Tue, 6 Mar 2007 08:54:00 +0530
From: Manmit Shrimali <[hidden email]>
Subject: Re: Looping and merging syntax support

Richard and all:

Vartocase is not working efficiently. Can you please help me writing
syntax for following:
1. Create a vector that contains information of variable X1 to X22.
Variables are in order. So I believe I will write vector X=X1 to X22.
2. Create another vector that contains information of variable Y1 to Y22
so it will be vector Y=Y1 to Y22.
3. In every cell cell of X I want to inpute value of Y i.e. X1 should
have value of Y1, X2 should have value of Y2, X3 should have value of
Y3.

If you can help me writing loop for the above situation, I think I am
able to solve my problem.

-----Original Message-----
From: Richard Ristow [mailto:[hidden email]]
Sent: Tuesday, March 06, 2007 7:59 AM
To: Manmit Shrimali; [hidden email]
Subject: Re: Looping and merging syntax support

At 08:50 PM 3/5/2007, Manmit Shrimali wrote:

>Hope I have communicated in required form.

Not quite. You've given the list of *DATA* variables in the files, but
not the *IDENTIFYING* variables in the files.

>File 1 has 150 records and file 2nd has 150 records. The data is from
>hotel so there can be multiple same ID's in both the file.

Where an ID represents a person? So each person can occur more than
once in each file?

>I don't need to have one record for multiple ID's.

No. The question is, whether you need to reduce to a single record for
*one* ID. Or, do you want a separate record for each trip, so each
person ('ID') has as many records as they have trips, from the two
files combined?

>Q36_Marriott_5
>q36_Hyatt_5
>Q36_Four_season_5

Are these yes/no variables? That is, one will be 'yes' and the other
two 'no', depending on which of the three hotels they stayed in?

>Variables in file 1 (2000>). Maximum file cycles so if someone says 11
>as total trips, and was on 9th trip in year 2000 then we will ask the
>cycle for 10th, and 9th trip as pre-2000 we ask in file 2.

So you have 'wide' organization in both files - multiple trips per
record. And you want 'wide' organization afterward - one record per ID,
with all the person's trips in that record.

If that's right, I recommend that
a. In each file, you use VARSTOCASES to create 'long' organization -
one record per trip, with each ID having as many records as there are
associated trips
b. Use ADD FILES to merge the two 'long' files
c. Use CASESTOVARS to create a single record per ID

-Good luck,
Richard

------------------------------

Date: Tue, 6 Mar 2007 10:10:14 +0530
From: Nivruti Hinge <[hidden email]>
Subject: Re: SPSS warning from regression

One of the dependent variable must be having many missing values so please
check for the missing values in the dependent variable list.

-Regards,
Nivruti Hinge
Senior Member Of Technical Staff
Persistent Systems Pvt. Ltd.
http://www.persistentsys.com
Direct : +91 (20) 30235627

____________________________________________________________________________
_______________
Persistent Systems - Software Development Partner for Competitive Advantage.
Persistent Systems provides custom software product development services.
With over 15 years, 140 customers, and 700 release cycles experience, we
deliver unmatched value of higher quality, faster time to market and lower
total costs.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Yifan Lu
Sent: Tuesday, March 06, 2007 4:20 AM
To: [hidden email]
Subject: SPSS warning from regression

Dear list,

I am running multiple regression, but SPSS keeps telling me:

Warnings

There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.

I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!

Regards,

Yifan Lu

DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails.

------------------------------

End of SPSSX-L Digest - 4 Mar 2007 to 5 Mar 2007 (#2007-65)
***********************************************************

zstatman

Re: When is V16 coming out?

Gee! Aren't you forward thinking. While development is probably reviewing
its options, no V16 beta has hit the network so relax.

If you have any thoughts as to enhancements, modifications, etc of interest
in getting into the queue send me a private email for logging, I will see
that appropriate persons at SPSS are informed.

Will
Principal SPSS Beta Site

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Charles Partridge
Sent: Tuesday, March 06, 2007 4:29 PM
To: [hidden email]
Subject: When is V16 coming out?

Greetings,

My time came to purchase a new computer at my workplace. Guess what-I got
Vista.

Does anyone know what the anticipated timeline for SPSS V16 is?

-CRP

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Automatic digest processor
Sent: Tuesday, March 06, 2007 12:01 AM
To: Recipients of SPSSX-L digests
Subject: SPSSX-L Digest - 4 Mar 2007 to 5 Mar 2007 (#2007-65)

There are 41 messages totalling 3495 lines in this issue.

Topics of the day:

1. AW: Re: Import values in a part of the cases (3)
2. Analysis of a Stratified Cluster Sample
3. Dataset: reverse to saved
4. Reverse autorecode syntax (2)
5. Data restructuring problem (4)
6. Random effects logistic regression
7. disappearing data
8. Stat question: means ratio test (6)
9. [BULK] frist ? character of value
10. Multiple Files to Open & Analyze
11. SPSS 15 and AMOS 7 under Vista OS (6)
12. AW: Re: Import values in a part of the cases (2)
13. Exporting file from Blackboard to Excel to SPSS
14. =?us-ascii?Q?Re=3AReverse=20autorecode=20syntax?=
15. Looping and merging syntax support (6)
16. SPSS warning from regression (4)

----------------------------------------------------------------------

Date: Mon, 5 Mar 2007 09:07:54 +0100
From: Balmer Thomas <[hidden email]>
Subject: AW: Re: Import values in a part of the cases

>In another question you've raised,

>First, although the file in the front window was LOADED from file A, it
>isn't file A; it's a copy of it. Since it's the active file, you can
>refer to it as '*'.

>Second, you need to refer to file B1 the way you did when you saved it:
>'C:\...\B1.sav'.

>So your UPDATE command becomes
>
>UPDATE FILE = *
> / FILE = 'C:\...\B1.sav'
> / RENAME = (Name, Str_Wohn, Mail_g=Nachname, Strasse, Email)
> /by Nachname Vorname.

>That may do what you want. It assumes that,
>- File B1 is also sorted by Nachname Vorname
>- Neither file has more than one record for any combination of Nachname
>Vorname
>
>If the latter assumption is not correct, then it's time to think about
>MATCH FILES with the TABLE subcommand.

The UPDATE Command got the files now, but could not finish. It gave me
an error message with the first Nachname-Vorname-Combination which is
not unique - I suppose because of the point you mentioned: In File B1
Nachname and Vorname are unique combinations, but not so in File A. I'll
try the MACTCH FILES with TABLE.

------------------------------

Date: Mon, 5 Mar 2007 10:01:55 +0100
From: Balmer Thomas <[hidden email]>
Subject: AW: Re: Import values in a part of the cases

I tried the TABLE subcommand like this:

MATCH FILES /FILE=*
/TABLE='B1'
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse
/DROP= Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex
/BY Nachname Vorname.
EXE.

...renaming variables in the file B1 to match with the variables in the
*-file (which is the master) and droping a few.
Strange Result: Nothing. The Syntax seems to work, because I got no error,
but the values from B1 are not printed in the file *.

-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:[hidden email]] Im Auftrag von
Melissa Ives
Gesendet: Freitag, 2. März 2007 16:30
An: [hidden email]
Betreff: Re: Import values in a part of the cases

You may want to use TABLE instead of UPDATE. Look at the Operations of
each to see which one retains the records you want. In TABLE, only
records that match in the FILE are included. In UPDATE, new records are
created in the master file if they are in the update file but not in the
master. I believe this means that they would work similarly IF you have
exactly the same records (per the matching variables) in both files.

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Balmer Thomas
Sent: Friday, March 02, 2007 7:01 AM
To: [hidden email]
Subject: [SPSSX-L] Import values in a part of the cases

Hi

The aim would be to import values of a couple of string variables in
these cases, which match with the values of two variables (Firstname and
Name).

But the matching command seems to allow just two other purposes: to add
new variables or to add new cases. I'd like to import just the values
in existing variables (Street, Town, Email) for the matching cases,
without adding new variables or cases.

It's probably a total different command I need...

Thanks for Help!

Tom

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at (309) 827-6026 for assistance.

------------------------------

Date: Mon, 5 Mar 2007 02:29:08 -0800
From: Alice P Chiu <[hidden email]>
Subject: Analysis of a Stratified Cluster Sample

Dear all,=0AI would like to seek some advice regarding the analysis of a St=
ratified Cluster Sample. =0AI would like to find the association between tw=
o variables. Within the 2x2 table, there was an expected count of less tha=
n 5.=0AI was told that Fisher's exact test should not be used in such a sce=
naario.=0ACan you please advice which test should be used instead?=0AThanks=
in advance!=0A=0AAlice.=0A=0A=0A =0A______________________________________=
______________________________________________=0AGet your own web address. =
=0AHave a HUGE year through Yahoo! Small Business.=0Ahttp://smallbusiness.=
yahoo.com/domains/?p=3DBESTDEAL

------------------------------

Date: Mon, 5 Mar 2007 12:56:07 +0100
From: Antoon Smulders <[hidden email]>
Subject: Dataset: reverse to saved

Hello all,

Although the possibility to open more files the same time is there since a
couple of versions ago, I have so far avoided it, because of some problems
(mainly caused by my ignorance, I'm sure).

I have a file called "computes.sps" wich starts with:

GET FILE "myfile.sav".

DATASET NAME= "myset".

COMPUTE varA = 2.

I have another file called "output.sps" , wich reads:

Cd "S:\".

Include "computes.sps".

Freq varA.

Now I start spss and when prompted for a file to open I choose output.sps.
The data window now shows in its title bar: untitled1 [dataset0].

Next I run my output.sps.Dataset0 (and untitled1) are closed and the title
bar reads: myfile.sav [myset]

So far so good, but now I make a big mess of it: (one thing I'm very good
at) so I want to "revert back to saved", but if I include my computes a
second time, the filename changes in "untitled2". There is also a warning in
the output window that "the active dataset wil replace the existing dataset
myset", but that is exactly what I want. To get my filename back I have to
run /include the computes file a third time.

Now how can I let SPSS use the real filename instead of "untitled", without
reopening it this third time.

Thanks in advance

Antoon Smulders

------------------------------

Date: Mon, 5 Mar 2007 13:06:06 +0100
From: Max Bell <[hidden email]>
Subject: Reverse autorecode syntax

Dear List,

I'm loooking for syntax to do reverse autorecode. I want to create a new
string variable based on the values of an existing variable. I found
this script
Reverse autorecode.SBS <Scripts/Labels/ReverseAutorecode.txt> To create
a new string variable containing the value labels of an existing
variable (this can also be done using syntax alone)=20

But the mentioned syntax I cannot find. Who can help me?

Thanks in advance,
Max

------------------------------

Date: Mon, 5 Mar 2007 12:47:55 +0000
From: Jennifer Thompson <[hidden email]>
Subject: Data restructuring problem

Dear SPSSers,

I have what I think is a fairly complicated (for me at least) data
restructuring problem and would be very grateful for any help or
suggestions.

I have 30+ files (one per experiment participant) with the same basic
structure, consisting of 5 variables:

1. Condition - which can be one of is one of 3 basic tasks: tapping in
synch with a sound (Synch), tapping without a sound (Unpaced) and tapping in
synch with a sound in preparation for Unpaced (Paced), each of which is done
seperately with the right hand (R), left hand (L) and with both together
(B), and repeated 3 times (so 27 different 'conditions'.)

2. RT - which is a timestamp for a response press or release

3. Response - which is 8 for a press and 8.5 for a release with the right
hand and 7 for a press / 7.5 for a release with the left hand

4. soundon - the timestamp for the onset of the pacing sound (not present
in the unpaced conditions)

5. soundoff - the timestamp for the offset of the pacing sound (not present
in the unpaced conditions)

The difficulty is that the timestamps occur consecutively in the file,
regardless of whether they are a press or release, or produced with the
right or left hand.

To begin to analyse the data I think I need to get it in a format where the
variables are something like this:

1. Condition

2. Press_R (press with right hand)

3. Release_R (release the right hand)

4. Press_L (press with left hand)

5. Release_L (release with right hand)

6. Sound onset

7. Sound offset

I've done this manually (!) for the first file, by sorting the data by
condition, response and RT and 'simply' copying / pasting the data as
appropriate, which took quite some time... There has to be an easier way to
do this, surely?

There is another problem. Some of the responses (releases only, from what I
can see so far) are missing, so the press / release RT columns don't always
match up. In this case, the 'release' RT will be a higher number than the
next 'press' RT, so I've been flagging this with the following syntax:

IF (Press_L < LAG(Release_L)) Error_L = 1 .

IF (Press_R < LAG(Release_R)) Error_R = 1 .

And then manually (copy/paste) lining up the data. But again, is there a
more 'automated' way I could do this?

Any thoughts / suggestions? I've struggled to explain the data but will
gladly send an example datafile if anyone would like to take a look.

Thanks for reading,

Jennifer

------------------------------

Date: Mon, 5 Mar 2007 08:15:43 -0500
From: Statisticsdoc <[hidden email]>
Subject: Re: Random effects logistic regression

Lou,

Another excellent source of information on this topic is Raudenbush, S.W.
and Bryk, A.S. (2002). Hierarchical Linear Models (Second Edition). Thousand
Oaks: Sage Publications, 482 pp. This text covers binomial and multinomial
cases.

HTH,

Stephen Brand

For personalized and professional consultation in statistics and research
design, visit
www.statisticsdoc.com

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
Lou
Sent: Thursday, March 01, 2007 11:29 AM
To: [hidden email]
Subject: Random effects logistic regression

Hi there,

Can anyone recommend some good references/websites for learning
about 'random effects logistic regression', please?

Thanks

Lou

------------------------------

Date: Mon, 5 Mar 2007 07:16:10 -0600
From: "Beadle, ViAnn" <[hidden email]>
Subject: Re: Data restructuring problem

There is information not specified here--what hypotheses are you testing, or
in less formal terms, what are you trying to find out? This, in turn, will
determine the types of analyses to perform. And, those in turn, will
determine the appropriate data structure(s).

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Jennifer Thompson
Sent: Monday, March 05, 2007 6:48 AM
To: [hidden email]
Subject: Data restructuring problem

Dear SPSSers,

I have what I think is a fairly complicated (for me at least) data
restructuring problem and would be very grateful for any help or
suggestions.

I have 30+ files (one per experiment participant) with the same basic
structure, consisting of 5 variables:

1. Condition - which can be one of is one of 3 basic tasks: tapping in
synch with a sound (Synch), tapping without a sound (Unpaced) and tapping in
synch with a sound in preparation for Unpaced (Paced), each of which is done
seperately with the right hand (R), left hand (L) and with both together
(B), and repeated 3 times (so 27 different 'conditions'.)

2. RT - which is a timestamp for a response press or release

3. Response - which is 8 for a press and 8.5 for a release with the right
hand and 7 for a press / 7.5 for a release with the left hand

4. soundon - the timestamp for the onset of the pacing sound (not present
in the unpaced conditions)

5. soundoff - the timestamp for the offset of the pacing sound (not present
in the unpaced conditions)

The difficulty is that the timestamps occur consecutively in the file,
regardless of whether they are a press or release, or produced with the
right or left hand.

To begin to analyse the data I think I need to get it in a format where the
variables are something like this:

1. Condition

2. Press_R (press with right hand)

3. Release_R (release the right hand)

4. Press_L (press with left hand)

5. Release_L (release with right hand)

6. Sound onset

7. Sound offset

I've done this manually (!) for the first file, by sorting the data by
condition, response and RT and 'simply' copying / pasting the data as
appropriate, which took quite some time... There has to be an easier way to
do this, surely?

There is another problem. Some of the responses (releases only, from what I
can see so far) are missing, so the press / release RT columns don't always
match up. In this case, the 'release' RT will be a higher number than the
next 'press' RT, so I've been flagging this with the following syntax:

IF (Press_L < LAG(Release_L)) Error_L = 1 .

IF (Press_R < LAG(Release_R)) Error_R = 1 .

And then manually (copy/paste) lining up the data. But again, is there a
more 'automated' way I could do this?

Any thoughts / suggestions? I've struggled to explain the data but will
gladly send an example datafile if anyone would like to take a look.

Thanks for reading,

Jennifer

------------------------------

Date: Mon, 5 Mar 2007 14:20:33 +0000
From: Jennifer Thompson <[hidden email]>
Subject: Re: Data restructuring problem

Thanks for the comments, and I'm sorry that my initial post was vague. Here
is some more information:

The study is a comparison of neurological patients and healthy controls.
The task involves unimanual or bimanual finger tapping, which is either
paced with a tone (every 600 milliseconds) [the 'synch' condition] or
unpaced [the 'unpaced' condition], in which 10 pacing tones are initially
presented and the participant is required to continue tapping at the same
rate [performance on the initial pacing practice is also recorded as the
'paced' condition - although it isn't actually a condition as such].

I will be calculating the mean inter-tap interval and variability for paced
vs unpaced tapping, and unimanual vs bimanual tapping for each participant.
I was planning to do this using the LAG function, using something like:

COMPUTE Press_ITI_R = Press_R - LAG(Press_R)

I'll also be calculating the degree to which responses with either hand in
the bimanual condition are synchronised, by looking at the lag between
them.

The hypothesis is that the neurological patients will have a more variable
inter-tap interval, and that they will show less synchronisation of the two
hands when tapping bimanually. It is also hypothesised that the inter-tap
interval variability of neurological patients will be disproportionately
affected in the unpaced condition. We may also look at how the two groups
compare in the ability to actually synchronise their response with the
tones. The analysis will generally focus on the tap onset (press) but we'll
also be calculating the average response duration (hence the need for both
press and release reaction time data).

I hope this makes my problem more clear.

Many thanks,

Jennifer

On 3/5/07, Beadle, ViAnn <[hidden email]> wrote:

------------------------------

Date: Mon, 5 Mar 2007 10:01:22 -0500
From: "Zdaniuk, Bozena" <[hidden email]>
Subject: disappearing data

Hello, I opened a data file in spss 14 that was created in earlier
version of spss and about a half of the cases did not appear in the
'data' window. The analyses still ran on all the cases even though I
could not see half of them. However, once I made a small change in the
file, the analyses started showing only the number of cases seen in the
file. The rest mysteriously disappeared... Any idea what happened and
how I can fix it? Thanks.
bozena

Bozena Zdaniuk, Ph.D.

University of Pittsburgh

UCSUR, 6th Fl.

121 University Place

Pittsburgh, PA 15260

Ph.: 412-624-5736

Fax: 412-624-4810

email: [hidden email]

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Jennifer Thompson
Sent: Monday, March 05, 2007 7:48 AM
To: [hidden email]
Subject: Data restructuring problem

Dear SPSSers,

I have what I think is a fairly complicated (for me at least) data
restructuring problem and would be very grateful for any help or
suggestions.

I have 30+ files (one per experiment participant) with the same basic
structure, consisting of 5 variables:

1. Condition - which can be one of is one of 3 basic tasks: tapping in
synch with a sound (Synch), tapping without a sound (Unpaced) and
tapping in
synch with a sound in preparation for Unpaced (Paced), each of which is
done
seperately with the right hand (R), left hand (L) and with both together
(B), and repeated 3 times (so 27 different 'conditions'.)

2. RT - which is a timestamp for a response press or release

3. Response - which is 8 for a press and 8.5 for a release with the
right
hand and 7 for a press / 7.5 for a release with the left hand

4. soundon - the timestamp for the onset of the pacing sound (not
present
in the unpaced conditions)

5. soundoff - the timestamp for the offset of the pacing sound (not
present
in the unpaced conditions)

The difficulty is that the timestamps occur consecutively in the file,
regardless of whether they are a press or release, or produced with the
right or left hand.

To begin to analyse the data I think I need to get it in a format where
the
variables are something like this:

1. Condition

2. Press_R (press with right hand)

3. Release_R (release the right hand)

4. Press_L (press with left hand)

5. Release_L (release with right hand)

6. Sound onset

7. Sound offset

I've done this manually (!) for the first file, by sorting the data by
condition, response and RT and 'simply' copying / pasting the data as
appropriate, which took quite some time... There has to be an easier
way to
do this, surely?

There is another problem. Some of the responses (releases only, from
what I
can see so far) are missing, so the press / release RT columns don't
always
match up. In this case, the 'release' RT will be a higher number than
the
next 'press' RT, so I've been flagging this with the following syntax:

IF (Press_L < LAG(Release_L)) Error_L = 1 .

IF (Press_R < LAG(Release_R)) Error_R = 1 .

And then manually (copy/paste) lining up the data. But again, is there
a
more 'automated' way I could do this?

Any thoughts / suggestions? I've struggled to explain the data but will
gladly send an example datafile if anyone would like to take a look.

Thanks for reading,

Jennifer

------------------------------

Date: Mon, 5 Mar 2007 18:16:55 +0300
From: Anton Balabanov <[hidden email]>
Subject: Stat question: means ratio test

Dear Listers,

I feel stucked with the following question.
Suppose, I have two samples from independent populations. And I whant to
test the hypothesis that one mean is as twice as the other mean, that is:
H0: m1 = 2*m2.

It seems, doubling values for the second sample (before using standard
t-test) is not correct practice, because it will affect variance.
Is there a simple way to do such a test, and if "yes", how can I manage it
in SPSS?

Many thanks in advance,

Anton

------------------------------

Date: Mon, 5 Mar 2007 09:27:15 -0600
From: Melissa Ives <[hidden email]>
Subject: Re: AW: Re: Import values in a part of the cases

Thomas,

(As noted in my message to you on Fri 3/2/2007 11:28 AM) Remember that the
order of the files matters, so IF the variables you want to add from the
lookup table are already IN the main file, then the /TABLE= subcommand needs
to come BEFORE the /FILE= subcommand. (works the same way in regular match
with 2 (or more) /FILE= statements) If a variable is common to both files,
the one in the first listed file is what is retained.

So you would need to switch your file order in the MATCH command to be:
MATCH FILES
/TABLE='B1'
/FILE=*
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse
/DROP= Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname
Vorname.
EXE.

Melissa
The bubbling brook would lose its song if you removed the rocks.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Balmer Thomas
Sent: Monday, March 05, 2007 3:02 AM
To: [hidden email]
Subject: [SPSSX-L] AW: Re: Import values in a part of the cases

I tried the TABLE subcommand like this:

MATCH FILES /FILE=*
/TABLE='B1'
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse /DROP=
Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname Vorname.
EXE.

...renaming variables in the file B1 to match with the variables in the
*-file (which is the master) and droping a few.
Strange Result: Nothing. The Syntax seems to work, because I got no error,
but the values from B1 are not printed in the file *.

-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:[hidden email]] Im Auftrag von
Melissa Ives
Gesendet: Freitag, 2. März 2007 16:30
An: [hidden email]
Betreff: Re: Import values in a part of the cases

You may want to use TABLE instead of UPDATE. Look at the Operations of each
to see which one retains the records you want. In TABLE, only records that
match in the FILE are included. In UPDATE, new records are created in the
master file if they are in the update file but not in the master. I believe
this means that they would work similarly IF you have exactly the same
records (per the matching variables) in both files.

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Balmer Thomas
Sent: Friday, March 02, 2007 7:01 AM
To: [hidden email]
Subject: [SPSSX-L] Import values in a part of the cases

Hi

The aim would be to import values of a couple of string variables in these
cases, which match with the values of two variables (Firstname and Name).

But the matching command seems to allow just two other purposes: to add new
variables or to add new cases. I'd like to import just the values in
existing variables (Street, Town, Email) for the matching cases, without
adding new variables or cases.

It's probably a total different command I need...

Thanks for Help!

Tom

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND CONFIDENTIAL
information and is intended only for the use of the addressee. If you are
not the designated recipient, or an employee or agent authorized to deliver
such transmittals to the designated recipient, you are hereby notified that
any dissemination, copying or publication of this transmittal is strictly
prohibited. If you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your system.
You may also call us at (309) 827-6026 for assistance.

------------------------------

Date: Mon, 5 Mar 2007 08:31:17 -0700
From: "Ornelas, Fermin" <[hidden email]>
Subject: Re: Stat question: means ratio test

Correct me if my interpretation of this is not right?
But you do not go and alter the means of the second sample. What you
should do is calculate their means as they are and do the test to verify
that the means do not met the condition that you just mentioned.

That is you Ho: m1_sample1= 2*(m2_sample2);
Ha: m1_sample1 <> 2*(m2_sample2);
Then use the two tail t-table values to see if you results validate or
fail to reject Ho.

Fermin Ornelas, Ph.D.
Management Analyst III, AZ DES
Tel: (602) 542-5639
E-mail: [hidden email]
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Anton Balabanov
Sent: Monday, March 05, 2007 8:17 AM
To: [hidden email]
Subject: Stat question: means ratio test

Dear Listers,

I feel stucked with the following question.
Suppose, I have two samples from independent populations. And I whant to
test the hypothesis that one mean is as twice as the other mean, that
is:
H0: m1 = 2*m2.

It seems, doubling values for the second sample (before using standard
t-test) is not correct practice, because it will affect variance.
Is there a simple way to do such a test, and if "yes", how can I manage
it
in SPSS?

Many thanks in advance,

Anton

NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR
CONFIDENTIAL information and is intended only for the use of the
specific individual(s) to whom it is addressed. It may contain
information that is privileged and confidential under state and federal
law. This information may be used or disclosed only in accordance with
law, and you may be subject to penalties under law for improper use or
further disclosure of the information in this e-mail and its
attachments. If you have received this e-mail in error, please
immediately notify the person named above by reply e-mail, and then
delete the original e-mail. Thank you.

------------------------------

Date: Mon, 5 Mar 2007 08:43:40 -0700
From: "Ornelas, Fermin" <[hidden email]>
Subject: Re: Stat question: means ratio test

Note also that your example is just increasing the second mean by a
constant. For examples on how to do this type of testing look at Netter,
et. Al. Applied Linear Regression in the ANOVA Chapters for examples on
means testing similar to the one you are doing.

Fermin Ornelas, Ph.D.
Management Analyst III, AZ DES
Tel: (602) 542-5639
E-mail: [hidden email]

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Anton Balabanov
Sent: Monday, March 05, 2007 8:17 AM
To: [hidden email]
Subject: Stat question: means ratio test

Dear Listers,

I feel stucked with the following question.
Suppose, I have two samples from independent populations. And I whant to
test the hypothesis that one mean is as twice as the other mean, that
is:
H0: m1 = 2*m2.

It seems, doubling values for the second sample (before using standard
t-test) is not correct practice, because it will affect variance.
Is there a simple way to do such a test, and if "yes", how can I manage
it
in SPSS?

Many thanks in advance,

Anton

NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR
CONFIDENTIAL information and is intended only for the use of the
specific individual(s) to whom it is addressed. It may contain
information that is privileged and confidential under state and federal
law. This information may be used or disclosed only in accordance with
law, and you may be subject to penalties under law for improper use or
further disclosure of the information in this e-mail and its
attachments. If you have received this e-mail in error, please
immediately notify the person named above by reply e-mail, and then
delete the original e-mail. Thank you.

------------------------------

Date: Mon, 5 Mar 2007 18:52:43 +0300
From: Anton Balabanov <[hidden email]>
Subject: Re: Stat question: means ratio test

Ah... Did you mean, I should calculate all the statistics (means and
standard deviations) and then compute t-statistic "manually", substituting
sample mean m2 with 2*m2?

Indeed, it seems enough for me. I need to do it only once and do not need
more general solution. Thank you very much!

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

------------------------------

Date: Mon, 5 Mar 2007 11:42:33 -0500
From: "Roberts, Michael" <[hidden email]>
Subject: Re: Multiple Files to Open & Analyze

Hi Will,

If you are using ver. 14 or better, the programmability option
simplifies what you are trying to do. In ver. 14.01 (version 15 has it
built in) you will need to download the integration package, (available
from SPSS' website), the Python (freeware) from their website, the
modules from SPSS' website, load everything following programmability
directions available on SPSS' site, and you should be good to go.

I was facing the same knotty problem, and with help from Jon Peck and
John Bauer was up and running very shortly thereafter.

HTH

Mike

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Will Bailey [Statman]
Sent: Saturday, March 03, 2007 8:29 AM
To: [hidden email]
Subject: Multiple Files to Open & Analyze

A client has this situation:

About 200 files over which we have to run a syntax. All the files are
named after the subject number, e.g. 10001_R4.sav

The syntax starts with opening the file, e.g. GET
FILE="H:\10001_R4.sav".
Then there are several analyses and next we save the file, e.g.
OUTFILE="H:\10001_G4.sav" (thus, under a different name: R4->G4)

They currently have to change the name every time we want to run the
syntax; replace 10001 by 10002 to get the next file (we use ctrl H, find
and replace).

Does anyone know if there is some sort of loop function which allows us
to automatically change and run the syntax? Thanks for the help!
================

Tks,
Will

------------------------------

Date: Mon, 5 Mar 2007 12:05:57 -0500
From: Claudiu Tufis <[hidden email]>
Subject: SPSS 15 and AMOS 7 under Vista OS

Hi all,

Just an update and a question regarding Vista compatibility.

I got a new computer with Vista, I installed SPSS 15 and AMOS 7 and was able
to license them using the authorization wizard without any problems.

After a restart, both SPSS and AMOS stopped working, giving me a license
error message.

I uninstalled both, reinstalled them again and asked for a trial license.
Surprise . it worked.

Right now I am able to run analyses using the trial license, which expires
in 2 weeks. (The only incompatibility I found was that SPSS does not work
with Vista's Aero interface and forces Vista to switch to the regular
interface.)

However, if I try to license the software using my license, the
authorization wizard runs, it says authorization was successful, but the
license is not updated: both SPSS and AMOS remain on the trial license.

I called tech support and when they found out I was on a Vista system they
did not even want to try and solve the problem.

All the tech guy told me was basically "Kudos to you for managing to install
and run SPSS with a trial license, but we do not support SPSS under Vista"

His suggestion was to wait for SPSS 16 and buy the new version, a solution I
find a little bit offensive.

SPSS knew for a long time that Vista was coming but it seems like they did
not eve try to make their product compatible with it. A very disappointing
business attitude towards the customer.

Did anyone manage to license SPSS 15 under Vista?

Does anybody know if (and when) SPSS is going to come out with a patch that
will make SPSS run under Vista?

It seems like SPSS does not care very much about my problem (because I am
just an individual user) but some of you may have a better relationship with
SPSS and my know more about this issue.

Best,

Claudiu Tufis

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Claudiu Tufis

Graduate student

314 Pond Laboratory

Department of Political Science

Penn State University

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

------------------------------

Date: Mon, 5 Mar 2007 19:44:40 +0100
From: Balmer Thomas <[hidden email]>
Subject: Re: AW: Re: Import values in a part of the cases

Thanks, Melissa, for your patience.

I've tried it now this way and got a new error: SPSS claims: Each case =
on a TABLE file in MATCH FILES must be uniquely identified by the by =
variables.

Thats probably not the case: In the A-File (*-File) are different cases =
with the same BY-variables Nachname and Vorname. They are unique only in =
the TABLE file. But thats exactly what Iwant: to put in the A-file by =
all these matching cases the values of different variables from the =
B-file (TABLE file). But first I have to rename the variables in the =
B-file in order to be the same as in the A-file. So I ended with this =
Syntax and the mentioned error:
MATCH FILES
/TABLE=3D'B1'
/RENAME Name=3DNachname Mail_g=3DEmail Ort_Wohn=3DOrt =
Str_Wohn=3DStrasse =20
/FILE=3D*
/BY Nachname Vorname.
EXE.

-----Urspr=FCngliche Nachricht-----
Von: SPSSX(r) Discussion im Auftrag von Melissa Ives
Gesendet: Mo 05.03.2007 16:27
An: [hidden email]
Betreff: Re: AW: Re: Import values in a part of the cases
=20
Thomas,

(As noted in my message to you on Fri 3/2/2007 11:28 AM) Remember that =
the order of the files matters, so IF the variables you want to add from =
the lookup table are already IN the main file, then the /TABLE=3D =
subcommand needs to come BEFORE the /FILE=3D subcommand. (works the =
same way in regular match with 2 (or more) /FILE=3D statements) If a =
variable is common to both files, the one in the first listed file is =
what is retained.

So you would need to switch your file order in the MATCH command to be:
MATCH FILES
/TABLE=3D'B1'
/FILE=3D*
/RENAME Name=3DNachname Mail_g=3DEmail Ort_Wohn=3DOrt =
Str_Wohn=3DStrasse /DROP=3D Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 =
Sex /BY Nachname Vorname.
EXE.

Melissa
The bubbling brook would lose its song if you removed the rocks.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of =
Balmer Thomas
Sent: Monday, March 05, 2007 3:02 AM
To: [hidden email]
Subject: [SPSSX-L] AW: Re: Import values in a part of the cases

I tried the TABLE subcommand like this:

MATCH FILES /FILE=3D*
/TABLE=3D'B1'
/RENAME Name=3DNachname Mail_g=3DEmail Ort_Wohn=3DOrt Str_Wohn=3DStrasse =
/DROP=3D Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname =
Vorname.
EXE.

...renaming variables in the file B1 to match with the variables in the =
*-file (which is the master) and droping a few.
Strange Result: Nothing. The Syntax seems to work, because I got no =
error, but the values from B1 are not printed in the file *.

-----Urspr=FCngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:[hidden email]] Im Auftrag =
von Melissa Ives
Gesendet: Freitag, 2. M=E4rz 2007 16:30
An: [hidden email]
Betreff: Re: Import values in a part of the cases

You may want to use TABLE instead of UPDATE. Look at the Operations of =
each to see which one retains the records you want. In TABLE, only =
records that match in the FILE are included. In UPDATE, new records are =
created in the master file if they are in the update file but not in the =
master. I believe this means that they would work similarly IF you have =
exactly the same records (per the matching variables) in both files.

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of =
Balmer Thomas
Sent: Friday, March 02, 2007 7:01 AM
To: [hidden email]
Subject: [SPSSX-L] Import values in a part of the cases

Hi

The aim would be to import values of a couple of string variables in =
these cases, which match with the values of two variables (Firstname and =
Name).

But the matching command seems to allow just two other purposes: to add =
new variables or to add new cases. I'd like to import just the values =
in existing variables (Street, Town, Email) for the matching cases, =
without adding new variables or cases.

It's probably a total different command I need...

Thanks for Help!

Tom

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND =
CONFIDENTIAL information and is intended only for the use of the =
addressee. If you are not the designated recipient, or an employee or =
agent authorized to deliver such transmittals to the designated =
recipient, you are hereby notified that any dissemination, copying or =
publication of this transmittal is strictly prohibited. If you have =
received this transmittal in error, please notify us immediately by =
replying to the sender and delete this copy from your system. You may =
also call us at (309) 827-6026 for assistance.

------------------------------

Date: Mon, 5 Mar 2007 10:47:40 -0800
From: Dennis Deck <[hidden email]>
Subject: Re: Exporting file from Blackboard to Excel to SPSS

I assume from this that:
Each course is identified by a number or string
The course variable imports as a string that contains up to 18 course
responses delimited by some character (probably a space or comma)

Given these assumptions, you will need to "parse" the string to separate
out the individual responses. The parsing algorithm will depend on how
the string is laid out. For example, assuming every response (including
last) has a trailing space, the code might be something like:

/* the following checks for each of 18 course strings (c) and assigns 0
or 1 to the corresponding expanded course variable */
DO REPEAT
x = x1 to x18
/c = 'C1 ' 'C2 ' 'C3 ' . . . 'C18 ' .
+ COMPUTE x = (INDEX(strvar,c) > 0) .
END REPEAT .

You will need to clarify your question if this does not help.

Dennis Deck, PhD
RMC Research Corporation
[hidden email]
-----Original Message-----
From: Martin Sherman [mailto:[hidden email]]
Sent: Friday, March 02, 2007 11:44 AM
Subject: Exporting file from Blackboard to Excel to SPSS

Dear List: I just received an Excel Data file that has a variable which
includes up to 18 responses. That is, students had to indicate which
courses they took from a list of 18 (thus a student could have eighteen
responses on this variable). When exported from Blackboard to Excel the
list of courses can occupy over 1000 columns. When importing to SPSS one
is only able to see the first 50 columns within the data view. What I
really need is a way to expand the responses so that each potential
course that a student took occupies its own variable. Thus what I want
is 18 variables from which I can then work with. Any suggestions. I
recognize that this is a bit confusing. It would have been better if the
investigator had consulted with me before hand and I would not have this
problem. For example if one uses SurveyMonkey one can import a data
file which Expands the potential responses where one allows multiple
responses. Thanks. martin sherman

------------------------------

Date: Mon, 5 Mar 2007 14:10:30 -0500
From: "Valdiserri, Colin" <[hidden email]>
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

I just ordered a notebook with Vista Business and will get the chance to
see if I can get SPSS to work on Vista.

I agree, SPSS as well as all other software developers new this was
coming out, why can't they create a patch to work earlier versions with
Vista.

I find it offensive too and reinforces the monopoly SPSS has and how
they plan to enjoy it.

Something needs to be done to get this to work with Vista.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Claudiu Tufis
Sent: Monday, March 05, 2007 12:06 PM
To: [hidden email]
Subject: SPSS 15 and AMOS 7 under Vista OS

Hi all,

Just an update and a question regarding Vista compatibility.

I got a new computer with Vista, I installed SPSS 15 and AMOS 7 and was
able
to license them using the authorization wizard without any problems.

After a restart, both SPSS and AMOS stopped working, giving me a license
error message.

I uninstalled both, reinstalled them again and asked for a trial
license.
Surprise . it worked.

Right now I am able to run analyses using the trial license, which
expires
in 2 weeks. (The only incompatibility I found was that SPSS does not
work
with Vista's Aero interface and forces Vista to switch to the regular
interface.)

However, if I try to license the software using my license, the
authorization wizard runs, it says authorization was successful, but the
license is not updated: both SPSS and AMOS remain on the trial license.

I called tech support and when they found out I was on a Vista system
they
did not even want to try and solve the problem.

All the tech guy told me was basically "Kudos to you for managing to
install
and run SPSS with a trial license, but we do not support SPSS under
Vista"

His suggestion was to wait for SPSS 16 and buy the new version, a
solution I
find a little bit offensive.

SPSS knew for a long time that Vista was coming but it seems like they
did
not eve try to make their product compatible with it. A very
disappointing
business attitude towards the customer.

Did anyone manage to license SPSS 15 under Vista?

Does anybody know if (and when) SPSS is going to come out with a patch
that
will make SPSS run under Vista?

It seems like SPSS does not care very much about my problem (because I
am
just an individual user) but some of you may have a better relationship
with
SPSS and my know more about this issue.

Best,

Claudiu Tufis

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Claudiu Tufis

Graduate student

314 Pond Laboratory

Department of Political Science

Penn State University

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

_______________________________________________
This message was scanned for viruses prior to entering the Moen network

_______________________________________________________________________

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
_______________________________________________________________________

------------------------------

Date: Mon, 5 Mar 2007 13:15:21 -0600
From: Melissa Ives <[hidden email]>
Subject: Re: AW: Re: Import values in a part of the cases

Dear listers, to complete this thread, I am including my response to Thomas
below. (Note that the syntax is untested).
Thomas, please note the small edit in the 4th line.

This error says that the records in your TABLE file has more than one record
with the same Nachname and Vorname.

Try running the wizard for identifying duplicate cases on the Data menu.

Alternatively (if you don't have that option on the Data menu (I think it
was added in V. 14) you could use the following syntax to get a list of the
duplicate combination(s):

Sort cases by Nachname Vorname.
Compute dupeNN=0.
If (nachname=lag(nachname) and vorname=lag(vorname)) dupeNN=1.
Freq dupenn.

Temp.
Sel if dupenn=1.
List vars=nachname vorname (and any other variables you need to see to find
the duplicates).

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Balmer Thomas
Sent: Monday, March 05, 2007 12:45 PM
To: [hidden email]
Subject: Re: [SPSSX-L] AW: Re: Import values in a part of the cases

Thanks, Melissa, for your patience.

I've tried it now this way and got a new error: SPSS claims: Each case on a
TABLE file in MATCH FILES must be uniquely identified by the by variables.

Thats probably not the case: In the A-File (*-File) are different cases with
the same BY-variables Nachname and Vorname. They are unique only in the
TABLE file. But thats exactly what Iwant: to put in the A-file by all these
matching cases the values of different variables from the B-file (TABLE
file). But first I have to rename the variables in the B-file in order to be
the same as in the A-file. So I ended with this Syntax and the mentioned
error:
MATCH FILES
/TABLE='B1'
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse
/FILE=*
/BY Nachname Vorname.
EXE.

-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion im Auftrag von Melissa Ives
Gesendet: Mo 05.03.2007 16:27
An: [hidden email]
Betreff: Re: AW: Re: Import values in a part of the cases

Thomas,

(As noted in my message to you on Fri 3/2/2007 11:28 AM) Remember that the
order of the files matters, so IF the variables you want to add from the
lookup table are already IN the main file, then the /TABLE= subcommand needs
to come BEFORE the /FILE= subcommand. (works the same way in regular match
with 2 (or more) /FILE= statements) If a variable is common to both files,
the one in the first listed file is what is retained.

So you would need to switch your file order in the MATCH command to be:
MATCH FILES
/TABLE='B1'
/FILE=*
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse
/DROP= Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname
Vorname.
EXE.

Melissa
The bubbling brook would lose its song if you removed the rocks.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Balmer Thomas
Sent: Monday, March 05, 2007 3:02 AM
To: [hidden email]
Subject: [SPSSX-L] AW: Re: Import values in a part of the cases

I tried the TABLE subcommand like this:

MATCH FILES /FILE=*
/TABLE='B1'
/RENAME Name=Nachname Mail_g=Email Ort_Wohn=Ort Str_Wohn=Strasse /DROP=
Beginn Desig_PH Ende Funkt_1 Funkt_2 Funkt_3 Sex /BY Nachname Vorname.
EXE.

...renaming variables in the file B1 to match with the variables in the
*-file (which is the master) and droping a few.
Strange Result: Nothing. The Syntax seems to work, because I got no error,
but the values from B1 are not printed in the file *.

-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:[hidden email]] Im Auftrag von
Melissa Ives
Gesendet: Freitag, 2. März 2007 16:30
An: [hidden email]
Betreff: Re: Import values in a part of the cases

You may want to use TABLE instead of UPDATE. Look at the Operations of each
to see which one retains the records you want. In TABLE, only records that
match in the FILE are included. In UPDATE, new records are created in the
master file if they are in the update file but not in the master. I believe
this means that they would work similarly IF you have exactly the same
records (per the matching variables) in both files.

Melissa
The bubbling brook would lose its song if you removed the rocks.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Balmer Thomas
Sent: Friday, March 02, 2007 7:01 AM
To: [hidden email]
Subject: [SPSSX-L] Import values in a part of the cases

Hi

The aim would be to import values of a couple of string variables in these
cases, which match with the values of two variables (Firstname and Name).

But the matching command seems to allow just two other purposes: to add new
variables or to add new cases. I'd like to import just the values in
existing variables (Street, Town, Email) for the matching cases, without
adding new variables or cases.

It's probably a total different command I need...

Thanks for Help!

Tom

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND CONFIDENTIAL
information and is intended only for the use of the addressee. If you are
not the designated recipient, or an employee or agent authorized to deliver
such transmittals to the designated recipient, you are hereby notified that
any dissemination, copying or publication of this transmittal is strictly
prohibited. If you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your system.
You may also call us at (309) 827-6026 for assistance.

------------------------------

Date: Mon, 5 Mar 2007 12:27:06 -0700
From: David Wasserman <[hidden email]>
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

The tech support section of the SPSS web site states clearly that no version
of SPSS is compatible with Windows Vista. I experienced the same problems
as other have reported, and am unable to use SPSS 15.0 on my Home Vista
Premium desktop computer. I received no reply to an e-mail to SPSS tech
support.

Despite the web site, SPSS 13 seems to run ok under Vista. There are a
couple of error messages that come up on first opening SPSS, but analyses
and syntax that I tried ran correctly.

David Wasserman
Custom Data Analysis and SPSS Programming

----- Original Message -----
From: "Valdiserri, Colin" <[hidden email]>
To: <[hidden email]>
Sent: Monday, March 05, 2007 12:10 PM
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

was
> able
> to license them using the authorization wizard without any problems.
>
> After a restart, both SPSS and AMOS stopped working, giving me a
license

the
> license is not updated: both SPSS and AMOS remain on the trial
license.

relationship

network
>
>
>
_______________________________________________________________________
>
> The information transmitted is intended only for the person or entity
to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of,
or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you
received
> this in error, please contact the sender and delete the material from
any
> computer.
>
_______________________________________________________________________
>

_______________________________________________
This message was scanned for viruses prior to entering the Moen network

_______________________________________________________________________

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
_______________________________________________________________________

------------------------------

Date: Mon, 5 Mar 2007 20:37:39 +0100
From: =?us-ascii?Q?Jerabek=20Jindrich?= <[hidden email]>
Subject: =?us-ascii?Q?Re=3AReverse=20autorecode=20syntax?=

Hello Max,

You can turn numeric variable into string / or string to num with the
Autorecode command.
Menu/Transform/Autorecode ...

The syntax is
AUTORECODE
VARIABLES=var00001 /INTO NewVar
/DESCENDING /*optional, Descending reverse the value order - highest value
coded as the lowest */.

HTH
Jindra

------------------------------

Date: Mon, 5 Mar 2007 16:38:05 -0500
From: Gary Barnes <[hidden email]>
Subject: Re: SPSS 15 and AMOS 7 under Vista OS

Your are blaming the wrong people. Who all of you should be upset with is
Microsoft and their arrogance. It costs companies millions of dollars to
rewrite code and they do not care about SPSS or you. The same problem exists
with QuickBooks. I am sure that there are lots of other companies who have
been hurt by Vista. Gary Barnes

On 3/5/07 3:42 PM, "Claudiu Tufis" <[hidden email]> wrote:

> The thing that bothers me the most is that SPSS 15 runs on Vista with a
> trial license but I cannot update my license. This suggests to me that the
> problem is not with SPSS but with the License Activation program they are
> using.
>
> For a company that claims to offer the best predictive solution, SPSS Inc.
> failed miserably to predict that once Vista is available people would
start
> using it and they would still like to use the software they need.
>
> The tech support was a joke. First he tried to explain to me that
rewriting

> the code for Vista would take months (what have they done until now - it's
> not like they had to wait for a retail copy to see how to write code for
> Vista) and then he offered me two solutions: either uninstall Vista and
> downgrade to XP, or wait for SPSS 16. Seriously? Is this all they can come
> up with?
>
> Maybe it's time to rethink their approach to customer support.
>
> Claudiu Tufis
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> David Wasserman
> Sent: Monday, March 05, 2007 2:27 PM
> To: [hidden email]
> Subject: Re: SPSS 15 and AMOS 7 under Vista OS
>
> The tech support section of the SPSS web site states clearly that no

version

> of SPSS is compatible with Windows Vista. I experienced the same problems
> as other have reported, and am unable to use SPSS 15.0 on my Home Vista
> Premium desktop computer. I received no reply to an e-mail to SPSS tech
> support.
>
> Despite the web site, SPSS 13 seems to run ok under Vista. There are a
> couple of error messages that come up on first opening SPSS, but analyses
> and syntax that I tried ran correctly.
>
> David Wasserman
> Custom Data Analysis and SPSS Programming
>
> ----- Original Message -----
> From: "Valdiserri, Colin" <[hidden email]>
> To: <[hidden email]>
> Sent: Monday, March 05, 2007 12:10 PM
> Subject: Re: SPSS 15 and AMOS 7 under Vista OS
>
>
>> I just ordered a notebook with Vista Business and will get the chance to
>> see if I can get SPSS to work on Vista.
>>
>> I agree, SPSS as well as all other software developers new this was
>> coming out, why can't they create a patch to work earlier versions with
>> Vista.
>>
>> I find it offensive too and reinforces the monopoly SPSS has and how
>> they plan to enjoy it.
>>
>> Something needs to be done to get this to work with Vista.
>>
>> -----Original Message-----
>> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
>> Claudiu Tufis
>> Sent: Monday, March 05, 2007 12:06 PM
>> To: [hidden email]
>> Subject: SPSS 15 and AMOS 7 under Vista OS
>>
>> Hi all,
>>
>>
>>
>> Just an update and a question regarding Vista compatibility.
>>
>>
>>
>> I got a new computer with Vista, I installed SPSS 15 and AMOS 7 and was
>> able
>> to license them using the authorization wizard without any problems.
>>
>> After a restart, both SPSS and AMOS stopped working, giving me a license
>> error message.
>>
>> I uninstalled both, reinstalled them again and asked for a trial
>> license.
>> Surprise . it worked.
>>
>>
>>
>> Right now I am able to run analyses using the trial license, which
>> expires
>> in 2 weeks. (The only incompatibility I found was that SPSS does not
>> work
>> with Vista's Aero interface and forces Vista to switch to the regular
>> interface.)
>>
>> However, if I try to license the software using my license, the
>> authorization wizard runs, it says authorization was successful, but the
>> license is not updated: both SPSS and AMOS remain on the trial license.
>>
>>
>>
>> I called tech support and when they found out I was on a Vista system
>> they
>> did not even want to try and solve the problem.
>>
>> All the tech guy told me was basically "Kudos to you for managing to
>> install
>> and run SPSS with a trial license, but we do not support SPSS under
>> Vista"
>>
>> His suggestion was to wait for SPSS 16 and buy the new version, a
>> solution I
>> find a little bit offensive.
>>
>> SPSS knew for a long time that Vista was coming but it seems like they
>> did
>> not eve try to make their product compatible with it. A very
>> disappointing
>> business attitude towards the customer.
>>
>>
>>
>> Did anyone manage to license SPSS 15 under Vista?
>>
>> Does anybody know if (and when) SPSS is going to come out with a patch
>> that
>> will make SPSS run under Vista?
>>
>> It seems like SPSS does not care very much about my problem (because I
>> am
>> just an individual user) but some of you may have a better relationship
>> with
>> SPSS and my know more about this issue.
>>
>>
>>
>> Best,
>>
>> Claudiu Tufis
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>> Claudiu Tufis
>>
>> Graduate student
>>
>>
>>
>> 314 Pond Laboratory
>>
>> Department of Political Science
>>
>> Penn State University
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>> _______________________________________________
>> This message was scanned for viruses prior to entering the Moen network
>>
>>
>> _______________________________________________________________________
>>
>> The information transmitted is intended only for the person or entity to
>> which it is addressed and may contain confidential and/or privileged
>> material. Any review, retransmission, dissemination or other use of, or
>> taking of any action in reliance upon, this information by persons or
>> entities other than the intended recipient is prohibited. If you received
>> this in error, please contact the sender and delete the material from any
>> computer.
>> _______________________________________________________________________
>>

This is a bit of a bear, and I don't understand all your needs.

It looks like an experimental session is a run of what I'll call
'ticks', not being able to think of a better word. The 'ticks' are
about 600 msec apart (from your reply to Viann Beadle). A tick includes
various of the following 'events' you've listed as 2-7, above. Some
events may be missing inadvertently (you wrote that a press may be
missing), some by the experimental condition (the pacing sound may not
be being used).

Presently, you have separates records for all presses and releases,
giving their times; the times of sound onset and offset are in the
press-release records.

I'd like to have some test data to play with, covering at least several
'ticks'. But it sounds like the approach is to,
a. Assign each record to some 'tick'. Perhaps, any event more than
400msec after the preceding one is part of a new 'tick'.
b. Probably, use VARSTOCASES or XSAVE to create separate records for
the sound onset and offset times
c. Code records by type, regardless of the order they appear in within
a tick.
d. Sort records by tick number and type
e. Use CASESTOVARS to get the records you want.

Sound good?

-Good luck,
Richard

------------------------------

Date: Mon, 5 Mar 2007 14:50:12 -0800
From: Yifan Lu <[hidden email]>
Subject: SPSS warning from regression

Dear list,

=20

I am running multiple regression, but SPSS keeps telling me:

=20

Warnings

=20

There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.

=20

I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!

=20

Regards,

=20

Yifan Lu

=20

=20

------------------------------

Date: Mon, 5 Mar 2007 21:28:36 -0500
From: Richard Ristow <[hidden email]>
Subject: Re: Looping and merging syntax support

At 08:50 PM 3/5/2007, Manmit Shrimali wrote:

>Hope I have communicated in required form.

Not quite. You've given the list of *DATA* variables in the files, but
not the *IDENTIFYING* variables in the files.

>File 1 has 150 records and file 2nd has 150 records. The data is from
>hotel so there can be multiple same ID's in both the file.

Where an ID represents a person? So each person can occur more than
once in each file?

>I don't need to have one record for multiple ID's.

No. The question is, whether you need to reduce to a single record for
*one* ID. Or, do you want a separate record for each trip, so each
person ('ID') has as many records as they have trips, from the two
files combined?

>Q36_Marriott_5
>q36_Hyatt_5
>Q36_Four_season_5

Are these yes/no variables? That is, one will be 'yes' and the other
two 'no', depending on which of the three hotels they stayed in?

>Variables in file 1 (2000>). Maximum file cycles so if someone says 11
>as total trips, and was on 9th trip in year 2000 then we will ask the
>cycle for 10th, and 9th trip as pre-2000 we ask in file 2.

So you have 'wide' organization in both files - multiple trips per
record. And you want 'wide' organization afterward - one record per ID,
with all the person's trips in that record.

If that's right, I recommend that
a. In each file, you use VARSTOCASES to create 'long' organization -
one record per trip, with each ID having as many records as there are
associated trips
b. Use ADD FILES to merge the two 'long' files
c. Use CASESTOVARS to create a single record per ID

-Good luck,
Richard

------------------------------

Date: Mon, 5 Mar 2007 21:38:13 -0500
From: Richard Ristow <[hidden email]>
Subject: Re: SPSS warning from regression

At 05:50 PM 3/5/2007, Yifan Lu wrote:

>I am running multiple regression, but SPSS keeps telling me:
>
>>Warnings
>>There are no valid cases for models with dependent variable alldays.
>>Statistics cannot be computed.
>>No valid cases found. Equation-building skipped.
>
>Anybody also had such problem before? Any suggestions to fix the
>problem? Thank you!

The default (and recommended) practice for regression is 'listwise
deletion': a case is excluded if any of the dependent or independent
variables is missing. The problem you describe can arise when you lose
all data because each case has some variable missing.

>I checked the data and it seems all right. I also ran descriptives and
>the results come out right.

Descriptives won't tell you enough; they give the statistics on single
variables, not on all of them together.

Look at your variables, especially for
. Any that are missing for a large proportion of the cases
. Any that may be mutually exclusive - if one is present, the other
will be missing

In principle, you could get your problem from plain bad luck: you don't
have much missing data, but by chance every case has some missing
variable. (In this case, missing value imputation may be warranted.)

More commonly, though, there's something in the structure of your data
that ensures you don't have complete data for any case. Look for that
first.

-Good luck,
Richard Ristow

------------------------------

Date: Mon, 5 Mar 2007 20:41:16 -0600
From: "Beadle, ViAnn" <[hidden email]>
Subject: Re: SPSS warning from regression

When you ran descriptive, did you include all the variables used in
regression? If so, what is the listwise N shown in the descriptives output?
If any variable used in the regression has a missing value, that case is
excluded from the analysis.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Yifan Lu
Sent: Monday, March 05, 2007 4:50 PM
To: [hidden email]
Subject: SPSS warning from regression

Dear list,

I am running multiple regression, but SPSS keeps telling me:

Warnings

There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.

I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!

Regards,

Yifan Lu

------------------------------

Date: Tue, 6 Mar 2007 08:25:56 +0530
From: Manmit Shrimali <[hidden email]>
Subject: Re: Looping and merging syntax support

Image ID as physician who gives multiple patient record. So one
physician can give multiple records so his ID will appear multiple
times. Also, I want a separate record for each trip, so each
person ('ID') has as many records as they have trips, from the two
files combined. If they stayed in hotel it will be 1 and if not 0. If
they are not eligible to answer then sysmis.

So you have 'wide' organization in both files - multiple trips per
record. And you want 'wide' organization afterward - one record per ID,
with all the person's trips in that record. THIS IS RIGHT. Let me try
var to case.

Thanks Richard for your input.

-----Original Message-----
From: Richard Ristow [mailto:[hidden email]]
Sent: Tuesday, March 06, 2007 7:59 AM
To: Manmit Shrimali; [hidden email]
Subject: Re: Looping and merging syntax support

At 08:50 PM 3/5/2007, Manmit Shrimali wrote:

>Hope I have communicated in required form.

Not quite. You've given the list of *DATA* variables in the files, but
not the *IDENTIFYING* variables in the files.

>File 1 has 150 records and file 2nd has 150 records. The data is from
>hotel so there can be multiple same ID's in both the file.

Where an ID represents a person? So each person can occur more than
once in each file?

>I don't need to have one record for multiple ID's.

No. The question is, whether you need to reduce to a single record for
*one* ID. Or, do you want a separate record for each trip, so each
person ('ID') has as many records as they have trips, from the two
files combined?

>Q36_Marriott_5
>q36_Hyatt_5
>Q36_Four_season_5

Are these yes/no variables? That is, one will be 'yes' and the other
two 'no', depending on which of the three hotels they stayed in?

>Variables in file 1 (2000>). Maximum file cycles so if someone says 11
>as total trips, and was on 9th trip in year 2000 then we will ask the
>cycle for 10th, and 9th trip as pre-2000 we ask in file 2.

So you have 'wide' organization in both files - multiple trips per
record. And you want 'wide' organization afterward - one record per ID,
with all the person's trips in that record.

If that's right, I recommend that
a. In each file, you use VARSTOCASES to create 'long' organization -
one record per trip, with each ID having as many records as there are
associated trips
b. Use ADD FILES to merge the two 'long' files
c. Use CASESTOVARS to create a single record per ID

-Good luck,
Richard

------------------------------

Date: Tue, 6 Mar 2007 08:54:00 +0530
From: Manmit Shrimali <[hidden email]>
Subject: Re: Looping and merging syntax support

Richard and all:

Vartocase is not working efficiently. Can you please help me writing
syntax for following:
1. Create a vector that contains information of variable X1 to X22.
Variables are in order. So I believe I will write vector X=X1 to X22.
2. Create another vector that contains information of variable Y1 to Y22
so it will be vector Y=Y1 to Y22.
3. In every cell cell of X I want to inpute value of Y i.e. X1 should
have value of Y1, X2 should have value of Y2, X3 should have value of
Y3.

If you can help me writing loop for the above situation, I think I am
able to solve my problem.

-----Original Message-----
From: Richard Ristow [mailto:[hidden email]]
Sent: Tuesday, March 06, 2007 7:59 AM
To: Manmit Shrimali; [hidden email]
Subject: Re: Looping and merging syntax support

At 08:50 PM 3/5/2007, Manmit Shrimali wrote:

>Hope I have communicated in required form.

Not quite. You've given the list of *DATA* variables in the files, but
not the *IDENTIFYING* variables in the files.

>File 1 has 150 records and file 2nd has 150 records. The data is from
>hotel so there can be multiple same ID's in both the file.

Where an ID represents a person? So each person can occur more than
once in each file?

>I don't need to have one record for multiple ID's.

No. The question is, whether you need to reduce to a single record for
*one* ID. Or, do you want a separate record for each trip, so each
person ('ID') has as many records as they have trips, from the two
files combined?

>Q36_Marriott_5
>q36_Hyatt_5
>Q36_Four_season_5

Are these yes/no variables? That is, one will be 'yes' and the other
two 'no', depending on which of the three hotels they stayed in?

>Variables in file 1 (2000>). Maximum file cycles so if someone says 11
>as total trips, and was on 9th trip in year 2000 then we will ask the
>cycle for 10th, and 9th trip as pre-2000 we ask in file 2.

So you have 'wide' organization in both files - multiple trips per
record. And you want 'wide' organization afterward - one record per ID,
with all the person's trips in that record.

If that's right, I recommend that
a. In each file, you use VARSTOCASES to create 'long' organization -
one record per trip, with each ID having as many records as there are
associated trips
b. Use ADD FILES to merge the two 'long' files
c. Use CASESTOVARS to create a single record per ID

-Good luck,
Richard

------------------------------

Date: Tue, 6 Mar 2007 10:10:14 +0530
From: Nivruti Hinge <[hidden email]>
Subject: Re: SPSS warning from regression

One of the dependent variable must be having many missing values so please
check for the missing values in the dependent variable list.

-Regards,
Nivruti Hinge
Senior Member Of Technical Staff
Persistent Systems Pvt. Ltd.
http://www.persistentsys.com
Direct : +91 (20) 30235627

____________________________________________________________________________
_______________
Persistent Systems - Software Development Partner for Competitive Advantage.
Persistent Systems provides custom software product development services.
With over 15 years, 140 customers, and 700 release cycles experience, we
deliver unmatched value of higher quality, faster time to market and lower
total costs.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Yifan Lu
Sent: Tuesday, March 06, 2007 4:20 AM
To: [hidden email]
Subject: SPSS warning from regression

Dear list,

I am running multiple regression, but SPSS keeps telling me:

Warnings

There are no valid cases for models with dependent variable alldays.
Statistics cannot be computed.

No valid cases found. Equation-building skipped.

I checked the data and it seems all right. I also ran descriptives and
the results come out right. Anybody also had such problem before? Any
suggestions to fix the problem? Thank you!

Regards,

Yifan Lu

DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the
property of Persistent Systems Pvt. Ltd. It is intended only for the use of
the individual or entity to which it is addressed. If you are not the
intended recipient, you are not authorized to read, retain, copy, print,
distribute or use this message. If you have received this communication in
error, please notify the sender and delete all copies of this message.
Persistent Systems Pvt. Ltd. does not accept any liability for virus
infected mails.

------------------------------

End of SPSSX-L Digest - 4 Mar 2007 to 5 Mar 2007 (#2007-65)
***********************************************************

Will
Statistical Services

============
info.statman@earthlink.net
http://home.earthlink.net/~z_statman/
============