Math Forum / Math Software / SPSS / November 2005

Hello everyone does anyone know the how to convert a string variable to a numeric variable. I have read a data set from a SQL server and recoded the strings to numbers but I can when I change the variable to a numeric it erases all my values. Can anyone help?

Hi, All,
I was trying to do power analysis using power calculator from ucla website.
I did t-test on a variable A between two independent groups. Data are shown
below.

I need to access specific content of one SPSS system file based on the
conditional processing in another.
For example,
get 'File1.sav' .

I want to run a hierarchical cluster analysis.
However, I am unsure how to define my measure.
What's the difference between Interval and Count? Is there anywhere
where I can find samples?

I have tried to search this group for an answer, but need to appeal to
all for help.  I have a 10,000 case data set consisting of demographic
data in categorical format.  The data set is for a group of people, and
the IV I ultimately am looking at is whether they stay in the group ...

When I load a dataset from syntax or from the menu system, how can I control
whether SPSS will replace the data already loaded in the data editor window
or  open a new one?

Does anyone know how to create a macro that can write CSV files with
the first row as the variable name (comma separated), and the
subsequent rows as the comma separated values?
This macro writes school level CSV files from a large SPSS file.

When reading an ODBC data source with "GET CAPTURE ODBC ... /select * ...",
SPSS 14 imports the database fields in alphabetical order. Previous versions
(up to 13) used to import the fields in the order in the database file,
which I prefer.

 I need to obtain either LSD or Duncan PostHoc results
for a Repeated Measures factor.  SPSS doesn't provide
this as an option.  Anybody have a solid correct solution?
Am I stuck with running all possible paired t-tests and

i hav jst started my professional career in SPSS n want to know tht how
2 start 2 make a great career in analytics.
please HELP.........
ill b very thankful to all of those who rply.......

I was wondering if I can set an option and maybe a path so that SPSS
does not create an SPO output each time I run a command but creates (and
maybe saves) it as HTML in the first place, so that I do not need to
manually save it everytime, since I have 100s maybe 1000s of outputs ...

Hi all I'm using a Macro to run a set of procedures for each level of a
categorical variable (region), I am wondering if it is possible to put
each set of identical set of procedures from each level of the
categorical variable into a new outputs.

I would really appreciate someone's help with this, as I am stuck :-(!
I am looking at White Blood Cell Counts in patients before and after a
certain treatment.  I have two types of patients: those that responded
to the treatment and those that did not (based on an assessment not

I have a large number of categorical, ordinal, and scale variables, and
want to find out which ones may be related.  Can someone confirm or
correct the following method?
(1) Run chi-square crosstabs for all categorical vs categorical