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

Hey all,
Is there a way to check if a VAR exists (or does not exist) and create
it if it does not exist.
I have a script that someone else wrote that uses a variable called

I am unable to create any new data files, using SPSS v 13.0, after not
having used it for a few weeks. When trying to create a new file
(either by typing some data or by defining a variable - and then
either using the "Save" command from the menu or the SAVE OUTFILE=...

I have a grant application due tommorow and it suddenly occured to me
that I really don't know how to cite the program anymore (AMA style -
in text, not the bibilo).
Is it PASW Statistics v. 17.0.3 (SPSS: An IBM Company).  Seems a bit

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