Questions tagged [spss]

SPSS is a statistics package. Originally released in 1968, it is currently owned by IBM.

SPSS (Statistical Package for the Social Sciences) is a proprietary cross-platform general-purpose statistical software package. Originally released in 1968, it is currently owned by IBM. SPSS's homepage

Versions 17 and 18 of SPSS were renamed with the acronym PASW (for Predictive Analytics SoftWare), but with version 19 it has been renamed to SPSS (see Wikipedia for a history of the name changes). One unique aspect of SPSS software compared to other popular propriety software packages (such as Stata or SAS) is the built in functionality to call Python or R commands within syntax. Otherwise it is largely comparable to other general proprietary and freeware packages (such as R), although it differs in some advanced statistical capabilities and aspects of data manipulation.

Suggested readings on using SPSS and learning the command syntax are two online PDF's.

Other useful print versions are

Other forums entirely devoted to the software are (and suggested material to search when encountering a problem with SPSS are):

Other suggested webpages are

PSPP is a free-ware, open source alternative largely mimicking the look and functionality of SPSS. You can also use SPSS with other software like R.

2084 questions
4
votes
2 answers

Compute the Sum of Columns in SPSS

I have a lot of columns in SPSS and for a calculation, I need to get the sum of each and every one of them. Is there a way to do this in SPSS? An example of what I mean is shown below: age gender question 1 question…
Ehsan
  • 197
  • 2
  • 2
  • 10
4
votes
1 answer

Spss syntax how to list values with labels

I like using the list command in spss but it can get confusing when it prints in the output the number that corresponds to the category and not the label. For example: Data list list / id var1 var2. BEGIN DATA. 1, 2, 2 2, 2, 2 3, 1, 1 END…
BigQ
  • 43
  • 3
4
votes
1 answer

Is there a variable listing in RStudio (or R) like in SPSS?

RStudio provides a nice function View (with uppercase V) to take a look into the data, but with R it's still nasty to get orientation in a large data set. The most common options are... names(df) str(df) If you're coming from SPSS, R seems like a…
BurninLeo
  • 4,240
  • 4
  • 39
  • 56
4
votes
2 answers

R haven: missing labels and label names when reading spss file

I'm using the haven package for R to read an spss file with user_na=TRUE. The file has many string variables with value labels. In R only the first of the string variables (SizeofH1) has the correct value labels assigned to it as attribute.…
supersambo
  • 811
  • 1
  • 9
  • 25
4
votes
1 answer

Change All Value Labels to Numerics in SPSS

I need to change all the value labels of all my variables in my spss file to be the value itself. I first tried - Value Labels ALL. EXECUTE. This removes the value labels, but also removes the value entirely. I need this to have a label of some…
PTrem1
  • 109
  • 5
4
votes
1 answer

How to see a list of SPSS macros presently defined

Does anyone know of a way to get a list of macros presently loaded to memory (i.e. the define-!enddefine command has been run)? Also, is there a way to see the full macro definitions - from memory?
eli-k
  • 10,898
  • 11
  • 40
  • 44
4
votes
2 answers

Which function in SPSS emulates R summary() function?

I'm switching from R to SPSS for a specific project (I'm not allowed to use SPSS/R integration) and need to summarize quickly a big dataset. In R, it's quite simple, one can use the summary() function and in few seconds obtain the summary of each…
José Vallejo
  • 356
  • 4
  • 17
4
votes
3 answers

Filtering cases based on response completion

I'm currently attempting to clean a rather large dataset, however, I have noticed that a significant amount of participants failed to complete the survey, or did not even respond to the first question. Nevertheless, their data was included in my…
Olivier
  • 321
  • 2
  • 11
4
votes
0 answers

SPSS: how to create .sav file from database

We are currently building a database (MongoDB), where we offer an export of the data in .csv and .xlsx formats. We received requests to offer also a .sav download of the data, since data manipulation (variable and value labels, missing) takes quite…
huan
  • 308
  • 3
  • 15
4
votes
3 answers

Strip suffix from all variable names in SPSS

I have a dataset in which every variable name has the suffix "_1" (this was done to indicate the first interview timepoint). I want to remove this suffix from all variables, but there are hundreds of them, so I am looking for a way to do it without…
cambridge1
  • 43
  • 3
4
votes
2 answers

SPSS syntax: how can I generate a var_list of all variables from the active dataset?

Frequently, PSPP/SPSS syntax documentation (example) suggests I must to pass a list of variables with /VARIABLES=var_list and this is not an optional subcommand. But I have a lot of datasets to process. I would like to programmatically get a list of…
Martin Burch
  • 2,726
  • 4
  • 31
  • 59
4
votes
2 answers

How can I export SPSS custom tables to a specific Excel sheet without the SPSS?

I want to put different custom tables to different sheets in Excel. I tried with OMS and OUTPUT EXPORT but that functions not do what I want. If somebody have idea I hope that will help me. :)
Mira
  • 41
  • 2
4
votes
5 answers

Export spss custom tables

I want to export several spss custom tables to excel. I want to export just the tables and exclude the syntax. I tried to select all and exclude if, but I am still getting all of the output.
oana
  • 39
  • 1
  • 5
4
votes
3 answers

SPSS macro command

I need to run the below in SPSS: if (event_duration = 0) Acti_Activity = Activity. if (event_duration = 1) Acti_Activity = MEAN (Activity, Activity_1). if (event_duration = 2) Acti_Activity = MEAN (Activity, Activity_1, Activity_2). …all the way up…
Dan
  • 41
  • 1
4
votes
1 answer

SPSS macro for splitting single numeric variables to multiple variables

I have a variable named A in SPSS database. A -- 102102 23453212 142378 2367890654 2345 45 I want to split this variable by 2 lengths and create multiple variables as follows. A_1 A_2 A_3 A_4 A_5 --- --- --- --- --- 10 21 …