- Welcome
- Important notice
- About the author
- About this site
- Site guide + Search box
- Dedications
- Acknowledgments
- My personal pantheon (of the great and the good in survey research)
- Recent and planned activities
- Textbooks for Research Methods and Data Analysis
- 1: Survey Analysis Workshop (SPSS)
- 1a: Statistical concepts and methods
- 1b: Teaching with Survey Data
- 1c: Developing research projects using survey data
- 1d: Workshop and presentations for ASSESS (SPSS users in Europe)
- 2: Survey Research Practice
- 2a: Survey Research Methodology, Practice and Training
- 2b: Major survey series
- 3: Subjective Social Indicators (Quality of Life)
- 4: Survey Unit, Social Science Research Council (UK)
- 5a: Polytechnic of North London (1976-1992)
- 5b: Survey Research Unit (1978-1992)
- Village life in Normandy
- Contact
- Origins of the British Crime Survey
- British Crime Survey
Old Dog, Old Tricks: Using SPSS syntax to beat the mouse-trap
[Page last updated 8 March 2016]
I took on this project after my experience of having to learn and use SPSS 11 for Windows in 2002 in order to review Julie Pallant's SPSS Survival Manual (1st edition, Open University Press, 2001) for the (UK) Social Research Association. There is now a 6th edition, fully revised and updated for IBM SPSS Statistics version 23 (Allen and Unwin, 2016 ). I'd been a user and teacher of SPSS from 1971 until I took early retirement in 1992, but only ever on mainframes (latterly SPSS-X 8 on a Vax cluster with VMS and EDT). Before 2002 I'd never even used Windows, Word or PowerPoint, but only DOS and WordStar.
I cannot describe how much stress this entailed. I came to hate the indiscriminate use of mouse-clicks and drop-down menus, so check out the apposite mouse movie to see how I felt, then read the paper and/or watch the slide shows and learn a thing or two! The whole thing took hundreds of hours spread over several months: altogether a very steep learning curve and extremely painful until I bought a wrist pad! However it was a worthwhile exercise and led directly to the development of this website.
This presentation was specially prepared for the annual meeting of ASSESS (European SPSS users) held at the University of York in 2006. It draws on my experiences:
First, of using SPSS from 1971 to 1993, on a range of mainframe computers to process and analyse dozens of surveys:
Second, of training several hundred researchers and students in the use of SPSS via the hands-on Survey Analysis Workshop I developed and taught at the Polytechnic of North London from 1976 until I (early) retired in 1992:
Third (from 2002 to 2006) of using SPSS11 for Windows to restore, convert and update surveys and training materials:
Fourth, of using SPSS to explore data files from major surveys in the in the public domain:
Fifth, of wrestling with the wretched mouse to replicate drop-down menu exercises from the early part of Julie Pallant’s SPSS Survival Manual (Open University Press, 1st edition 2001 and 2nd edition, 2004) when, most of the time, it’s much easier and far quicker to use direct syntax.
It covers:
1: Survey processing before SPSS (and computers).
Origins of SPSS and its arrival in the UK.
2: Conventions for design and construction of SPSS saved files, layout of SPSS setup files, naming and
labelling of variables, documentation, and a trick or two.
Changes to SPSS syntax and output format over
the years.
Development of, and constraints on, design and delivery of courses and training materials.
3: Critical examination of SPSS usage in major surveys (eg British Social Attitudes 1987, European Social
Survey 2002)
4: Comparisons of syntax with point-and-click for ease of use, clarity and speed.
5: Execution of, and detailed commentary on, exercises from Julie Pallant SPSS Survival Manual
(1st editon 2001 and 2nd edition, 2005)
For each section, there are separate accompanying slide shows (good fun: listed below)
Old Dog, Old Tricks: Using SPSS syntax to defeat the mouse trap
Abstract and contents (2pp) [pdf]
Main paper (77pp, ) [pdf]
Full text of main presentation to ASSESS (SPSS Users) York Univ. (UK) Dec 2006 (4606 kb)
Appendices are in pdf format.
Appendix 1 How SPSS came to the UK
Appendix 2 Survey Analysis Workshop (Original syllabus and specimen assessment, 1991-92)
Appendix 3 Forensic notes (blow-by-blow account of heroic efforts to learn Windows, Word and SPSS
for Windows by retrieving and re-processing my old surveys),
Slide-shows: (The first one is fun and not fully covered in the text: there's a joke at the end of the fifth
one, but will you get it?)
1: Survey processing before SPSS (and personal computers). Origins of SPSS and its arrival in the
UK, first Edinburgh, then spread like wildfire.
2: Layout of SPSS setup files Conventions for design and construction of SPSS saved files, naming and
labelling of variables, documentation, and a trick or two.
Changes to SPSS syntax and output format over the years.
Development of, and constraints on, design and delivery of courses and training materials.
3: SPSS usage in major surveys Critical examination of SPSS usage in British Social Attitudes 1987 and
European Social Survey 2002.
4: Comparisons of syntax with point-and-click for ease of use, clarity and speed.
5: Exercises from Julie Pallant SPSS Survival Manual Execution of, and detailed commentary on,
exercises in the 1st edition 2001 and 2nd edition, 2004.
I took on this project after my experience of having to learn and use SPSS 11 for Windows in 2002 in order to review Julie Pallant's SPSS Survival Manual (1st edition, Open University Press, 2001) for the (UK) Social Research Association. There is now a 6th edition, fully revised and updated for IBM SPSS Statistics version 23 (Allen and Unwin, 2016 ). I'd been a user and teacher of SPSS from 1971 until I took early retirement in 1992, but only ever on mainframes (latterly SPSS-X 8 on a Vax cluster with VMS and EDT). Before 2002 I'd never even used Windows, Word or PowerPoint, but only DOS and WordStar.
I cannot describe how much stress this entailed. I came to hate the indiscriminate use of mouse-clicks and drop-down menus, so check out the apposite mouse movie to see how I felt, then read the paper and/or watch the slide shows and learn a thing or two! The whole thing took hundreds of hours spread over several months: altogether a very steep learning curve and extremely painful until I bought a wrist pad! However it was a worthwhile exercise and led directly to the development of this website.
This presentation was specially prepared for the annual meeting of ASSESS (European SPSS users) held at the University of York in 2006. It draws on my experiences:
First, of using SPSS from 1971 to 1993, on a range of mainframe computers to process and analyse dozens of surveys:
Second, of training several hundred researchers and students in the use of SPSS via the hands-on Survey Analysis Workshop I developed and taught at the Polytechnic of North London from 1976 until I (early) retired in 1992:
Third (from 2002 to 2006) of using SPSS11 for Windows to restore, convert and update surveys and training materials:
Fourth, of using SPSS to explore data files from major surveys in the in the public domain:
Fifth, of wrestling with the wretched mouse to replicate drop-down menu exercises from the early part of Julie Pallant’s SPSS Survival Manual (Open University Press, 1st edition 2001 and 2nd edition, 2004) when, most of the time, it’s much easier and far quicker to use direct syntax.
It covers:
1: Survey processing before SPSS (and computers).
Origins of SPSS and its arrival in the UK.
2: Conventions for design and construction of SPSS saved files, layout of SPSS setup files, naming and
labelling of variables, documentation, and a trick or two.
Changes to SPSS syntax and output format over
the years.
Development of, and constraints on, design and delivery of courses and training materials.
3: Critical examination of SPSS usage in major surveys (eg British Social Attitudes 1987, European Social
Survey 2002)
4: Comparisons of syntax with point-and-click for ease of use, clarity and speed.
5: Execution of, and detailed commentary on, exercises from Julie Pallant SPSS Survival Manual
(1st editon 2001 and 2nd edition, 2005)
For each section, there are separate accompanying slide shows (good fun: listed below)
Old Dog, Old Tricks: Using SPSS syntax to defeat the mouse trap
Abstract and contents (2pp) [pdf]
Main paper (77pp, ) [pdf]
Full text of main presentation to ASSESS (SPSS Users) York Univ. (UK) Dec 2006 (4606 kb)
Appendices are in pdf format.
Appendix 1 How SPSS came to the UK
Appendix 2 Survey Analysis Workshop (Original syllabus and specimen assessment, 1991-92)
Appendix 3 Forensic notes (blow-by-blow account of heroic efforts to learn Windows, Word and SPSS
for Windows by retrieving and re-processing my old surveys),
Slide-shows: (The first one is fun and not fully covered in the text: there's a joke at the end of the fifth
one, but will you get it?)
1: Survey processing before SPSS (and personal computers). Origins of SPSS and its arrival in the
UK, first Edinburgh, then spread like wildfire.
2: Layout of SPSS setup files Conventions for design and construction of SPSS saved files, naming and
labelling of variables, documentation, and a trick or two.
Changes to SPSS syntax and output format over the years.
Development of, and constraints on, design and delivery of courses and training materials.
3: SPSS usage in major surveys Critical examination of SPSS usage in British Social Attitudes 1987 and
European Social Survey 2002.
4: Comparisons of syntax with point-and-click for ease of use, clarity and speed.
5: Exercises from Julie Pallant SPSS Survival Manual Execution of, and detailed commentary on,
exercises in the 1st edition 2001 and 2nd edition, 2004.