Archive for March, 2006

SPSS video lessons

The statistics department of the Texas A&M university has a great website, were you can watch spss video lessons. At this site you can watch how to split a file or how to make a scatter plot.

6 comments March 31st, 2006

Question: How to store each subset after splitting a file

Question: Hi all!

After a SPLIT command applied to my file, I would like each generated subset
of data to be saved in a different .sav file.

Is there an easy way to do that using SAVE or XSAVE?

Even if SPSS can manage each subset separately, I did not find how to save
each subset separately.
Do not hesitate if I am not clear enough or if you need more information.

My data is organized as follows:
Source Destination other variable
david Stefan 123
Nico Bruce 213
Nico Stefan 333
Stefan Nico 2
david Stefan 5
Stefan Nico 56

I want to split my file according to each unique combination
, hence, I use:

SPLIT FILE SEPARATE BY Source Destination.
Hence I have my data sorted as I need:
Source Destination other variable
david Stefan 123
david Stefan 5
Nico Bruce 213
Nico Stefan 333
Stefan Nico 2
Stefan Nico 56

Now, what I need, is to have all the records for each distinct pairto a different file.
Assuming that my first file is called file.sav, I would like to have:
file_david_Stefan.sav with all records with
file_Nico_Bruce.sav with all records with
file_Nico_Stefan.sav with all records with
and so on…
Thanks you for your help.

Answer: Here is the better way.DO IF source=?david? and destination=’Stefan’.
XSAVE OUTFILE=?file_david_Stefan.sav?.
ELSE IF source=?Nico? and destination=’Bruce’.
XSAVE OUTFILE=?file_Nico_Bruce.sav?.

Do you also need an answer on your spss question, submit your question here.

2 comments March 26th, 2006

MicroStrategy and SPSS form alliance.

Software companies MicroStrategy Inc. and SPSS Inc. said on Wednesday they have formed an alliance for business development and cooperative marketing.

The two companies signed an agreement to combine MicroStrategy’s business intelligence technology with SPSS’ predictive analytics software, they said in a statement. No financial details were given.

(source: Reuters)

March 26th, 2006

How to split a SPSS-file in two or more groups.

Sometimes you want to split your data file in separate groups for analysis

Its a easy thing to do in SPSS. From the menus choose:
Data > Split File

This opens the Split File dialog box.


Select Compare groups or Organize output by groups. The examples following these steps show the differences between these two options.

Select Gender (gender) to split the file into separate groups for these variables. You can use numeric, short string, and long string variables as grouping variables. A separate analysis is performed for each subgroup defined by the grouping variables. If you select multiple grouping variables, the order in which they appear on the Groups Based On list determines the manner in which cases are grouped.

If you select Compare groups and run the Frequencies procedure, a single pivot table is created.

If you select Organize output by groups and run the Frequencies procedure, two pivot tables are created: one for females and one for males.

2 comments March 22nd, 2006

Coding editor with SPSS syntax highlighting

I am also writing webpages, and code (X)HTML and PHP by hand. If you code by hand, any code, and also SPSS syntax code, than it is very usefull to have syntax highlighting. Syntax highlighting is a feature of text / code editors that highlights or colourises code. By colourizing code you can very easily recognise types of code.

Recently in the SPPS newsgroup (comp.soft-sys.stat.spss, read it with Google Groups) there has been a discussion or question started by Aldo Cimino on this matter. The answers in the discussion where pointing at the FAQ of where you can find an explanation on using Textpad to edit SPSS syntax. ZEUS Editor also supports adding a new language to their definitions. VIM Editor has a file which supports SPSS Syntax, you could try that one, but the author already mentions it needs updating. Crimson Editor already has a SPSS package ready. If you decide to use one of the mentioned tools, or have other suggestions, please let us know! We would be happy to publish your experiences.

12 comments March 20th, 2006 andris

How to change the look of a table

The look and feel of your tables are a critical part of providing clear, concise, and meaningful results. For example, if your table is difficult to read, the information contained within that table may not be easily understood.

In this log we will introduce the tablelook option in SPSS.

Double-click the table.

From the menus choose: Format > Tablelook

The TableLooks dialog box lists a variety of predefined styles. Select a style from the list to preview it in the Sample window to the right.
You can use a style as is, or you can edit an existing style to better suit your needs. To use an existing style, select one and click OK.

Although you can change the format of a table after it has been created, it may be more efficient to change the default TableLook so that you do not have to change the format every time you create a table. To change the default TableLook style for your pivot tables, from the menus choose:

Edit > Options> Pivot Tables

Select the TableLook style that you want to use for all new tables. Click OK to save your settings and close the dialog box. All tables that you create after changing the default TableLook automatically conform to the new formatting rules.

(Source: SPSS 12.0 Brief guide)

4 comments March 17th, 2006

Hello world! Here’s :)

We are Mark and Andris, two SPSS users in our daily professional life. We have started this blog simply because there is no SPSS log. At least not one we could find :)
We hope to be of help to all the people using SPSS and looking for information, how-to’s and tips on SPSS.

1 comment March 10th, 2006 andris


March 2006
    Apr »

Posts by Month

Posts by Category