Math Forum / Math Software / SPSS / February 2010

In a data set with 1000 cases and 30 variables (all with values of 1,
0, and missing), I want to recode a random selection of 1's and 0's so
that, WITHIN EACH VARIABLE, the count of 1's equals the count of 0's.
I have only a limited knowledge of SPSS syntax and can't figure out

I'm working with large numbers, and can't tell at a glance whether a number
is millions, tens of millions, hundreds of millions, billions, or what. I
have to copy output tables (from crosstabs, frequencies, etc.) into Excel so
I can see the numbers with commas.

Being fairly new to SPSS I have the following question. Currently Im
doing research on European Union decision making decision making
efficiency (just started).
The EU has 27 states. In order to approve legislative proposals 55

When I run the following syntax following a CORRELATION command it
works fine,changing format/colour in the Significance cells of the
output table:
SPSSINC MODIFY TABLES subtype="'Correlations'"

I have two sets of data with the following descriptives:
Group 1 Mean- .02 Std.- .154
Group 2 Mean- .02 Std.- .154
I would expect my output to have a very low F statistic because the

Hi, all,
I'm trying to re-arrange a dataset so that the first non-missing value
in each row is reassigned to a new column/variable (e.g., the
second).  I need to arrange typical calendar data so that it reflects

I have a large dataset with blood sample results as string variables
due to a possible outcome of <0,01 (not my choice - the lab send me
the results in an excel spreadsheet formatted this way)
.

Im new to SPSS so if anyone can point me in the right direction I'd be
very grateful. I have a data set that is arranged as:
Date Result
11.01.99    20

I keep running across this error when I try to run my SPSS model: "no
valid cases found.  this command cannot be executed."
I am told this is probably because I didn't merge or code my variables
properly.  How do I track where my error is?

I have some data with 3 string fields.
What I want to do is to create a new string variable
which is a concatenation of the three variables.
This will eventually become a label.

I have a list of 40 variables and a score for each respondent for each
variable.  How can I create a rank for each respondent and each
variable, similar to the MS Excel formula "=RANK(C1,$C1:AP1)"
Matthias

I have a sav file, which I exported from SAS 9.2 using PROC EXPORT
with DBMS SPSS. The file's encoding is UTF-8. One of its columns has
various national characters (Chinese, Russian, ..). When I re-import
the file into SAS right away, everything is fine. The national

hey all,
I'm not sure which analysis is better in order to analysis dichotomic
dependent variables:
discriminant or logistic reression?

In case you're not already aware, I've just come across an interesting bug
affecting the display of dates in SPSS:
Instead of issuing an error message SPSS displays a wrong date when
calculating date variables from incorrect input data in months with fewer

Hey all,
Using python to zip a file.  I typically have a macro at the top of my
syntax file that defines the working directory.  I'm trying to run that
macro in python so I can zip a file.  Can you run a macro through